课堂测试3
<!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="updatezhucexinxi1.jsp" method="get"> <table align="center" border="1" width="500"> <tr align="center"> <h5>注意:1表示学生,2表示教师,3表示管理员</h5> </tr> <tr> <td>用户名</td> <td><input type="text" name="username" /></td> </tr> <tr> <td>密码</td> <td><input type="text" name="password" /></td> </tr> <tr> <td>身份</td> <td><input type="text" name="profession" /></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 username = request.getParameter("username"); String password = request.getParameter("password"); String profession = request.getParameter("profession"); dao.updatezhucexinxi(username,password,profession); %> </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='seechengji.jsp';" value="查询成绩"><br> <br> <br> </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> <% Connection connection = util.getConnection(); PreparedStatement ps = null; try { String sql = "SELECT name,sex,age,banji,number FROM xinxi WHERE EXISTS ( SELECT * FROM chengji WHERE xinxi.number = chengji.xuehao AND chengji.`gaoshu`>89 )"; 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>
<%@ 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="zhuce1.jsp" method="get"> <table align="center" border="1" width="500"> <tr> <td>用户名</td> <td><input type="text" name="username" /></td> </tr> <tr> <td>密码</td> <td><input type="text" name="password" /></td> </tr> <tr> <td>身份: <select name="profession"> <option value="1">学生</option> <option value="2">教师</option> <option value="3" selected>管理员</option> </select> </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 profession = request.getParameter("profession"); String username = request.getParameter("username"); String password = request.getParameter("password"); dao.yhzeng(username, password, profession); %> </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 banji = request.getParameter("banji");
String number = request.getParameter("number");
dao.updatexinxi(name,sex,age,banji,number);
%>
</body>
</html>