课堂测试2
<%@ 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>
<%@ 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>
<%@ 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>
<%@ 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>
<%@ 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(); %>
<%@ 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>
<!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>
<%@ 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>
<!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>
<%@ 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>
<!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>
<!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>
<!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>