JSP和数据库连接写一个网页登陆注册代码

</label>
</p>
<p>真实姓名
<label>
<input type="text" name="textfield4" />
</label>
</p>
<p>年龄
<label>
<input type="text" name="textfield5" />
</label>
</p>
<p>职业
<label>
<!--DWLayoutTable-->
<tr>
<td width="528" height="368">&nbsp;</td>
<td width="344" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
</label>
<label>
<input type="submit" name="Submit3" value="返回" />
</label>
</p>
</form> </td>
</tr>

本例需要的软件和运行环境：1、Windows2000 Server操作系统2、jdk1.43、JCreator2.5（java源码编辑调试器，吐血推荐！）4、Macromedia JRun MX5、Macromedia Dreamweaver MX（非必需）6、MySQL数据库（最好安装MySQL Control Center）一、数据库设计用MySQL Control Center打开MySQL数据库，新建数据库shopping，在其下新建表tbl_user，其中各字段设置如下：二、编写连接数据库bean：DBConn.java//DBConn.java//include required classesimport java.sql.*;//====================================== ====// Define Class DBConn//====================================== ====public class DBConn{public String sql_driver = "org.gjt.mm.mysql.Driver";public String sql_url = "jdbc:mysql://localhost:3306";public String sql_DBName = "shopping";public String user = "sa";public String pwd = "";Connection conn = null;Statement stmt = null;ResultSet rs = null;public boolean setDriver(String drv){this.sql_driver = drv;return true;}public String getDriver(){return this.sql_driver;}public boolean setUrl(String url){this.sql_url = url;return true;}public boolean setDBName(String dbname) {this.sql_DBName = dbname;return true;}public String getDBName(){return this.sql_DBName;}public boolean setUser(String user){er = user;return true;}public String getUser(){return er;}public boolean setPwd(String pwd){this.pwd = pwd;return true;}public String getPwd(){return this.pwd;}public DBConn(){try{Class.forName(sql_driver);//加载数据库驱动程序this.conn = DriverManager.getConnection(sql_url + "/" + sql_DBName + "?user=" + user + "&password=" + pwd + "&useUnicode=true&characterEncoding=gb2312"); this.stmt = this.conn.createStatement();}catch(Exception e){System.out.println(e.toString());}}//执行查询操作public ResultSet executeQuery(String strSql){try{this.rs = stmt.executeQuery(strSql);return this.rs;}catch(SQLException e){System.out.println(e.toString());return null;}catch(NullPointerException e){System.out.println(e.toString());return null;}}//执行数据的插入、删除、修改操作 public boolean execute(String strSql){try{if(this.stmt.executeUpdate(strSql) == 0) return false;elsereturn true;}catch(SQLException e){System.out.println(e.toString());return false;}catch(NullPointerException e){ System.out.println(e.toString());return false;}}//结果集指针跳转到某一行public boolean rs_absolute(int row){try{this.rs.absolute(row);return true;}catch(SQLException e){ System.out.println(e.toString()); return false;}}public void rs_afterLast(){try{this.rs.afterLast();}catch(SQLException e){ System.out.println(e.toString()); }}public void rs_beforeFirst(){try{this.rs.beforeFirst();}catch(SQLException e){ System.out.print(e.toString()); }}public void rs_close(){try{this.rs.close();}catch(SQLException e){ System.out.print(e.toString()); }}public void rs_deleteRow(){try{this.rs.deleteRow();}catch(SQLException e){ System.out.print(e.toString()); }}public boolean rs_first(){try{this.rs.first();return true;}catch(SQLException e){System.out.print(e.toString());return false;}}public String rs_getString(String column){try{return this.rs.getString(column);}catch(SQLException e){System.out.println(e.toString());return null;}}//此方法用于获取大段文本，//将其中的回车换行替换为<br>//输出到html页面public String rs_getHtmlString(String column) {try{String str1 = this.rs.getString(column);String str2 = "\r\n";String str3 = "<br>";return this.replaceAll(str1,str2,str3);}catch(SQLException e){System.out.println(e.toString());return null;}}//把str1字符串中的str2字符串替换为str3字符串private static String replaceAll(String str1,String str2,String str3){StringBuffer strBuf = new StringBuffer(str1);int index=0;while(str1.indexOf(str2,index)!=-1){index=str1.indexOf(str2,index);strBuf.replace(str1.indexOf(str2,index),str1.indexOf(str2,inde x)+str2.length(),str3);index=index+str3.length();str1=strBuf.toString();}return strBuf.toString();}public int rs_getInt(String column) {try{return this.rs.getInt(column);}catch(SQLException e){ System.out.println(e.toString()); return -1;}}public int rs_getInt(int column){try{return this.rs.getInt(column);}catch(SQLException e){ System.out.println(e.toString()); return -1;}public boolean rs_next(){try{return this.rs.next();}catch(SQLException e){ System.out.println(e.toString()); return false;}}//判断结果集中是否有数据 public boolean hasData(){try{boolean has_Data = this.rs.first(); this.rs.beforeFirst();return has_Data;}catch(SQLException e){ System.out.println(e.toString()); return false;}public boolean rs_last(){try{return st();}catch(SQLException e){ System.out.println(e.toString()); return false;}}public boolean rs_previous(){try{return this.rs.previous();}catch(Exception e){ System.out.println(e.toString()); return false;}}//main方法，调试用public static void main(String args[]){try{DBConn myconn = new DBConn();//myconn.setDBName("shopping");//myconn.DBConn();//myconn.execute("Insert Into tbl_test(id,name)values('10','shandaer')");//myconn.execute("Update tbl_test setname='yyyyyyyyyyyy' where id=10");//myconn.execute("Delete from tbl_test where id=1"); ResultSet rs = myconn.executeQuery("select * from tbl_user order by id desc limit 1");//boolean hasData = myconn.hasData();//System.out.println("has data:" + hasData);//rs.first();while (myconn.rs.next()){int id = myconn.rs_getInt("id") + 1;System.out.print(id);System.out.println(myconn.rs_getInt("id") +myconn.rs_getString("name"));//System.out.println('\n' +myconn.rs_getHtmlString("name"));//System.out.println(myconn.rs.getString("name") + myconn.rs_getInt(1));}}catch(Exception e){System.err.println(e.toString());}}}声明：因为使用的是MySQL数据库，所以需要MySQL数据库的驱动下载后请将org包放至DBConn.java所在目录下以确保该bean能正常运行三、编写用户注册的bean：reg.java//reg.java//import required classesimport java.sql.*;public class reg{public int newID = 0;public boolean result = false;public boolean reg(String username,String password,String confirm,String email){try{if(!this.checkUser(username))return false;if(!this.checkPwd(password))return false;if(!this.verifyPwd(password,confirm))return false;if(!this.checkEmail(email))return false;if(!erNotExit(username))return false;this.getNewID();this.result = this.register(username,password,confirm,email); return this.result;}catch(Exception e){System.out.println(e.toString());return false;}}//End boolean regpublic boolean checkUser(String user){try{if(user.indexOf("'")!=-1){System.out.println("姓名中含有非法字符！");return false;}elsereturn true;}catch(Exception e){System.out.println(e.toString());return false;}public boolean checkPwd(String pwd){try{if(pwd.indexOf("'")!=-1){System.out.println("密码中含有非法字符！");return false;}elsereturn true;}catch(Exception e){System.out.println(e.toString());return false;}}public boolean verifyPwd(String pwd,String confirm) {try{if(!pwd.equals(confirm))System.out.println("两次输入的密码不一致！");return false;}elsereturn true;}catch(Exception e){System.out.println(e.toString());return false;}}public boolean checkEmail(String email){try{if(email.indexOf("'")!=-1){System.out.println("E-mail中含有非法字符！");return false;}elsereturn true;}catch(Exception e){System.out.println(e.toString());return false;}}public boolean userNotExit(String user){try{DBConn userDBConn = new DBConn(); userDBConn.executeQuery("select * from tbl_user where name='" + user + "'");if(userDBConn.rs_next()){System.out.println("用户名已存在，请选择其它的用户名！");return false;}elsereturn true;}catch(Exception e){System.out.println(e.toString());return false;}}public int getNewID(){try{DBConn newIDDBConn = new DBConn(); newIDDBConn.executeQuery("select * from tbl_user order by id desc limit 1");if(newIDDBConn.rs_next()){this.newID = newIDDBConn.rs_getInt("id") + 1;System.out.println(this.newID);}else{this.newID = 1;}return this.newID;}catch(Exception e){System.out.println(e.toString());return -1;}}public int getID(){return this.newID;}public boolean register(String username,String password,String confirm,String email){try{DBConn regDBConn = new DBConn();String strSQL = "insert into tbl_user(id,name,pwd,email) values('" + this.newID +"','" + username + "','" + password + "','" + email + "')";regDBConn.execute(strSQL);return true;}catch(Exception e){System.out.println(e.toString());return false;}}public static void main(String args[]){try{reg newreg = new reg();System.out.println(newreg.reg("sssssssss","ssssss","ssssss","i magebear@"));DBConn myconn = new DBConn();myconn.executeQuery("select * from tbl_user");while(myconn.rs_next()){System.out.println(myconn.rs_getInt("id") + " " + myconn.rs_getString("name") + " " +myconn.rs_getString("pwd") + " " +myconn.rs_getString("email"));}System.out.println(newreg.getID());}catch(Exception e){System.err.println(e.toString());}}};说明：1、该bean文件应和上文所述DBConn.class文件放于同一目录下2、本例主要研究注册的过程，其中的Email检测等方法并不完善，若要应用请自行设计方法四、编写用户登陆的Servlet：login.java//login.java//import required classesimport java.io.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;//class loginpublic class login extends HttpServlet{public void doGet(HttpServletRequestreq,HttpServletResponse res)throws IOException,ServletException{String username = req.getParameter("username");String password = req.getParameter("password");if(this.checklogin(username,password)){Cookie mylogin = new Cookie("username",username); mylogin.setVersion(1);mylogin.setPath("/");mylogin.setComment("Your login username");res.addCookie(mylogin);}//Cookie[] myCookies = req.getCookies();//String nameValue =this.getCookieValue(myCookies,"username","not found"); //PrintWriter out = res.getWriter();//out.println("username" + ":" + nameValue);//out.println("Test Cookie Success!");res.sendRedirect("/index.jsp");}public void doPost(HttpServletRequestreq,HttpServletResponse res)throws IOException,ServletException{doGet(req,res);}public static String getCookieValue(Cookie[] cookies,String cookieName,String defaultValue){for(int i=0;i<cookies.length;i++) {Cookie cookie = cookies[i];if (cookieName.equals(cookie.getName()))return(cookie.getValue());}return(defaultValue);}public boolean checklogin(String username,String password) {try{DBConn loginConn = new DBConn();loginConn.executeQuery("select * from tbl_user where name='" + username + "'");if(loginConn.rs_next()){System.out.println("Connection created!");if(loginConn.rs_getString("pwd").trim().equals(password)) {System.out.println(loginConn.rs_getString("name"));return true;}else{return false;}}System.out.println("Test Login Success!");return false;}catch(Exception e){System.out.println(e.toString());return false;}}public static void main(String args[]){login mylogin = new login();System.out.println(mylogin.checklogin("shandong","shando ng"));}}说明：1、默认的jdk1.4中并没有servlet包，请至sun公司网页下载servlet.jar，放至jdk目录下的jre\lib\目录下，并在JCreator中设置jdk处添加servlet.jar包2、本Servlet用于检验用户名和密码，若正确则将用户名写入Cookie，完成后将当前页重定向到index.jsp页五、编写检测用户是否已经登陆的bean：checkLogin.java//checkLogin.java//import required classesimport java.io.*;import javax.servlet.*;import javax.servlet.http.*;//class checkLoginpublic class checkLogin{public String username = "";public boolean check(HttpServletRequestreq,HttpServletResponse res)throws IOException,ServletException{String cookieName = "username";Cookie[] myCookies = req.getCookies();ername =this.getCookieValue(myCookies,cookieName,"not found"); PrintWriter out = res.getWriter();if(ername != null){//out.println("早上好，" + ername + "！"); return true;}else{out.println("登陆失败！");return false;}}public String getUserName(){return ername;}public static String getCookieValue(Cookie[] cookies,String cookieName,String defaultValue){for(int i=0;i<cookies.length;i++) {Cookie cookie = cookies[i];if (cookieName.equals(cookie.getName()))return(cookie.getValue());}return(defaultValue);}}说明：此bean检测cookie中的username，若不为空则说明已登录，反之说明没有登录。

