用jsp实现交互的全过程

一、MVC MVC 模式代表 Model-View-Controller（模型-视图-控制器） 模式。这种模式用于应用程序的分层开发。 Model（模型） - 模型代表一个存取数据的对象或 JAVA POJO。它也可以带有逻辑，在数据变化时更新控制器。 View（视图） - 视图代表模型包含的数据的可视化。 Controller（控制器） - 控制器作用于模型和视图上。它控制数据流向模型对象，并在数据变化时更新视图。它使视图与模型分离开。 二、用代码来实现登录和注册 1、dao包，主要用来定义相关接口，并且需要相关的实现接口的方法，主要用来链接数据库； （1）、登录接口

package com.openlab.dao; public interface Login { public String doLogin(String _username,String _password); }

（2）、注册接口

package com.openlab.dao; import com.openlab.pojo.Employee; public interface Register { public String doRegister(Employee _employee); }

2、完成dao包中接口的实现 （1）、实现登录接口

package com.openlab.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.openlab.Utils.DBConn; import com.openlab.dao.Login; public class LoginImpl implements Login{ //验证登录是否成功 public String doLogin(String _username,String _password){ Connection conn=null; PreparedStatement pst=null; ResultSet rs=null; String result=""; String sql="select * from loginuser where userName=? and userPwd=?"; try { //conn=DbConnUtils.getConnection(); DBConn db=new DBConn(); conn=db.getConnection(); pst=conn.prepareStatement(sql); pst.setString(1, _username); pst.setString(2, _password); rs= pst.executeQuery(); } catch (SQLException e) { e.printStackTrace(); } try { if(rs.next()){ result= "success"; }else{ result= "fail"; } //DbConnUtils.closeAll(rs, pst, conn); DBConn.closeAll(rs, pst, null); } catch (SQLException e) { e.printStackTrace(); } return result; } }

（2）、实现注册接口

package com.openlab.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import com.openlab.Utils.DbConnUtils; import com.openlab.dao.Register; import com.openlab.pojo.Employee; public class RegisterImpl implements Register{ public String doRegister(Employee _employee){ Connection conn=null; PreparedStatement pst=null; String result=""; int count=0; String sql="insert into loginuser(userName,userPwd,userRePwd,sex,princal,email) values(?,?,?,?,?,?)"; try { conn=DbConnUtils.getConnection(); pst=conn.prepareStatement(sql); pst.setString(1, _employee.getRegisterName()); pst.setString(2, _employee.getRepassword()); pst.setString(3, _employee.getRerepassword()); pst.setInt(4, _employee.getSex()); pst.setString(5, _employee.getPrical()); pst.setString(6, _employee.getEmail()); count=pst.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } if(count>0){ result= "success"; }else{ result= "fail"; } DbConnUtils.closeAll(null,pst, conn); return result; } }

3、创建实体类

package com.openlab.pojo; public class Employee { private String RegisterName; private String repassword; private String rerepassword; private int sex; private String prical; private String email; public String getRegisterName() { return RegisterName; } public void setRegisterName(String registerName) { RegisterName = registerName; } public String getRepassword() { return repassword; } public void setRepassword(String repassword) { this.repassword = repassword; } public String getRerepassword() { return rerepassword; } public void setRerepassword(String rerepassword) { this.rerepassword = rerepassword; } public int getSex() { return sex; } public void setSex(int sex) { this.sex = sex; } public String getPrical() { return prical; } public void setPrical(String prical) { this.prical = prical; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } }

4、创建服务登录和注册的接口 （1）、创建服务登录接口

package com.openlab.service; import com.openlab.pojo.Employee; public interface LoginService { public String Login(Employee _Employee); }

（2）、创建服务注册接口

package com.openlab.service; import com.openlab.pojo.Employee; public interface RegisterService { public String Register(Employee _employee); }

5、同dao包一样，实现服务层的接口 （1）、实现服务层登录的接口

package com.openlab.service.impl; import com.openlab.dao.Login; import com.openlab.dao.impl.LoginImpl; import com.openlab.pojo.Employee; import com.openlab.service.LoginService; public class LoginServiceImpl implements LoginService { Login login=null; public String Login(Employee _Employee) { login=new LoginImpl(); return login.doLogin(_Employee.getRegisterName(), _Employee.getRepassword()); } }

（2）、实现服务层注册的接口

package com.openlab.service.impl; import com.openlab.dao.Register; import com.openlab.dao.impl.RegisterImpl; import com.openlab.pojo.Employee; import com.openlab.service.RegisterService; public class RegisterServiceImpl implements RegisterService { Register register=null; public String Register(Employee _employee) { register=new RegisterImpl(); return register.doRegister(_employee); } }

6、创建工具类 （1）、用jdbc写创建链接的方法

package com.openlab.Utils; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; public class DBConn { public Connection conn; Context ctx = null; // 定义创建连接的方法 public Connection getConnection() { try { ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/hospital"); conn = ds.getConnection(); } catch (Exception e) { e.printStackTrace(); } return conn; } public static void closeAll(ResultSet rs, Statement st, Connection conn) { // 关闭结果集 if (rs != null) { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (st != null) { try { st.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }

（2）、链接中包含的链接方法和关闭方法

package com.openlab.Utils; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class DbConnUtils { /* static String url="jdbc:mysql://127.0.0.1:3306/hospitalnew?useUnicode=true&characterEncoding=UTF-8"; static String username="root"; static String password="root";*/ static String driver=ConfigManager.getProperty("driver"); static String url=ConfigManager.getProperty("url"); static String username=ConfigManager.getProperty("username1"); static String password=ConfigManager.getProperty("password1"); public static Connection getConnection(){ Connection conn=null; try{ Class.forName(driver); //创建数据库连接 conn=DriverManager.getConnection(url, username, password); }catch(Exception e){ e.printStackTrace(); } return conn; } public static void closeAll(ResultSet rs,Statement st,Connection conn){ //关闭结果集 if(rs!=null){ try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if(st!=null){ try { st.close(); } catch (SQLException e) { e.printStackTrace(); } } if(conn!=null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static ResultSet getQueryList(Connection _conn,Statement _st,String _sql){ ResultSet rs=null; try { rs=_st.executeQuery(_sql); } catch (SQLException e) { e.printStackTrace(); } return rs; } }

7、通过jsp页面的代码来看看 （1）、登录的jsp页面

<%@ 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 'login.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="css/common.css"> <link rel="stylesheet" type="text/css" href="css/login.css"> </head> <body> <% /* Cookie cookies[] = request.getCookies(); boolean flag = false; if (cookies != null) { for (int i = 0; i < cookies.length; i++) { if (cookies[i].getName().equals("admin")) { flag = true; response.sendRedirect("index1.jsp"); break; } } } */ %> <h2>登录页面</h2> <div id="regiter"> <a href="regiter.jsp">注册</a> </div> <div> <form action="doLogin.jsp" method="post"> <table> <tr> <td>用户名：<input type="text" name="username" /></td> </tr> <tr> <td>密码：<input type="password" name="password" /></td> </tr> <tr> <td><span style="color:red;"> <%-- <% if (session.getAttribute("errors") != null) { out.print(session.getAttribute("errors")); } %> --%> <% if (session.getAttribute("errors") != null) { %> <%=session.getAttribute("errors")%> <% } %> </span> </td> </tr> <tr> <td><input type="submit" value="登录" /> <input type="reset" value="取消" /> </td> </tr> </table> </form> </div> </body> </html>

（2）、处理登录的jsp页面

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ page import="com.openlab.service.*,com.openlab.service.impl.*,com.openlab.pojo.*" %> <% 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 'doLogin.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> <% //处理post请求乱码 request.setCharacterEncoding("UTF-8"); String username = request.getParameter("username"); //String username=new String(users.getBytes("ISO-8859-1"),"UTF-8"); String password = request.getParameter("password"); LoginService login = new LoginServiceImpl(); Employee employee=new Employee(); employee.setRegisterName(username); employee.setRepassword(password); String result = login.Login(employee); if (result.equals("success")) { //登陆成功 //request.setAttribute("login", username); //将登陆人的名字保存在请求范围 session.setAttribute("login", username); //将登陆人的名字保存在会话范围 //response.sendRedirect("index1.jsp"); //重定向 //request.getRequestDispatcher("index1.jsp").forward(request, response); //转发 Cookie cookie1 = new Cookie(username, password); cookie1.setMaxAge(3600); response.addCookie(cookie1); RequestDispatcher rd = request.getRequestDispatcher("index1.jsp"); rd.forward(request, response); } else { session.setAttribute("errors", "用户名密码不正确，请重新输入..."); //登陆失败 response.sendRedirect("login.jsp"); } %> <%-- 用户名：<%=username %> 密码：<%=password %> --%> </body> </html>

（3）、注册页面的jsp页面

<%@ 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 'regiter.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="css/common.css"> </head> <body> <h2>欢迎来西安市交通大学第一附属医院</h2> <div> <form action="doRegister.jsp" method="post"> <table> <tr> <td>用户名：</td> <td><input type="text" name="registerName" /></td> </tr> <tr> <td>密码：</td> <td><input type="password" name="registerPassword" /></td> </tr> <tr> <td>再次输入密码：</td> <td><input type="password" name="reregisterPassword" /></td> </tr> <tr> <td>性别：</td> <td><input type="radio" name="sex" value="0" checked="checked" />男 <input type="radio" name="sex" value="1" />女</td> </tr> <tr> <td>身份：</td> <td><select name="princal"> <option>--请选择--</option> <option value="doctor">医生</option> <option value="nurse">护士</option> <option value="yuanzhang">院长</option> <option value="admin">管理员</option> </select></td> </tr> <tr> <td>email：</td> <td><input type="text" name="email" /></td> </tr> <tr> <td> <% if (session.getAttribute("errorsRegister") != null) { out.print(session.getAttribute("errorsRegister")); } %> </td> </tr> <tr> <td><input type="submit" value="注册" /> </td> <td><input type="reset" value="取消" /> </td> </tr> </table> </form> </div> </body> </html>

（4）、处理注册的jsp页面

<%@page import="com.openlab.pojo.Employee,com.openlab.service.*,com.openlab.service.impl.*"%> <%@ 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 'doRegister.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="css/common.css"> </head> <body> <h2>注册页面</h2> <% request.setCharacterEncoding("UTF-8"); String registerName = request.getParameter("registerName"); String registerPassword = request.getParameter("registerPassword"); String reregisterPassword = request.getParameter("reregisterPassword"); String sex = request.getParameter("sex"); String princal = request.getParameter("princal"); String email = request.getParameter("email"); Employee _employee = new Employee(); _employee.setRegisterName(registerName); _employee.setRepassword(registerPassword); _employee.setRerepassword(reregisterPassword); _employee.setSex(Integer.parseInt(sex)); _employee.setPrical(princal); _employee.setEmail(email); RegisterService register = new RegisterServiceImpl(); String result = register.Register(_employee); if (result.equals("success")) { response.sendRedirect("login.jsp"); } else { session.setAttribute("errorsRegister", "注册失败..."); response.sendRedirect("register.jsp"); } %> </body> </html>

总结：这是一个相对比较基础的实现过程，我只是总结一下流程方便理解，加油哈！