关于今天所编写的删除部分，虽有瑕疵，但是效果不错。。
public void deletedata(String shijian)
{
Connection connection = getConnection();
PreparedStatement preparedStatement=null;
try {
String sql = "delete from test where shijian = ?";
preparedStatement=connection.prepareStatement(sql);
preparedStatement.setString(1,shijian);
preparedStatement.executeUpdate();
//System.out.println("删除成功");
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(preparedStatement);
close(connection);
}
}
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<jsp:useBean id="test" class="test.Data" scope="page" />
<%
String shijian=(String)request.getParameter("shijian");
if(shijian==""){
out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
}
else if(!test.isSame(shijian))
{
out.print("<script language='javaScript'> alert('该活动主题不存在'); window.history.back(-1); </script>");
}
else {
%>
<table border="1"style="text-align:center;">
<tr>
<td align="center" width=10%>日期</td>
<td align="center" width=10%>每日关键字</td>
<td align="center" width=10%>每日总结</td>
<td align="center" width=10%>坚持天数</td>
<td align="center" width=10%>连续最高时长</td>
</tr>
<%
Connection connection = test.getConnection();
PreparedStatement preparedStatement=null;
ResultSet rs=null;
try {
String sql = "select * from test";
preparedStatement=connection.prepareStatement(sql);
rs=preparedStatement.executeQuery();
while(rs.next()){
if(test.equals(rs.getObject(1)))
{
%>
<tr>
<td align="center"><%=rs.getObject(1) %></td>
<td align="center"><%=rs.getObject(2) %></td>
<td align="center"><%=rs.getObject(3) %></td>
<td align="center"><%=rs.getObject(4) %></td>
<td align="center"><%=rs.getObject(5) %></td>
<td align="center"><a style="color:blue" href='shanchujudge2.jsp?id=<%=rs.getObject(1) %>' onclick="javascript:return del()">删除</a> </td>
</tr>
<%
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
test.close(rs);
test.close(preparedStatement);
test.close(connection);
}
%>
</table>
<%
}
%>
<script>
function del(){
var r = confirm("确定要删除吗？")
if (r == true) {
return true;
} else {
return false;
}
}
</script>
<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
<br> <input type="button" value="返回菜单" onclick="location.href='menu.jsp'" /> <br>
</p>
</body>
</html>
标签：shijian,return,删除,else,connection,preparedStatement,2.24 From： https://www.cnblogs.com/zjq164/p/17153490.html