<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="textcml;charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<body>
<%
// try {
// tagAdd obj = new tagAdd(); // 实例化包含 delete 方法的类
//
// // 调用 delete 方法,并传入 request 和 response 参数
// obj.delete(request, response);
// } catch (SQLException e) {
// // 处理 SQLException 异常
// e.printStackTrace();
// } catch (ClassNotFoundException e) {
// // 处理 ClassNotFoundException 异常
// e.printStackTrace();
// }
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/baijiu?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, user, password);
String getTname=request.getParameter("DTname");
System.out.println(getTname);
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
if (conn == null) {
System.out.println("连接失败");
} else {
System.out.println("success");
String sql="delete from tag where TName=?";
PreparedStatement ps = conn.prepareStatement(sql);
//给占位符赋值
ps.setString(1, getTname);
System.out.println(sql);
if (ps.executeUpdate() >= 0) {
System.out.println("success");
} else {
System.out.println("fail");
}
conn.close();
}
%>
</body>
<html>
使用这个函数对数据库删除读出来都是问号,运行结果如图