DBUtil-数据库连接工具类

/**
 * 	数据库连接工具类
 */
public class DBUtil {
	
	private static final String DRIVER = "com.mysql.jdbc.Driver";
	private static final String URL = "jdbc:mysql:///数据库名字";
	private static final String USERNAME = "root";
	private static final String PASSWORD = "1234";
	
	/**
	 * 注册驱动
	 */
	static {
		try {
			Class.forName(DRIVER);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	/**
	 * 获取连接对象
	 * @return
	 * @throws SQLException 
	 */
	public static Connection getConn() throws SQLException {
		return DriverManager.getConnection(URL, USERNAME, PASSWORD);
	}
	
	/**
	 * 增删改通用方法
	 * @param sql
	 * 		sql语句
	 * @param objects
	 * 		需要传递的参数
	 * @return
	 * 		0代表失败
	 * 		1代表成功
	 */
	public static int curd(String sql,Object...objects) {
		//获取连接对象
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = getConn();
			//预编译对象
			ps = conn.prepareStatement(sql);
			if(null != objects) {
				for(int i=0;i<objects.length;i++) {
					ps.setObject(i+1, objects[i]);
				}
			}
			//执行sql
			return ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			close(conn,ps,null);
		}
		return 0;
	}
	
	/**
	 * 关闭数据库连接对象
	 * @param conn
	 * @param st
	 * @param rs
	 * 	如果非查询操作，该参数传递null即可
	 */
	public static void close(Connection conn,Statement st,ResultSet rs) {
		try {
			if(null != rs) {
				rs.close();
			}
			if(null != st) {
				st.close();
			}
			if(null != conn) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}