单表CRUD

用任意一张数据表实现数据的增删改查

1. 编写数据库脚本

2. 开发要求

- 用户ID必须是email或者手机号码

- 性别只能是男或者女

- 学历信息：小学，初中，普高，大学专科，大学本科，硕士，博士，博士后

3. 开发数据库连接类

package cn.mldn.dbc;

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

public class DatabaseConnection {
	private static ThreadLocal<Connection> threadLocal = new ThreadLocal<Connection>();
	//定义JDBC常量
	public static final String DBDRIVER = "com.mysql.jdbc.Driver";
	public static final String DBURL = "jdbc:mysql://localhost:3302/project?useUnicode=true&characterEncoding=utf-8";
	public static final String DBUSER = "root";
	public static final String DBPWD = "123456";
	
	public static Connection get(){
		Connection conn = threadLocal.get();
		
			try {
				if(conn==null){
					conn = rebuildConnection();
					threadLocal.set(conn);
				}
				return conn;
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		return null;
	}
	
	public void close(){
		Connection conn  = threadLocal.get();
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	public static Connection rebuildConnection() throws Exception{
		Class.forName(DBDRIVER);
		return DriverManager.getConnection(DBURL, DBUSER, DBPWD);
	}
}

4. 开发VO类

5. 开发DAOFactory工厂类（用于获取DAO层对象）