java mysql封装类_java工具类--数据库操作封装类

packagecom.test;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;/*** 操作数据库工具类

*

**/

public classDbUtil {/*** 连接数据

*

*@returnconn*/

public staticConnection getConnection(String driver,String url,String username,String password) {

Connection conn= null;try{

Class.forName(driver);

conn=DriverManager.getConnection(url, username, password);

}catch(Exception e) {

e.printStackTrace();

}returnconn;

}/*** 关闭连接对象

*

*@paramconn

* 连接对象

*@parampstmt

* 预编译对象

*@paramrs

* 结果集*/

public static voidcloseAll(Connection conn, PreparedStatement pstmt, ResultSet rs) {try{if (rs != null) {

rs.close();

}if (pstmt != null) {

pstmt.close();

}if (conn != null) {

conn.close();

}

}catch(Exception e) {

e.printStackTrace();

}

}/*** 增删改操作

*

*@paramsql

* SQL命令

*@paramparam

* 参数

*@return

*/

public static intexecutUpdate(Connection conn,String sql, Object[] param) {int result = 0;

PreparedStatement pstmt= null;try{

pstmt=conn.prepareStatement(sql);if (param != null) {for (int i = 0; i < param.length; i++) {

pstmt.setObject(i+ 1, param[i]);

}

}

result=pstmt.executeUpdate();

}catch(Exception e) {

e.printStackTrace();

}finally{

closeAll(conn, pstmt,null);

}returnresult;

}/*** 查询

*

*@returnint

* @date 2015-7-25 上午11:10:06*/

public staticResultSet executQuery(Connection conn,String sql, String[] param) {

PreparedStatement pstmt= null;

ResultSet result= null;try{

pstmt=conn.prepareStatement(sql);if (param != null) {for (int i = 0; i < param.length; i++) {

pstmt.setString(i+ 1, param[i]);

}

}

result=pstmt.executeQuery();

}catch(Exception e) {

e.printStackTrace();

}returnresult;

}

}