课堂测试2

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="gerenxinxi1.jsp" method="get">
<table align="center" border="1" width="500">
             
            <tr>
 
                <td>姓名</td>
 
                <td><input type="text" name="name" /></td>
 
            </tr>
            <tr>
 
                <td>性别</td>
 
                <td><input type="text" name="sex" /></td>
 
            </tr>
            <tr>
 
                <td>年龄</td>
 
                <td><input type="text" name="age" /></td>
 
            </tr>
            <tr>
 
                <td>班级（所教授课程）</td>
 
                <td><input type="text" name="banji" /></td>
 
            </tr>
            <tr>
 
                <td>学号（教师号）</td>
 
                <td><input type="text" name="number" /></td>
 
            </tr>
 
            <tr align="center">
 
                <td colspan="2"><input type="submit" value="提交" /></td>
 
            </tr>
 
 
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="Util.dao"%>
    <%@ page import="Util.util"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String number = request.getParameter("number");
String banji = request.getParameter("banji");
dao.xinxizeng(name,sex,age,banji,number);
%>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1 style="text-align: center;">管理员界面界面</h1>
<center><input type="button" onclick="window.location.href='zhuce.jsp';" value="用户注册"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='deletexinxi.jsp';" value="删除用户信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='updatezhucexinxi.jsp';" value="修改用户身份"><br>
 
<br>
<center><input type="button" onclick="window.location.href='seeall.jsp';" value="查看所有用户信息"><br>
<center><input type="button" onclick="window.location.href='bujige.jsp';" value="查询不及格"><br>
<center><input type="button" onclick="window.location.href='youxiu.jsp';" value="查询优秀"><br>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1 style="text-align: center;">教师界面</h1>
<center><input type="button" onclick="window.location.href='gerenxinxi.jsp';" value="完善个人基本信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='seexinxi.jsp';" value="查看个人基本信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='updatexinxi.jsp';" value="修改个人基本信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='addchengji.jsp';" value="录入个人所教授考试科目成绩"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='updatechengji.jsp';" value="修改个人所教授考试科目成绩"><br>
 
<br>
<center><input type="button" onclick="window.location.href='seebanjichengji.jsp';" value="查看所教授班级成绩"><br>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="Util.util"%>
    <%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.SQLException"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.ResultSet"%>
 
 
<%
   java.sql.Connection sqlCon; //数据库连接对象
   java.sql.Statement sqlStmt; //SQL语句对象
   java.sql.ResultSet sqlRst;  //结果集对象
   java.lang.String strCon;    //数据库连接字符串
   java.lang.String strSQL;    //SQL语句
   int intPageSize;           //一页显示的记录数
   int intRowCount;           //记录总数
   int intPageCount;          //总页数
   int intPage;               //待显示页码
   java.lang.String strPage;
    
   int i;
   //设置一页显示的记录数
   intPageSize = 3;
 
   //取得待显示页码
   strPage = request.getParameter("page");
 
   if(strPage==null){
       //表明在QueryString中没有page这一个参数，此时显示第一页数据
       intPage = 1;
   } else {
       //将字符串转换成整型
       intPage =java.lang.Integer.parseInt(strPage);
       if(intPage<1) intPage = 1;
   }
   Class.forName("com.mysql.cj.jdbc.Driver").newInstance(); 
   String username = "root"; //用户名
   String password = "NN06280055"; //密码
   String url="jdbc:mysql://localhost:3306/kaoshi?useUnicode=true&characterEncoding=UTF-8";
   //连接数据库
   sqlCon=java.sql.DriverManager.getConnection(url,username,password);
   //创建语句对象
   sqlStmt =sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
   //创建查询语句
    strSQL = "select * from xinxi";
   //执行SQL语句并获取结果集
  sqlRst = sqlStmt.executeQuery(strSQL);
   //获取记录总数
   sqlRst.last();
   intRowCount = sqlRst.getRow();
   //记算总页数
   intPageCount = (intRowCount+intPageSize-1) /intPageSize;
   //调整待显示的页码
   if(intPage>intPageCount) intPage = intPageCount;
