学员信息的注册登录以及登录成功后的信息遍历

来源：互联网发布：李鸿章的功与过知乎编辑：程序博客网时间：2024/04/30 11:43

//主界面

<%@ 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="注册" onclick="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="返回" onclick="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 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>

<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>

阅读全文

0 0