mysql JDBC封装代码

这里写代码片
package com.first.DBHelper;
import java.sql.*;
public class DBhelp {

static final String URL = "jdbc:mysql://localhost:3306/user?useUnicode=true&&characterEncoding=UTF-8";
static final String USER_NAME = "root";
static final String PASSWORD = "123";


public static Connection getConn() {
	Connection conn = null;
	try {
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return conn;
}

// 执行查询的方法
public static ResultSet executeQuery(String sql,Connection  conn, Object...objects) {//Object...objects 动态的object数组
	ResultSet  rs=null;
	try {
		PreparedStatement ps = conn.prepareStatement(sql);
		if(objects.length!=0){
			for (int i = 0; i < objects.length; i++) {
				ps.setObject(i+1, objects[i]);
				
			}
		}
		 rs = ps.executeQuery();

	}  catch (SQLException e) {
		e.printStackTrace();
	}
   return  rs;
}

// 执行添加 修改 删除
public static void executeUpdate(String sql,Connection  conn,Object...objects) {
	try {
		PreparedStatement ps = conn.prepareStatement(sql);
		int count = ps.executeUpdate();
		
		if(objects.length!=0){
			for (int i = 0; i < objects.length; i++) {
				ps.setObject(i+1, objects[i]);
			}
			
		}

	}  catch (SQLException e) {
		e.printStackTrace();
	}

}


//进行Connection  关闭
public  static  void colseConn(Connection conn){
	if(conn!=null){
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}

}

这里写代码片