使⽤JSP实现简单的⽤户登录注册页⾯⽰例代码解析实验要求：将实验2中的系统⽤户登录和注册页⾯改为JSP页⾯，并部署⾃⼰的Web应⽤于Tomcat服务器中具体要求：完成登录JSP页⾯设计和注册页⾯设计在登录页⾯表单中使⽤request对象获取⽤户信息，建⽴新的JSP页⾯完成登录验证（⽤户名和密码⾃⼰指定即可）。

验证结果显⽰（如登录成功/⽤户名密码错误，可以使⽤JavaScript，也可以使⽤新的JSP页⾯）。

在注册页⾯表单中使⽤request对象获取⽤户注册信息（注册项⽬由⾃⼰指定），在新的JSP页⾯显⽰⽤户注册信息，并提⽰注册成功。

代码登录页⾯index.html<!DOCTYPE html><html lang="zh-CN"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1"><title>jsp作业</title><link href="css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet"></head><body><nav class="navbar navbar-default"><div class="container-fluid"><div class="navbar-header"><a class="navbar-brand" href="./" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >jsp作业</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav navbar-right"><li><a href="login.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >登录</a></li></ul></div></div></nav><div class="container"><div class="jumbotron"><h1>Hello, world!</h1><p>这是⼀个jsp作业</p></div></div></body></html>登录页⾯login.jsp<%@ page contentType="text/html; charset=utf-8" language="java"%><html lang="zh-CN"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1"><title>登录</title><link href="css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet"></head><body><nav class="navbar navbar-default"><div class="container-fluid"><div class="navbar-header"><a class="navbar-brand" href="./" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >jsp作业</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav navbar-right"><li><a href="login.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >登录</a></li></ul></div></div></nav><div class="container"><div class="row"><div class="col-md-4"></div><div class="col-md-4"><form class="form-signin" method="post" action="login-check.jsp"><h2 class="form-signin-heading">登录到jsp作业</h2><label for="">⽤户名</label><input type="text" name="username" id="username" class="form-control" placeholder="请输⼊⽤户名" required autofocus><br><label for="">密码</label><input type="password" name="password" id="password" class="form-control" placeholder="请输⼊密码" required><div class="checkbox"><label><input type="checkbox" value="remember-me" checked="checked"> 记住密码</label></div><button type="submit" class="btn btn-primary" id="btn-login">登录</button><a href="reg.jsp" rel="external nofollow" rel="external nofollow" class="btn btn-default">注册</a></form></div><div class="col-md-4"></div></div></body></html>登录结果页⾯login-check.jsp<%@ page contentType="text/html; charset=utf-8" language="java"%><html lang="zh-CN"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1"><title>登录</title><link href="css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet"></head><body><nav class="navbar navbar-default"><div class="container-fluid"><div class="navbar-header"><a class="navbar-brand" href="./" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >jsp作业</a><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav navbar-right"><li><a href="login.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >登录</a></li></ul></div></div></nav><div class="container"><div class="row"><div class="col-md-4"></div><div class="col-md-4"><form class="form-signin" method="post" action="login-check.jsp"><h2 class="form-signin-heading">登录到jsp作业</h2><label for="">⽤户名</label><input type="text" name="username" id="username" class="form-control" placeholder="请输⼊⽤户名" required autofocus><br><label for="">密码</label><input type="password" name="password" id="password" class="form-control" placeholder="请输⼊密码" required><div class="checkbox"><label><input type="checkbox" value="remember-me" checked="checked"> 记住密码</label></div><button type="submit" class="btn btn-primary" id="btn-login">登录</button><a href="reg.jsp" rel="external nofollow" rel="external nofollow" class="btn btn-default">注册</a></form></div><div class="col-md-4"></div></div></body></html>注册页⾯reg.jsp<%@ page contentType="text/html; charset=utf-8" language="java"%><html lang="zh-CN"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1"><title>注册</title><link href="css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet"></head><body><nav class="navbar navbar-default"><div class="container-fluid"><div class="navbar-header"><a class="navbar-brand" href="./" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >jsp作业</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav navbar-right"><li><a href="login.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >登录</a></li></ul></div></div></nav><div class="container"><div class="row"><div class="col-md-4"></div><div class="col-md-4"><form class="form-signin" action="reg-submit.jsp" method="post"><h2 class="form-signin-heading">注册到jsp作业</h2><div id="info"></div><label for="">⽤户名</label><input type="text" name="username" id="username" class="form-control" placeholder="请输⼊⽤户名" required autofocus><br><label for="">密码</label><input type="password" name="password" id="password" class="form-control" placeholder="请输⼊密码" required><br><label for="">重复密码</label><input type="password" name="password2" id="password2" class="form-control" placeholder="请再次输⼊密码" required maxLength="16"><br><button type="submit" class="btn btn-primary" id="btn-reg">注册</button><a href="login.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="btn btn-default" id="btn-reg">返回登录</a> </form></div><div class="col-md-4"></div></div></body></html>注册结果页⾯reg-submit.jsp<%@ page contentType="text/html; charset=utf-8" language="java"%><html lang="zh-CN"><head><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1"><title>结果</title><link href="css/bootstrap.min.css" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="stylesheet"></head><body><nav class="navbar navbar-default"><div class="container-fluid"><div class="navbar-header"><a class="navbar-brand" href="./" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >jsp作业</a></div><div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"><ul class="nav navbar-nav navbar-right"><li><a href="login.jsp" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >登录</a></li></ul></div></div></nav><div class="container"><% String username = request.getParameter("username");String password = request.getParameter("password");String password2 = request.getParameter("password2");%><%if(password.equals(password2)){out.println("<div class='alert alert-success' role='alert'>注册成功</div>");out.println("<ul class='list-group'>");out.println("<li class='list-group-item'>⽤户名：" + username + "</li>");out.println("<li class='list-group-item'>密码：" + password + "</li>");out.println("</ul>");else{out.println("<div class='alert alert-danger' role='alert'>两次密码输⼊不⼀致，请重新输⼊</div>"); }%><!-- <%=username %><%=password %><%=password2 %> --></div>效果到此这篇关于使⽤JSP实现简单的⽤户登录注册页⾯⽰例代码解析的⽂章就介绍到这了,更多相关JSP实现简单的⽤户登录注册页⾯内容请搜索以前的⽂章或继续浏览下⾯的相关⽂章希望⼤家以后多多⽀持！。

