每周总结一

这一周我打算看着之前同学发我的能运行的jsp代码学一下jsp是怎么写的，这是一个纯jsp代码，所以只看一下他是如何将内容输出到界面上的就可以了，其中用到的方法就没必要看了。

jsp其实和html写界面的代码是一样的，只有一个不同那就是可以内嵌代码，可以内嵌代码带来的结果是，用jsp可以将查询到的内容显示到网页上，而html却只能显示在控制台中（Ajax好想可以实现把查询到的结果显示在网页上）

style.css:

复制代码
body {
    text-align: center;
}

table {
    width: 400px;
    border: 1px solid #696969;
    border-collapse: collapse;
    margin:0 auto;
}
th {
    border: 1px solid #696969;
    background-color: #FFF8DC;
}
td {
    text-align: center;
    border: 1px solid #696969;
    height: 50px;
    background-color: #E0FFFF;
}
input {
    font-size: 20px;
}
复制代码

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>
    <form action="addsave.jsp" method="post">
        <h2>学生宿舍安排</h2>
        <table style="width: 50%">
            <tr>
                <th width="30%">姓名：</th>
                <td width="70%"><input name="name" type="text"></td>
            </tr>
            <tr>
                <th>学号：</th>
                <td><input name="xuehao" type="text"></td>
            </tr>
            <tr>
                <th>性别：</th>
                <td><input type="radio" name="sex" value="男">男<input type="radio" name="sex" value="女">女</td>
            </tr>
            <tr>
                <th>宿舍：</th>
                <td><input name="home" type="text"></td>
            </tr>
            <tr>
                <td colspan="2"><input type="submit" name="submit" value="添加"> <input type="reset" value="重置"></td>
            </tr>
        </table>
    </form>
    
</body>
</html>
复制代码

addsave.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 name = request.getParameter("name");
        String xuehao = request.getParameter("xuehao");
        String sex = request.getParameter("sex");
        String home = request.getParameter("home");
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sushe?&useSSL=false&serverTimezone=UTC", "root", "wangzeyang");

        
        
         PreparedStatement stmt = con.prepareStatement("insert into sushe(name,xuehao,sex,home) values(?, ?, ?,?)");
        stmt.setString(1, name);
        stmt.setString(2, xuehao);
        stmt.setString(3, sex);
        stmt.setString(4, home);
        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>
复制代码

del.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.cj.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sushe?&useSSL=false&serverTimezone=UTC", "root", "wangzeyang");
    Statement stmt=con.createStatement();
    String id=request.getParameter("id");
    int i=stmt.executeUpdate("delete from sushe where id="+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>
复制代码

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 id = request.getParameter("id");
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sushe?&useSSL=false&serverTimezone=UTC", "root", "wangzeyang");

        PreparedStatement stmt = con.prepareStatement("select * from sushe where id=?");
        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="name" type="text"
                    value="<%=rs.getString("name")%>"></td>
            </tr>
            <tr>
                <th>学号：</th>
                <td><input name="xuehao" type="text"
                    value="<%=rs.getString("xuehao")%>"></td>
            </tr>            <tr>
                <th>性别：</th>
                <td><input name="sex" type="text"
                    value="<%=rs.getString("sex")%>"></td>
            </tr>
            <tr>
                <th>宿舍：</th>
                <td><input name="home" type="text"
                    value="<%=rs.getString("home")%>"></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>
复制代码

editsave.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 name = request.getParameter("name");
    String xuehao = request.getParameter("xuehao");
    String sex = request.getParameter("sex");
    String home = request.getParameter("home");
    String id=request.getParameter("id");
    Class.forName("com.mysql.cj.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sushe?&useSSL=false&serverTimezone=UTC", "root", "wangzeyang");
    Statement stmt = con.createStatement();
    String sql = "update sushe set name='" + name + "',xuehao='" + xuehao + "',sex='" + sex + "',home='" + home
            + " 'where id=" + id;
    System.out.println(sql);
    int i = stmt.executeUpdate(sql);
    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='" + id + ">重新添加</a>");
    }
    stmt.close();
    con.close();
%>
</body>
</html>
复制代码

index.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>
    </tr>
    <%
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sushe?&useSSL=false&serverTimezone=UTC", "root", "wangzeyang");
        //使用Statement对象
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("select * from sushe");


        while (rs.next()) {
            String id = rs.getString(1);
            out.println("<tr><td>" + rs.getString("name") + "</td><td>" + rs.getString("xuehao") + "</td><td>"
                    + rs.getString("sex") + "</td><td>"
                    + rs.getString("home") + "</td><td><a href='edit.jsp?id=" + id
                    + "'>修改</a>&nbsp;<a href='del.jsp?id=" + id + "'>删除</a></td></tr>");
        }
        rs.close();
        stmt.close();
        con.close();
    %>

</table>
<br/>
</body>
</html>
复制代码

error.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>
    <h1>程序出现错误</h1>
    <div>错误信息为：<br/>
    <%=exception.getMessage()%><br/>
    <%=exception.toString()%>
    </div>
</body>
</html>
复制代码

 

posted @   菜鸟是如何练成的  阅读(13)  评论(0)  编辑  收藏  举报
相关博文：
·  每周总结三
·  每周总结六
·  web实验3
·  JSP(一)
·  Java-JSP（1）
阅读排行：
· 震惊！C++程序真的从main开始吗？99%的程序员都答错了
· 【硬核科普】Trae如何「偷看」你的代码？零基础破解AI编程运行原理
· 单元测试从入门到精通
· winform 绘制太阳，地球，月球 运作规律
· 上周热点回顾（3.3-3.9）
点击右上角即可分享
微信分享提示
AI IDE Trae