%>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
        <title>数据分页显示</title>
    </head>
    <body>
 
        <center><table border=1 cellspacing=0 cellpadding=0>
 
            <tr>
 
               <td align=center width=100% colspan=5 bgcolor=#3399ff>
 
 
               </td>
 
            </tr>
 
            <tr>
             
            <td align="center" >姓名</td>
            <td align="center" >性别</td>
            <td align="center" >年龄</td>
                        <td align="center" >班级</td>
            <td align="center" >学号</td>
            </tr>
            <% if(intPageCount>0) {
 
                   //将记录指针定位到待显示页的第一条记录上
 
                   sqlRst.absolute((intPage-1)* intPageSize + 1);
 
                   //显示数据
 
                   i = 0;
 
                   while(i<intPageSize &&!sqlRst.isAfterLast()){
 
            %>
 
                <tr>
            <td><%=(sqlRst.getString("name")) %></td>
            <td><%=(sqlRst.getString("sex")) %></td>
            <td><%=(sqlRst.getString("age")) %></td>
                        <td><%=(sqlRst.getString("banji")) %></td>
            <td><%=(sqlRst.getString("number")) %></td>
            </tr>
 
 
 
 
            <% sqlRst.next();
 
               i++;
 
               }
 
               }
 
            %>
 
        </table></center><br>
 
 
 
    <center>
 
        第<%=intPage%>页 共<%=intPageCount%>页
 
 
 
        <% //以下是分页的“上一页”“下一页”，有上一页就有链接，没有就为文字，下一页同理%>
 
        <% if(intPage>1){ %>
 
            <a href="seeall.jsp?page=<%=intPage-1%>">上一页</a>
 
        <% }else{ %>
 
            上一页
 
        <%}%>
 
 
 
        <% if(intPage<intPageCount){ %>
 
            <a href="seeall.jsp?=page=<%=intPage+1%>">下一页</a>
 
        <% }else{ %>
 
            下一页
 
        <%}%>
 
     <center>
 
    </body>
 
 
 
</html>
 
 
 
<%
 
   //关闭结果集
 
   sqlRst.close();
 
   //关闭SQL语句对象
 
   sqlRst.close();
 
   //关闭数据库
 
   sqlRst.close();
 
%>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="seebanjichengji1.jsp" method="get">
<table align="center" border="1" width="500">
             
            <tr>
 
                <td>班级</td>
                <td><input type="text" name="banji" /></td>
            </tr>
                        <tr align="center">
 
                <td colspan="2"><input type="submit" value="提交" /></td>
 
            </tr>
             
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="Util.util"%>
    <%@ page import="java.sql.Connection"%>
    <%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.SQLException"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.ResultSet"%>
<%@page import="Util.dao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<jsp:useBean id="util" class="Util.util" scope="page" />
<table border="1"style="text-align:center;">
             <tr>
            <td align="center" >学号</td>
            <td align="center" >班级</td>
            <td align="center" >高数</td>
            <td align="center" >信息</td>
            <td align="center" >数据库</td>
            </tr>
