java+jsp+mysql实现对数据库增删改查(无servlet)

无servelt就是连接和操作都写在jsp里面

代码：

<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<%@ page errorPage="error.jsp"%>
<html>
<head>
<title>学生管理系统</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
    <h1>学生管理系统</h1>
    <a href="add.jsp">添加学生信息</a>
    <br />
    <br />
    <table style="width: 50%;">
        <tr>
            <th>学号</th>
            <th>姓名</th>
            <th>性别</th>
            <th>生日</th>
            <th>地址</th>
            <th>操作</th>
        </tr>
        <%
            try {
                Class.forName("com.mysql.jdbc.Driver");
                Connection con = DriverManager.getConnection(
                        "jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root",
                        "root");
                //使用Statement对象
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery("select * from student");

                while (rs.next()) {
                    int sno = rs.getInt(1);
                    out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td><td>"
                            + rs.getString(3) + "</td><td>" + rs.getString(4) + "</td><td>" + rs.getString(5)
                            + "</td><td><a href='edit.jsp?id=" + sno + "'>修改</a>&nbsp;<a href='del.jsp?id=" + sno
                            + "'>删除</a></td></tr>");
                }
                rs.close();
                stmt.close();
                con.close();
            } catch (Exception e) {
                out.println("Exception:" + e.getMessage());
            }
        %>

    </table>
    <br />
    <hr />
    <div
        style="text-align: center; width: 100%; font-size: 12px; color: #333;">
        &copy;版权所有：石家庄铁道大学信息科学与技术学院&nbsp;&nbsp;<a href="Lab03.png"
            target="_blank">网站地图</a>
    </div>
</body>
</html>
index.jsp
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"
    errorPage="error.jsp"%>
<html>
<head>
<title>添加图书信息</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
    <form action="addsave.jsp" method="post">
        <h2>添加学生信息</h2>
        <table style="width: 50%">
            <tr>
                <th width="30%">学号：</th>
                <td width="70%"><input name="sno" type="text"></td>
            </tr>
            <tr>
                <th>姓名：</th>
                <td><input name="name" type="text"></td>
            </tr>
            <tr>
                <th>性别：</th>
                <td><input name="gender" type="radio" value="男">男
                <input type="radio" name="gender" value="女">女
                </td>
            </tr>
            <tr>
                <th>生日：</th>
                <td><input name="birthday" type="text"></td>
            </tr>
            <tr>
                <th>地址：</th>
                <td><input name="address" type="text"></td>
            </tr>
            <tr>
                <td colspan="2"><input type="submit" name="submit" value="添加">
                    <input type="reset" value="重置"></td>
            </tr>
        </table>
    </form>

</body>
</html>
add.jsp
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="error.jsp"%>
<html>
<head>
<title>添加图书信息</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
    <%
        request.setCharacterEncoding("utf-8");
        String submit = request.getParameter("submit");
        
        String sno = request.getParameter("sno");
        String name = request.getParameter("name");
        String gender = request.getParameter("gender");
        String birthday = request.getParameter("birthday");
        String address = request.getParameter("address");
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root",    "root");
        PreparedStatement stmt = con.prepareStatement("insert into student(sno,name,gender,birthday,address) values(?, ?, ?,?,?)");
        stmt.setString(1, sno);
        stmt.setString(2, name);
        stmt.setString(3, gender);
        stmt.setString(4, birthday);
        stmt.setString(5, address);
        int i = stmt.executeUpdate();
        
        
        if (i == 1) {
            out.println("<h2>添加成功！</h2><br/>");
            out.println("<a href='index.jsp'>返回首页</a>");
        } else {
            out.println("<h2>添加失败！</h2><br/>");
            out.println("<a href='add.jsp'>重新添加</a>");
        }
        stmt.close();
        con.close();
        
    %>
