52,797
社区成员
发帖
与我相关
我的任务
分享大神帮忙看看哪里出错了
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
<title>My JSP 'delete2.jsp' starting page</title>
</head>
<body>
<% String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPwd="";
String dbName="students";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String ww1=request.getParameter("w1");
String ww2=request.getParameter("w2");
String s="1=1";
if(!name.equals(""))s=s+"and name="+name+"";
if(sex!=null)s=s+"and sex="+sex+"";
float w1,w2;
if(!ww1.equals("")){w1=Float.parseFloat(ww1);s=s+"and weight>="+w1;}
if(!ww2.equals("")){w2=Float.parseFloat(ww2);s=s+"and weight>="+w2;}
String sql="dalete from stu_info where"+s;
PreparedStatement stmt=conn.prepareStatement(sql);
int n=stmt.executeUpdate();
if(n==1){%>数据删除成功！<br><%}
else{%>数据删除失败<br><%}
if(stmt!=null){stmt.close();}
if(conn!=null){conn.close();}
%>
</body>
</html>
<html>
<head>
<title>My JSP 'delete2.jsp' starting page</title>
</head>
<body>
<% String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPwd="";
String dbName="students";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
request.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String ww1=request.getParameter("w1");
String ww2=request.getParameter("w2");
String s="1=1";
if(!name.equals(""))s=s+"and name="+name+"";
if(sex!=null)s=s+"and sex="+sex+"";
float w1,w2;
if(!ww1.equals("")){w1=Float.parseFloat(ww1);s=s+"and weight>="+w1;}
if(!ww2.equals("")){w2=Float.parseFloat(ww2);s=s+"and weight>="+w2;}
String sql="dalete from stu_info where"+s;
PreparedStatement stmt=conn.prepareStatement(sql);
int n=stmt.executeUpdate();
if(n==1){%>数据删除成功！<br><%}
else{%>数据删除失败<br><%}
if(stmt!=null){stmt.close();}
if(conn!=null){conn.close();}
%>
</body>
</html>
...全文
请发表友善的回复…
发表回复
d_keep 2018-01-01
- 打赏
- 举报
能给个jsp+javabean+servlet简单的增添删改代码吗
d_keep 2018-01-01
- 打赏
- 举报
解决了，谢谢您
catfishlyf 2017-12-25
- 打赏
- 举报
你具体出现了什么问题，是数据库没连上，还是获取不到name、sex、w1、w2的值，还是最后的删除操作不成功，有报错吗