<%
String banji = request.getParameter("banji");
Connection connection = util.getConnection();
PreparedStatement ps = null;
try {
    String sql = "SELECT * FROM chengji where banji='"+banji+"' ";
    ps = connection.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
%>
             <tr>
            <td><%=(rs.getString("xuehao")) %></td>//获取数据表中的信息
            <td><%=(rs.getString("banji")) %></td>
            <td><%=(rs.getString("gaoshu")) %></td>
            <td><%=(rs.getString("xinxi")) %></td>
            <td><%=(rs.getString("shujvku")) %></td>
            </tr>
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="seechengji1.jsp" method="get">
<table align="center" border="1" width="500">
             
            <tr>
 
                <td>学号</td>
                <td><input type="text" name="xuehao" /></td>
            </tr>
                        <tr align="center">
 
                <td colspan="2"><input type="submit" value="提交" /></td>
 
            </tr>
             
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="Util.util"%>
    <%@ page import="java.sql.Connection"%>
    <%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.SQLException"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.ResultSet"%>
<%@page import="Util.dao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<jsp:useBean id="util" class="Util.util" scope="page" />
<table border="1"style="text-align:center;">
             <tr>
            <td align="center" >学号</td>
             <td align="center" >班级</td>
            <td align="center" >高数</td>
            <td align="center" >信息</td>
            <td align="center" >数据库</td>
            </tr>
<%
String xuehao = request.getParameter("xuehao");
Connection connection = util.getConnection();
PreparedStatement ps = null;
try {
    String sql = "SELECT * FROM chengji where xuehao='"+xuehao+"' ";
    ps = connection.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
%>
             <tr>
            <td><%=(rs.getString("xuehao")) %></td>//获取数据表中的信息
            <td><%=(rs.getString("banji")) %></td>
            <td><%=(rs.getString("gaoshu")) %></td>
            <td><%=(rs.getString("xinxi")) %></td>
            <td><%=(rs.getString("shujvku")) %></td>
            </tr>
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="seexinxi1.jsp" method="get">
<table align="center" border="1" width="500">
             
            <tr>
 
                <td>姓名</td>
                <td><input type="text" name="name" /></td>
            </tr>
                        <tr align="center">
 
                <td colspan="2"><input type="submit" value="提交" /></td>
 
            </tr>
             
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="Util.util"%>
    <%@ page import="java.sql.Connection"%>
    <%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.SQLException"%>
<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.ResultSet"%>
<%@page import="Util.dao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<jsp:useBean id="util" class="Util.util" scope="page" />
<table border="1"style="text-align:center;">
             <tr>
            <td align="center" >姓名</td>
            <td align="center" >性别</td>
            <td align="center" >年龄</td>
            <td align="center" >班级（所教授课程）</td>
            <td align="center" >学号（教师号）</td>
            </tr>
<%
String name = request.getParameter("name");
Connection connection = util.getConnection();
PreparedStatement ps = null;
try {
    String sql = "SELECT * FROM xinxi where name='"+name+"' ";
    ps = connection.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
%>
             <tr>
            <td><%=(rs.getString("name")) %></td>//获取数据表中的信息
            <td><%=(rs.getString("sex")) %></td>
            <td><%=(rs.getString("age")) %></td>
            <td><%=(rs.getString("banji")) %></td>
            <td><%=(rs.getString("number")) %></td>
            </tr>
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>在此处插入标题</title>
</head>
<body>
     <form action="updatechengji1.jsp" method="get">
<table align="center" border="1" width="500">
             
            <tr>
 
                <td>学号</td>
                <td><input type="text" name="xuehao" /></td>
            </tr>
                         
            <tr>
 
                <td>高数成绩</td>
                <td><input type="text" name="gaoshu" /></td>
            </tr>
                        <tr>
 
                <td>信息成绩</td>
                <td><input type="text" name="xinxi" /></td>
            </tr>
                        <tr>
 
                <td>数据库成绩成绩</td>
                <td><input type="text" name="shujvku" /></td>
            </tr>
                        <tr align="center">
 
                <td colspan="2"><input type="submit" value="提交" /></td>
 
            </tr>
</body>
</html>

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
        <%@ page import="Util.dao"%>
    <%@ page import="Util.util"%>
<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>在此处插入标题</title>
</head>
<body>
<%
String xuehao = request.getParameter("xuehao");
String gaoshu = request.getParameter("gaoshu");
String xinxi = request.getParameter("xinxi");
String shujvku = request.getParameter("shujvku");
dao.updatechengji(xuehao,gaoshu,xinxi,shujvku);
%>
</body>
</html>

　　

posted @   布吉岛？？？  阅读(1)  评论(0)  编辑  收藏  举报
相关博文：
· 课堂测试3
· 五月十二日
· 数据库实验——第2部分
· 数据库实验二
· 数据库实验2---数据查询
阅读排行：
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 无需6万激活码！GitHub神秘组织3小时极速复刻Manus，手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· DeepSeek在M芯片Mac上本地化部署
点击右上角即可分享
微信分享提示