</body>
</html>
addsave.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
<title>删除图书信息</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
    <%
    request.setCharacterEncoding("utf-8");
    Class.forName("com.mysql.jdbc.Driver");
    Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8","root","root");
    Statement stmt=con.createStatement();
    String id=request.getParameter("id");
    int i=stmt.executeUpdate("delete from student where sno="+id);
    if(i==1)
    {
        out.println("<h2>删除成功！</h2><br/>");
    }
        else
    {
        out.println("<h2>删除失败！</h2><br/>");
    }
    out.println("<a href='index.jsp'>返回首页</a>");
    stmt.close();
    con.close();

    %>
</body>
</html>
del.jsp
<%@ page import="java.sql.*" pageEncoding="utf-8" errorPage="error.jsp"%>
<html>
<head>
<title>修改学生信息</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
    <%
        request.setCharacterEncoding("utf-8");
        String id = request.getParameter("id");
        Class.forName("com.mysql.jdbc.Driver");

        Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root",
                "root");

        PreparedStatement stmt = con.prepareStatement("select * from student where sno=?");
        stmt.setString(1, id);
        ResultSet rs = stmt.executeQuery();

        rs.next();
    %>
    <form action="editsave.jsp" method="post">
        <h2>修改学生信息</h2>
        <table style="width: 50%">
            <tr>
                <th width="30%">学号：</th>
                <td width="70%"><input name="sno" type="text"
                    value="<%=rs.getString(1)%>" readonly></td>
            </tr>
            <tr>
                <th width="30%">姓名：</th>
                <td width="70%"><input name="name" type="text"
                    value="<%=rs.getString(2)%>"></td>
            </tr>
            <tr>
                <th>性别：</th>
                <td><input name="gender" type="radio"
                    value="男">男<input type="radio" value="女" name="gender">女</td>
            </tr>
            <tr>
                <th>生日：</th>
                <td><input name="birthday" type="text"
                    value="<%=rs.getString(4)%>"></td>
            </tr>

            <tr>
                <th>价格：</th>
                <td><input name="address" type="text"
                    value="<%=rs.getString(5)%>"></td>
            </tr>
            <tr>
                <td colspan="2"><input type="hidden" name="id" value="<%=id%>">
                    <input type="submit" value="修改"> <input type="reset"
                    value="重置"></td>
            </tr>
        </table>
    </form>
    <%
        rs.close();
        stmt.close();
        con.close();
    %>
</body>
</html>
edit.jsp
<%@ page import="java.sql.*" pageEncoding="utf-8" errorPage="error.jsp"%>
<html>
<head>
<title>修改完成</title>
<link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
    <%
        request.setCharacterEncoding("utf-8");
        String sno = request.getParameter("sno");
        String name = request.getParameter("name");
        String gender = request.getParameter("gender");
        String birthday  = request.getParameter("birthday");
        String address  = request.getParameter("address");
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/studentmanagement?useUnicode=true&characterEncoding=utf-8", "root", "root");
        PreparedStatement stmt = con.prepareStatement("update student set name=?,gender=?,birthday=?,address=? where sno=?");
        stmt.setString(5, sno);
        stmt.setString(1, name);
        stmt.setString(2, gender);
        stmt.setString(3, birthday);
        stmt.setString(4, address);
        int i = stmt.executeUpdate();
        if (i == 1) {
            out.println("<h2>修改成功！</h2><br/>");
            out.println("<a href='index.jsp'>返回首页</a>");
        } else {
            out.println("<h2>修改失败！</h2><br/>");
            out.println("<a href='edit.jsp?id='" + sno + ">重新添加</a>");
        }
        stmt.close();
        con.close();
    %>
</body>
</html>
editsave.jsp
<%@ page language="java" isErrorPage="true" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>error page</title>
</head>
<body>
    错误信息为：<br/>
    <%=exception.getMessage()%><br>
    <%=exception.toString()%>
</body>
</html>
error.jsp

效果：

其他增删改查都一样，不再赘述

 

posted @ 2020-06-01 01:47  printf();  阅读(1257)  评论(0)    收藏  举报