DBUtil-数据库通用操作

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



public class DBUtil {
	private static final String URL="jdbc:mysql://127.0.0.1:3306/project";
	private static final String USERNAME="root";
	private static final String PASSWORD="root";
	public static Connection con=null;
	public static PreparedStatement pstmt=null;
	public static ResultSet rs=null;
	
	//加载驱动，连接数据库
	public static void initConnection(){
		try {
			Class.forName("com.mysql.jdbc.Driver");
			
			con = DriverManager.getConnection(URL,USERNAME,PASSWORD);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	
		
	}
	//通用的增删改
	public static boolean executeUpdate(String sql,Object[] params){
		initConnection();
		try {
			
			pstmt = con.prepareStatement(sql);
			if(params!=null){
				for(int i=0;i<params.length;i++){
					pstmt.setObject(i+1, params[i]);
				}
			}
			int count = pstmt.executeUpdate();
			if(count>0){
				return true;
			}else{
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		}finally{
				try {
					if(pstmt!=null)pstmt.close();
					if(con!=null)con.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		}
	}
	
	//通用的查
	public static ResultSet executeQuery(String sql,Object[] params){
		initConnection();
		try {
			
			pstmt = con.prepareStatement(sql);
			if(params!=null){
				for(int i=0;i<params.length;i++){
					pstmt.setObject(i+1, params[i]);
				}
			}
			rs = pstmt.executeQuery();
			
			return rs;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}
}
//查询要对结果进行处理，所以这里不关闭连接