三层架构的项目集成和回顾

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

<form action="doLogin.jsp">
	<p><input type="text" name="username"></p>
	<p><input type="text" name="password"></p>
	<p>
		<button>登录</button>
	</p>
</form>

</body>
</html>

登录处理界面 doLogin.jsp

<%@page import="com.xyz.biz.IUserBiz"%>
<%@page import="com.xyz.biz.impl.UserBizImpl"%>
<%@page import="com.xyz.pojo.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	//doLogin是表示层
	
	//取到用户的数据
	String username=request.getParameter("username");
	String password=request.getParameter("password");
	
	//将数据分装到实体类中
	User user=new User(0,username,password);
	
	//判断用户是否登录
	
	//面向接口编程
	// 1.先编写接口
	// 2.实现该接口
	// 3.使用里氏替换原则来声明接口对象
	// 4.调用接口的方法
	IUserBiz userBiz=new UserBizImpl();
	
	String msg=userBiz.login(user);
	
%>
<h1><%=msg %></h1>

连接数据库 DBHelper.java

package com.xyz.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import oracle.jdbc.driver.OracleDriver;

public class DBHelper {
	
	//1.加载驱动
	static {
		//OracleDriver
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	//2.定义连接字符串
	private static final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
	
	//3.获得连接
	public static Connection getCon() {
		try {
			return DriverManager.getConnection(URL,"scott","zkingedu");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
	//4.关闭资源
	public static void close(Connection con,PreparedStatement ps,ResultSet rs) {
		try {
			if(!con.isClosed()) {
				con.close();
			}
			if(ps!=null) {
				ps.close();
			}
			if(rs!=null) {
				rs.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

用户的实体类 User.java

package com.xyz.pojo;

public class User {

	private Integer userId;
	private String userName;
	private String userPwd;
	
	public Integer getUserId() {
		return userId;
	}
	public void setUserId(Integer userId) {
		this.userId = userId;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getUserPwd() {
		return userPwd;
	}
	public void setUserPwd(String userPwd) {
		this.userPwd = userPwd;
	}
	
	public User() {
		// TODO Auto-generated constructor stub
	}
	
	public User(Integer userId, String userName, String userPwd) {
		super();
		this.userId = userId;
		this.userName = userName;
		this.userPwd = userPwd;
	}
	
	
}

针对用户的接口 IUserBiz.java

package com.xyz.biz;

import com.xyz.pojo.User;

/**
 * 接口
 * @author zjjt
 *
 */

public interface IUserBiz {

	String login(User user);
	
}

用户接口的实现 UserBizImpl.java

package com.xyz.biz.impl;

import com.xyz.biz.IUserBiz;
import com.xyz.dao.IUserDao;
import com.xyz.dao.impl.UserDaoImpl;
import com.xyz.pojo.User;

public class UserBizImpl implements IUserBiz{

	/**
	 * IUserBiz的实现类
	 * @author zjjt
	 *
	 */
	
	//需要调用dao层的方法
	
	//一个厨师对应多个送菜的人
	private IUserDao userDao=new UserDaoImpl();
	
	
	@Override
	public String login(User user) {
		User u=userDao.login(user);
		// user 表示层给我的（用户输入）
		// u 数据库来的
		if(u==null) {
			return "account not found";
		}
		if(!u.getUserPwd().equals(user.getUserPwd())) {
			return "password error";
		}
		return "login success";
	}
		
	
}

数据库访问接口类 IUserDao.java

package com.xyz.dao;

import com.xyz.pojo.User;

public interface IUserDao {

	User login(User user);
	
}

实现数据库访问的类 IUserDaoImpl.java

package com.xyz.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.xyz.dao.IUserDao;
import com.xyz.pojo.User;
import com.xyz.util.DBHelper;

public class UserDaoImpl implements IUserDao{
	
	private Connection con;
	private PreparedStatement ps;
	private ResultSet rs;
	
	@Override
	public User login(User user) {
		try {
			con=DBHelper.getCon();
			String sql="select * from t_user where user_name=?";
			ps=con.prepareStatement(sql);
			ps.setString(1, user.getUserName());
			rs=ps.executeQuery();
			if(rs.next()) {
				//将信息赋值给User对象
				User u=new User();
				u.setUserName(rs.getString(2));
				return u;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, rs);
		}
		return null;
	}

}

今天就分享到这啦