JSP登录与注册的⼩案例<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="/2001/XMLSchema-instance" xmlns="/xml/ns/javaee" xsi:schemaLocation="/xml/ns/javaee /xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" <servlet><servlet-name>Register</servlet-name><servlet-class>com.zr.homework.servlet.Register</servlet-class></servlet><servlet><servlet-name>LoginServlet</servlet-name><servlet-class>com.zr.homework.servlet.LoginServlet</servlet-class></servlet><servlet-mapping><servlet-name>Register</servlet-name><url-pattern>/Register</url-pattern></servlet-mapping><servlet-mapping><servlet-name>LoginServlet</servlet-name><url-pattern>/LoginServlet</url-pattern></servlet-mapping></web-app><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><base href="<%=basePath%>"><title>My JSP 'index.jsp' starting page</title><meta http-equiv="pragma" content="no-cache"><meta http-equiv="cache-control" content="no-cache"><meta http-equiv="expires" content="0"><meta http-equiv="keywords" content="keyword1,keyword2,keyword3"><meta http-equiv="description" content="This is my page"><!--<link rel="stylesheet" type="text/css" href="styles.css">--></head><body>登陆成功<br></body></html><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>登录页⾯</title><script type="text/javascript">function checkName(){// 获取相应标签var name = document.getElementsByName("name")[0];// 获取下⼀个兄弟节点var userTip = name.nextSibling;userTip.style.color="red";// 判断⽤户名是否为空,空提⽰错误if(name.value=="" || name.value==null){userTip.innerHTML = "⽤户名不能为空";}else{var request = new XMLHttpRequest();var method = "GET";var url = "LoginServlet?name="+name.value;request.open(method, url, true, null, null);request.send(null);request.onreadystatechange = function(){if(request.readyState==4){if(request.status==200 || request.status==304){userTip.innerHTML = request.responseText;}}};};}function checkPwd(){// 获取相应标签var name = document.getElementsByName("password")[0];// 获取下⼀个兄弟节点var userTip = name.nextSibling;userTip.style.color="red";// 判断⽤户名是否为空,空提⽰错误if(name.value=="" || name.value==null){userTip.innerHTML = "密码不能为空";}else{userTip.innerHTML = "";}}</script></head><body><h1>登录</h1><form action="LoginServlet" method="post">⽤户名:<input type="text" name="name" onblur="checkName()" value="${ }"><span></span><br><br>密码:<input type="password" name="password" onblur="checkPwd()" value="${param.password }"><span></span><br><br><input type="submit" value="登录"></form></body></html><%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>注册页⾯</title><script type="text/javascript" src="js/jqeury/jquery-3.1.0.min.js"></script><script type="text/javascript" src="js/register.js"></script></head><body><form action="Register" method="post">⽤户名:<input type="text" id="name" name="name"><span></span><br><br>密码:<input type="password" att="one" name="password" placeholder="3到15位字母和数字"><span></span><br><br>确认密码:<input type="password" att="two"><span></span><br><br>邮箱:<input type="text" class="email" name="email"><span></span><br><br>⾝份证号:<input type="text" class="IDCard" name="IDCard"><span></span><br><br>出⽣年⽉⽇:<input type="text" readonly="readonly" name="birthday"><span></span><br><br><input type="submit" value="提交" onclick="return checkRegister()"></form></body></html>$(function(){$("span").css("color","red");$("#name").blur(function(){var value = $("#name").val();//如果为空，提⽰不能为空，否则清除提⽰信息if(value==null || value==""){$("#name+span").html("⽤户名不能为空");}else{$.post("Register",{"name":value,"action":"requery"},function(data){var isRegistered = eval("("+data+")");if(isRegistered==true){$("#name+span").html("该⽤户已被注册");}else{$("#name+span").html("");}},"text");}$("input[att=one]").blur(function(){var value = $("input[att=one]").val();//如果为空，提⽰不能为空，否则清除提⽰信息if(value==null || value==""){$("input[att=one]+span").html("密码不能为空");}else{$("input[att=one]+span").html("");}});$("input[att=two]").blur(function(){var value = $("input[att=two]").val();//如果为空，提⽰不能为空，否则清除提⽰信息if(value==null || value==""){$("input[att=two]+span").html("确认密码不能为空");}else{$("input[att=two]+span").html("");}});$(".email").blur(function(){var value = $(".email").val();//如果为空，提⽰不能为空，否则清除提⽰信息if(value==null || value==""){$(".email+span").html("邮箱不能为空");}else{$(".email+span").html("");}});$(".IDCard").blur(function(){var value = $(".IDCard").val();//如果为空，提⽰不能为空，否则清除提⽰信息if(value==null || value==""){$(".IDCard+span").html("⾝份证号不能为空");}else{$(".IDCard+span").html("");}// 从⾝份证号中截取⽣⽇var str = value.substring(6,14);var year = str.substring(0,4);var month = str.substring(4,6);var day = str.substring(6,8);var birthday = year+"-"+month+"-"+day;$("input[readonly=readonly]").val(birthday);});});});function checkRegister(){//检查参数是否为空var value1 = $("#name").val();if(value1==null || value1==""){$("#name+span").html("⽤户名不能为空");return false;}var value2 = $("input[att=one]").val();if(value2==null || value2==""){$("input[att=one]+span").html("密码不能为空");return false;}var value3 = $("input[att=two]").val();if(value3==null || value3==""){$("input[att=two]+span").html("确认密码不能为空");return false;}var value4 = $(".email").val();if(value4==null || value4==""){$(".email+span").html("邮箱不能为空");return false;}var value5 = $(".IDCard").val();if(value5==null || value5==""){$(".IDCard+span").html("⾝份证号不能为空");return false;}//检查密码是否正确(暂时不处理，密码的正则表达式)var pwdIsRight = false;// 3到15位字母和数字var reg1 = /^[a-zA-Z0-9]{3,15}$/;// 包含字母var reg2 = /[a-zA-Z]/;// 包含数字var reg3 = /[0-9]/;if(reg1.test(value2)&&reg2.test(value2)&&reg3.test(value2)){$("input[att=one]+span").html("");pwdIsRight = true;}else{$("input[att=one]+span").html("密码不正确");return false;}//检查密码与确认密码是否相同var isEqual = false;if(value2==value3){isEqual = true;$("input[att=one]+span").html("");}else{$("input[att=one]+span").html("密码不匹配");return false;}// 检查邮箱是否正确var emailIsRight = false;var regEmail = /^([a-z0-9_\.-]+)@([\da-z\.-]+)\.([a-z\.]{2,6})$/;if(regEmail.test(value4)){$(".email+span").html("");emailIsRight = true;}else{$(".email+span").html("邮箱不正确");return false;}var IDIsRight = false;// 18位数字var regID = /^[0-9]{18}$/;if(regID.test(value5)){IDIsRight = true;$(".IDCard+span").html("");}else{$(".IDCard+span").html("⾝份证号不正确");return false;}//如果全都正确就返回true，否则返回falseif(pwdIsRight==true && isEqual==true && emailIsRight==true && IDIsRight==true){ return true;}return false;}<?xml version="1.0" encoding="UTF-8"?><!-- c3p0-config.xml⽂件配置 --><c3p0-config><named-config name="getconnection"><!-- 基本配置 --><property name="user">LF</property><property name="password">LF</property><property name="jdbcUrl">jdbc:oracle:thin:@192.168.10.105:1521:orcl</property> <property name="driverClass">oracle.jdbc.driver.OracleDriver</property><!-- 配置初始值 --><property name="initialPoolSize">16</property><property name="maxPoolSize">25</property><property name="minPoolSize">10</property></named-config></c3p0-config>package com.zr.homework.utils;import java.sql.Connection;import java.sql.SQLException;import javax.sql.DataSource;import boPooledDataSource;public class JdbcUtils {/*** 获取数据库连接* @return*/public static Connection getConnection() {DataSource ds = new ComboPooledDataSource("getconnection");Connection connection = null;try {connection = ds.getConnection();return connection;} catch (SQLException e) {e.printStackTrace();}return null;}}package com.zr.homework.pojo;public class Person {private String name;//⽤户名private String password;//密码private String email;//邮箱private String ID;//⾝份证private String birthday;//出⽣年⽉⽇public String getName() {return name;}public void setName(String name) { = name;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public String getID() {return ID;}public void setID(String iD) {ID = iD;}public String getBirthday() {return birthday;}public void setBirthday(String birthday) {this.birthday = birthday;}public Person() {super();}public Person(String name, String password, String email, String iD,String birthday) {super(); = name;this.password = password;this.email = email;ID = iD;this.birthday = birthday;}@Overridepublic String toString() {return "Person [name=" + name + ", password=" + password + ", email="+ email + ", ID=" + ID + ", birthday=" + birthday + "]";}}package com.zr.homework.servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import erDaoImpl;import erServiceImpl;import com.zr.homework.pojo.Person;/**** @author lf**/public class LoginServlet extends HttpServlet {private static final long serialVersionUID = 1L;@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {/*System.out.println("LoginServlet...doGet...");*/resp.setCharacterEncoding("utf-8");String name = req.getParameter("name");UserServiceImpl impl = new UserServiceImpl();Person p = new Person(name, null, null, null, null);boolean had = impl.requeryUserService(p);System.out.println(had);if(had){resp.getWriter().print("");}else{resp.getWriter().print("该⽤户不存在");}}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {System.out.println("LoginServlet...doPost...");String name = request.getParameter("name");String password = request.getParameter("password");System.out.println(name+","+password);Person p = new Person(name, password, null, null, null);UserServiceImpl impl = new UserServiceImpl();boolean success = impl.loginService(p);if (success) {response.sendRedirect(request.getContextPath()+"/index.jsp");}else {request.getRequestDispatcher("/login.jsp").forward(request, response);}}}package com.zr.homework.servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import erDaoImpl;import erService;import erServiceImpl;import com.zr.homework.pojo.Person;public class Register extends HttpServlet {private static final long serialVersionUID = 1L;@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {System.out.println("doGet...");}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {System.out.println("Register...doPost...");UserServiceImpl impl = new UserServiceImpl();String name = request.getParameter("name");String action = request.getParameter("action");// 检查是查询还是注册if("requery".equals(action)){Person p = new Person(name, null, null, null, null);boolean isExited = impl.requeryUserService(p);response.getWriter().print(isExited);}else{System.out.println("注册⽤户");//获取相应的值String username = request.getParameter("name");String password = request.getParameter("password");String email = request.getParameter("email");String IDCard = request.getParameter("IDCard");String birthday = request.getParameter("birthday");System.out.println("birthday:"+birthday);Person person = new Person(username, password, email, IDCard, birthday); System.out.println(person);// 注册服务boolean isSuccess = impl.addUserService(person);// 如果注册成功，重定向到登录页⾯，否则重定向到错误页⾯if(isSuccess){response.sendRedirect(request.getContextPath()+"/login.jsp");}else {response.sendRedirect(request.getContextPath()+"/error.jsp");}}}}package erDao;import java.util.List;import com.zr.homework.pojo.Person;/**** @author lf**/public interface UserDao {/*** 查询* @param p ⽤户* @return*/public boolean requeryUser(Person p);/*** 添加⽤户* @param p ⽤户* @return*/public boolean addUser(Person p);/*** ⽤户登录* @param p* @return*/public boolean userLogin(Person p);}package erDao.impl;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import erDao;import com.zr.homework.pojo.Person;import com.zr.homework.utils.JdbcUtils;public class UserDaoImpl implements UserDao{@Overridepublic boolean requeryUser(Person p) {boolean isExited = false;// 如果为空，直接返回falseif (p==null) {return isExited;}//获取连接Connection connection = JdbcUtils.getConnection();//SQL语句String sql = "SELECT NAME FROM HW WHERE NAME=?";//创建预编译PreparedStatement pStatement = null;ResultSet rSet = null;try {// 执⾏SQL语句pStatement = connection.prepareStatement(sql);// 设置相应的参数pStatement.setString(1, p.getName());//查询结果集，有就返回ture，否则返回falserSet = pStatement.executeQuery();if (rSet.next()) {isExited = true;}} catch (SQLException e) {e.printStackTrace();}finally{//关闭相应对象try {if (rSet!=null) {rSet.close();}if (pStatement!=null) {pStatement.close();}if (connection!=null) {connection.close();}} catch (Exception e) {e.printStackTrace();}}return isExited;}@Overridepublic boolean addUser(Person p) {boolean isSuccess=false;// 如果为空，直接返回falseif (p==null) {return false;}//获取连接Connection connection = JdbcUtils.getConnection();//SQL语句String sql = "INSERT INTO HW VALUES(?,?,?,?,?)";//创建预编译PreparedStatement pStatement = null;int successAmount = -1;try {// 执⾏SQL语句pStatement = connection.prepareStatement(sql);// 设置相应的参数pStatement.setString(1, p.getName());pStatement.setString(2, p.getPassword());pStatement.setString(3, p.getEmail());pStatement.setString(4, p.getID());pStatement.setString(5, p.getBirthday());//操作成功数⼤于零，就返回ture，否则返回falsesuccessAmount = pStatement.executeUpdate();if (successAmount>0) {isSuccess = true;}} catch (SQLException e) {e.printStackTrace();}finally{//关闭相应对象try {if (pStatement!=null) {pStatement.close();}if (connection!=null) {connection.close();}} catch (Exception e) {e.printStackTrace();}}return isSuccess;}@Overridepublic boolean userLogin(Person p) {boolean isExited = false;// 如果为空，直接返回falseif (p==null) {return isExited;}//获取连接Connection connection = JdbcUtils.getConnection();//SQL语句String sql = "SELECT NAME FROM HW WHERE NAME=? AND PASSWORD=?";//创建预编译PreparedStatement pStatement = null;ResultSet rSet = null;try {// 执⾏SQL语句pStatement = connection.prepareStatement(sql);// 设置相应的参数pStatement.setString(1, p.getName());pStatement.setString(2, p.getPassword());//查询结果集，有就返回ture，否则返回falserSet = pStatement.executeQuery();if (rSet.next()) {isExited = true;}} catch (SQLException e) {e.printStackTrace();}finally{//关闭相应对象try {if (rSet!=null) {rSet.close();}if (pStatement!=null) {pStatement.close();}if (connection!=null) {connection.close();}} catch (Exception e) {e.printStackTrace();}}return isExited;}}package erService;import com.zr.homework.pojo.Person;/**** @author lf**/public interface UserService {/*** ⽤户查询服务* @param p* @return*/public boolean requeryUserService(Person p);/*** 注册服务* @param p* @return*/public boolean addUserService(Person p);/*** 登陆服务* @param p* @return*/public boolean loginService(Person p);}package erServiceImpl;import erDaoImpl; import erService; import com.zr.homework.pojo.Person;public class UserServiceImpl implements UserService{ /*** ⽤户查询*/@Overridepublic boolean requeryUserService(Person p) {UserDaoImpl impl = new UserDaoImpl();return impl.requeryUser(p);}/*** 注册服务*/@Overridepublic boolean addUserService(Person p) {UserDaoImpl impl = new UserDaoImpl();return impl.addUser(p);}@Overridepublic boolean loginService(Person p) {UserDaoImpl impl = new UserDaoImpl();return erLogin(p);}}。