//主界面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>学生管理系统</title>
</head>
<body>
<%
String msg = request.getParameter("msg");
if (null != msg && !msg.equals("")) {
%>
<div style="color:red">
<%=msg %>
</div>
<%
}
%>
<form action="checkLogin.jsp" method="post">
账号:<input type="text" name="username" /> <br /> 密码:<input
type="password" name="password" /> <br /> <input type="button"
name="reg" value="注册" οnclick="javascript:window.location='reg.jsp';"/> <input type="reset" name="reset" value="重置" />
<input type="submit" name="submit" value="登录" />
</form>
</body>
</html>
//注册界面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>学生注册</title>
</head>
<body>
<form action="checkReg.jsp" method="post">
账号:<input type="text" name="username" value="nitianyu"/> <br />
密码:<input type="text" name="password" value="123456"/> <br />
姓名:<input type="text" name="name" value="倪天宇"/> <br />
性别:
<select name="sex">
<option value="1">男</option>
<option value="2" selected="selected">女</option>
</select>
<br />
年龄:<input type="text" name="age" value="22"/> <br />
学号:<input type="text" name="code" value="40"/> <br />
E-Mail:<input type="text" name="email" value="nty@qq.com"/> <br />
<input type="button" name="reg" value="返回" οnclick="javascript:window.location='index.jsp';"/>
<input type="reset" name="reset" value="重置" />
<input type="submit" name="submit" value="注册" />
</form>
</body>
</html>
//检验注册界面
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
String name = request.getParameter("name");
String code = request.getParameter("code");
String age = request.getParameter("age");
String sex = request.getParameter("sex");
String email = request.getParameter("email");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?characterEncoding=UTF-8",
"root", "");
PreparedStatement pst = conn.prepareStatement(
"insert into t_stu_info(name, code, sex, age, email) values(?,?,?,?,?)");
pst.setString(1, name);
pst.setString(2, code);
pst.setInt(3, new Integer(sex));
pst.setInt(4, new Integer(age));
pst.setString(5, email);
int i = pst.executeUpdate();
pst.close();
if (i == 1) {
pst = conn.prepareStatement(
"insert into t_account(username, password, type, stu_id) values(?,?,1,?)");
pst.setString(1, username);
pst.setString(2, password);
pst.setInt(3, 1);
pst.executeUpdate();
pst.close();
}
conn.close();
%>
success
//注册成功界面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
regSuccess<br/>
<a herf="index.jsp" target="_self">返回登录</a>
</body>
</html>
//检验登录界面
<%@page import="java.sql.ResultSet"%>
<%@page import="com.sun.corba.se.spi.orbutil.fsm.Guard.Result"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
String username = request.getParameter("username");
String password = request.getParameter("password");
Integer id = null;
String name = "";
String code = "";
Integer sex = null;
String email = "";
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?characterEncoding=UTF-8",
"root", "");
PreparedStatement pst = conn.prepareStatement(
"select a.id, s.name,s.code,s.sex,s.email from t_account a left join t_stu_info s on a.stu_id = s.id where a.username = ? and a.password = ?");
pst.setString(1, username);
pst.setString(2, password);
ResultSet rs = pst.executeQuery();
while (rs.next()) {
id = rs.getInt("a.id");
name = rs.getString("s.name");
code = rs.getString("s.code");
sex = rs.getInt("s.sex");
email = rs.getString("s.email");
}
pst.close();
conn.close();
if (null != id) {
%>
<jsp:forward page="success.jsp">
<jsp:param name="stuName" value="<%=name%>" />
<jsp:param name="stuCode" value="<%=code%>" />
<jsp:param name="stuSex" value="<%=sex%>" />
<jsp:param name="stuEmail" value="<%=email%>" />
</jsp:forward>
<%
} else {
%>
<jsp:forward page="index.jsp">
<jsp:param name="msg" value="账号或密码错误" />
</jsp:forward>
<%
}
%>
//完成界面
<%@page import="com.ntqn.Student"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<!-- CSS goes in the document HEAD or added to your external stylesheet -->
<style type="text/css">
table.gridtable {
font-family: verdana, arial, sans-serif;
font-size: 11px;
color: #333333;
border-width: 1px;
border-color: #666666;
border-collapse: collapse;
}
table.gridtable th {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #dedede;
}
table.gridtable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #666666;
background-color: #ffffff;
}
</style>
</head>
<body>
<%
String stuName = request.getParameter("stuName");
String stuCode = request.getParameter("stuCode");
String stuSex = request.getParameter("stuSex");
String stuEmail = request.getParameter("stuEmail");
%>
学员:<%=stuName%>
学号:<%=stuCode%>
性别:<%=stuSex.equals("1") ? "男" : "女"%>
E-Mail:<%=stuEmail%>
<br />
<hr />
<%
List<Student> students = new ArrayList<Student>();
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/student?characterEncoding=UTF-8",
"root", "");
PreparedStatement pst = conn.prepareStatement(
"select a.username,a.password,a.id, s.name,s.code,s.sex,s.email,s.age from t_account a left join t_stu_info s on a.stu_id = s.id");
ResultSet rs = pst.executeQuery();
while (rs.next()) {
Integer id = rs.getInt("a.id");
String name = rs.getString("s.name");
String code = rs.getString("s.code");
Integer sex = rs.getInt("s.sex");
String email = rs.getString("s.email");
String username = rs.getString("a.username");
String password = rs.getString("a.password");
Integer age = rs.getInt("s.age");
Student stu = new Student(id, username, password, name, code, age, email, sex);
students.add(stu);
}
pst.close();
conn.close();
%>
<table class="gridtable">
<thead>
<tr>
<th>学号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>E-Mail</th>
<th>账号</th>
<th>密码</th>
</tr>
</thead>
<tbody>
<%
for (Student student : students) {
%>
<tr>
<td><%=student.getId()%></td>
<td><%=student.getName()%></td>
<td><%=student.getSex() == 1 ? "男" : "女"%></td>
<td><%=student.getAge()%></td>
<td><%=student.getEmail()%></td>
<td><%=student.getUsername()%></td>
<td><%=student.getPassword()%></td>
</tr>
<%
}
%>
</tbody>
</table>
</body>
</html>