删除一条数据
<%@ page language="java" contentType="text/html; charset=UTF-8" import="java.sql.*"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>删除一条记录页面</title>
</head>
<body>
<% String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=zero";
//连接服务器和数据库
String userName = "sa"; // 默认用户名
String userPwd = "123456"; // 密码
Connection dbConn = null;
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
} catch (Exception e) {
e.printStackTrace();
}
request.setCharacterEncoding("UTF-8");//设置字符编码，避免出现乱码
String sql="delete from stu_info where weight>=?";//sql语句
PreparedStatement pstmt=dbConn.prepareStatement(sql);//创建接口对象
pstmt.setFloat(1, 60);
//pstmt.setString(2, "嘻嘻");
int n=pstmt.executeUpdate();//这里面不需要参数
if(n>=1){%> 数据删除成功！<br> <%}
else{%> 数据删除失败！<br> <%}
if(pstmt!=null) {pstmt.close();}
if(dbConn!=null) {dbConn.close();}
%>
</body>
</html><%@ page language="java" conten
