jsp新手练习

注册

[plain] view plain copy

print ?

1. <form action="checkReg.jsp" method="post">  
2.         <input type="text" name="account" /><br/>  
3.         <input type="password" name="pwd" /><br/>  
4.         <input type="submit" value="注册" />  
5.         <input type="reset" value="重置" />  
6.     </form>  

<form action="checkReg.jsp" method="post">
		<input type="text" name="account" /><br/>
		<input type="password" name="pwd" /><br/>
		<input type="submit" value="注册" />
		<input type="reset" value="重置" />
	</form>

简单的检验注册信息

[plain] view plain copy

print ?

1. <%     
2.         String account = request.getParameter("account");  
3.         String pwd = request.getParameter("pwd");  
4.         Class.forName("com.mysql.jdbc.Driver");  
5.         Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/java88","root","");  
6.         String sql = "insert into user(name,pwd) values (?,?)";  
7.         PreparedStatement ps = con.prepareStatement(sql);  
8.         if (pwd.length()<5) {  
9.             out.print("密码长度小于6");  
10.     %>  
11.             <jsp:forward page="regFailure.jsp"></jsp:forward>  
12.     <%  
13.         } else {  
14.             ps.setString(1, account);  
15.             ps.setString(2, pwd);  
16.             ps.executeUpdate();  
17.     %>  
18.             <jsp:forward page="RegSuccess.jsp"></jsp:forward>  
19.     <%  
20.         }  
21.         ps.close();  
22.         con.close();  
23.     %>  

<%	
		String account = request.getParameter("account");
		String pwd = request.getParameter("pwd");
		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/java88","root","");
		String sql = "insert into user(name,pwd) values (?,?)";
		PreparedStatement ps = con.prepareStatement(sql);
		if (pwd.length()<5) {
			out.print("密码长度小于6");
	%>
			<jsp:forward page="regFailure.jsp"></jsp:forward>
	<%
		} else {
			ps.setString(1, account);
			ps.setString(2, pwd);
			ps.executeUpdate();
	%>
			<jsp:forward page="RegSuccess.jsp"></jsp:forward>
	<%
		}
		ps.close();
		con.close();
	%>

符合注册条件跳转至登陆

[plain] view plain copy

print ?

1. 注册成功！<br/>  
2. <a href="Login.jsp" target="_self" >前往登陆界面</a>  

注册成功！<br/>
<a href="Login.jsp" target="_self" >前往登陆界面</a>

不符合则继续注册

[plain] view plain copy

print ?

1. 密码长度密码长度小于6<br/>  
2.     <a href="register.jsp">点我返回注册界面</a>  

密码长度密码长度小于6<br/>
	<a href="register.jsp">点我返回注册界面</a>

登陆

[html] view plain copy

print ?

1. 密码长度密码长度小于6<br/>  
2.     <a href="register.jsp">点我返回注册界面</a>  

密码长度密码长度小于6<br/>
	<a href="register.jsp">点我返回注册界面</a>

检测账号密码

[html] view plain copy

print ?

1. String account = request.getParameter("account");  
2.         String pwd = request.getParameter("pwd");  
3.         Class.forName("com.mysql.jdbc.Driver");  
4.         Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/java88","root","");  
5.         String sql = "SELECT id from user where name = ? and pwd = ?";  
6.         PreparedStatement ps = con.prepareStatement(sql);  
7.         ps.setString(1, account);  
8.         ps.setString(2, pwd);  
9.         ResultSet rs = ps.executeQuery();  
10.         if (rs.next()) {  
11.             int id = rs.getInt("id");  
12. %>  
13.             <jsp:forward page="logSuccess.jsp">  
14.                 <jsp:param name="stuId" value="<%=id%>" />  
15.             </jsp:forward>  
16.     <%  
17.         } else {  
18.     %>  
19.              <jsp:forward page="logFailure.jsp"></jsp:forward>  
20.         <%     
21.         }  
22.         rs.close();  
23.         ps.close();  
24.         con.close();  
25.         %>  

String account = request.getParameter("account");
		String pwd = request.getParameter("pwd");
		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/java88","root","");
		String sql = "SELECT id from user where name = ? and pwd = ?";
		PreparedStatement ps = con.prepareStatement(sql);
		ps.setString(1, account);
		ps.setString(2, pwd);
		ResultSet rs = ps.executeQuery();
		if (rs.next()) {
			int id = rs.getInt("id");
%>
			<jsp:forward page="logSuccess.jsp">
				<jsp:param name="stuId" value="<%=id%>" />
			</jsp:forward>
	<%
		} else {
	%>
			 <jsp:forward page="logFailure.jsp"></jsp:forward>
		<%	
		}
		rs.close();
		ps.close();
		con.close();
		%>