JSP的分层开发

jsp的分层开发
工具包的构造

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/hospital?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;
	}
}

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

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

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

登录界面的编写

<%@ 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="login" 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>

注册页面

<%@ 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="register" 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>

完成代码的分层处理



如有错误，请大家指正。