登录验证：Logincheck.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><title>登录成功页面</title></head>
<body >
<% ResultSet rs=null;
String driverName="com.mysql.jdbc.Driver";
String userName="root";//数据库用户名
String userPwd="123456";//密码
String dbName="students";//数据库名
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=utf8";
String url=url1+url2+url3;
System.out.println(url);
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(url);
request.setCharacterEncoding("utf8");//避免乱码，设置字符编码
String usernumber=request.getParameter("usernumber");
String password=request.getParameter("password");
String sql="select * from stu_info where usernumber=? and password=?";
PreparedStatement ps= conn.prepareStatement(sql);
ps.setString(1,usernumber);
ps.setString(2,password);
rs=ps.executeQuery();
if(rs.next()){ response.sendRedirect("doLogin.jsp");%><% }
else{%> 登录失败！<a href="Login.jsp">点击返回登录页面检查或进行注册！</a><br><%}
if(rs!=null){rs.close();}
if(ps!=null){ps.close();}
if(conn!=null){conn.close();}
%>
</body>
</html>
注册验证：insert.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
request.setCharacterEncoding("utf-8");//避免乱码，设置字符编码
String driverName="com.mysql.jdbc.Driver";
String userName="root";//数据库用户名
String userPwd="123456";//密码
String dbName="students";//数据库名
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=utf8";
String url=url1+url2+url3;
System.out.println(url);
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(url);
String usernumber= request.getParameter("usernumber");
String username=request.getParameter("username");
String password=request.getParameter("password");
String age=request.getParameter("age");
String sql="Insert into stu_info(usernumber,username,password,age) values(?,?,?,?)";
PreparedStatement ps= conn.prepareStatement(sql);
ps.setString(1,usernumber);
ps.setString(2,username);
ps.setString(3,password);
ps.setString(4,age);
// ps.setString(5,sdept);
int n = ps.executeUpdate();
if(n==1){
response.sendRedirect("zhuceSuccess.jsp");
}
else{%>alert("error!");<%}
if(ps!=null){ ps.close();}
if(conn!=null){conn.close();}
%>
</body>
</html>
