2.24

关于今天所编写的删除部分，虽有瑕疵，但是效果不错。。

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>

 

posted @ 2023-02-24 22:59  周＋⑦  阅读(114)  评论(0)    收藏  举报