使用工厂模式的CRUD操作

一：定义Domain对象User

package cn.ccnu.domain;

import java.util.Date;

public class User {
	private int id;
	private String name;
	private int age;
	private Date birthday;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	
}

二：定义对user表进行操作的接口

package cn.ccnu.dao;

import cn.ccnu.domain.User;

public interface UserDao {
	public void addUser(User user);
	
	public void deleteUser(int id);
	
	public void updateUser(User user);
	
	public void findUser(int id);
}

三：用JDBC实现接口

1，实现一个JDBC操作的工具类

package JDBCUtils;

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

public class JDBCUtil {
	private static String url = "jdbc:mysql://localhost:3306/test";
	private static String user = "root";
	private static String password = "123456";
	
	static{
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConnection() throws SQLException{
		return DriverManager.getConnection(url, user, password);
	}
	
	public static void free(ResultSet rs, Statement st, Connection conn){
		if(rs != null){
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				if(st != null){
					try {
						st.close();
					} catch (SQLException e) {
						e.printStackTrace();
					}finally{
						if(conn != null){
							try {
								conn.close();
							} catch (SQLException e) {
								e.printStackTrace();
							}
						}
					}
				}
			}
		}
	}
}

2，JDBC实现接口

package cn.ccnu.dao.impl;

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

import JDBCUtils.JDBCUtil;

import cn.ccnu.dao.UserDao;
import cn.ccnu.domain.User;

public class UserDaoJDBCImpl implements UserDao {

	public void addUser(User user) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try {
			conn = JDBCUtil.getConnection();
			String sql = "insert into user(name, age, birthday) values(?, ?, ?)";
			ps = conn.prepareStatement(sql);
			ps.setString(1, user.getName());
			ps.setInt(2, user.getAge());
			ps.setDate(3, new Date(user.getBirthday().getTime()));
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			JDBCUtil.free(rs, ps, conn);
		}	
	}

	public void deleteUser(int id) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try {
			conn = JDBCUtil.getConnection();
			String sql = "delete from user where id = ?";
			ps = conn.prepareStatement(sql);
			ps.setInt(1, id);
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			JDBCUtil.free(rs, ps, conn);
		}
	}

	public void updateUser(User user) {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try {
			conn = JDBCUtil.getConnection();
			String sql = "update user set name = ?, age = ?, birthday = ? where id = ?";
			ps = conn.prepareStatement(sql);
			ps.setString(1, user.getName());
			ps.setInt(2, user.getAge());
			ps.setDate(3, new java.sql.Date(user.getBirthday().getTime()));
			ps.setInt(4, user.getId());
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			JDBCUtil.free(rs, ps, conn);
		}
		
	}

	public void findUser(int id) {

	}

}

到目前为止，可以实现对数据库的CRUD操作，但是只写到这里，也会导致与具体的数据库实现绑定在一起，如果要更改对数据库的操作方式，就要更改客户端代码，违背了软件开发过程中的开闭原则，可以考虑使用配置文件和反射来实现与具体类的耦合；

四：创建工厂类，利用配置文件和反射技术来确定具体使用哪种对数据库的操作方式

package cn.ccnu.dao;

import java.io.InputStream;
import java.util.Properties;

public class DaoFactory {
	private static UserDao userDao = null;
	private static DaoFactory instance = new DaoFactory();
	
	private DaoFactory(){
		try {
			Properties prop = new Properties();
			InputStream inStream = DaoFactory.class.getClassLoader().getResourceAsStream("daoConfig.properties");
			prop.load(inStream);
			String UserDaoClass = prop.getProperty("UserDaoClass");
			userDao = (UserDao) Class.forName(UserDaoClass).newInstance();
		} catch (Throwable e) {
			e.printStackTrace();
		}
		
	}
	
	public static DaoFactory getInstance(){
		return instance;
	}
	
	public static UserDao getUserDao(){
		return userDao;
	}
}

配置文件的写法

UserDaoClass = cn.ccnu.dao.impl.UserDaoJDBCImpl

五，客户端代码

package cn.ccnu.ui;

import java.util.Date;

import cn.ccnu.dao.DaoFactory;
import cn.ccnu.dao.UserDao;
import cn.ccnu.domain.User;

public class Client {

	public static void main(String[] args) {
		UserDao userDao = DaoFactory.getInstance().getUserDao();
		User u = new User();
		u.setName("Alex");
		u.setAge(20);
		u.setBirthday(new Date());
		userDao.addUser(u);
	}
}