java 封装数据库操作_封装JAVA数据库操作

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLException;importjava.sql.PreparedStatement;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;public classBaseDao {public final static String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";public final static String URL = "jdbc:sqlserver://localhost:1433;databaseName=boor";public final static String USERNAME = "sa";public final static String PASSWORD = "";**

*

* @return获得数据库连接* @throwsSQLException* @throwsClassNotFoundException*

publicConnection getConn() {

Connection conn= null;try{

Class.forName(DRIVER);

}catch(ClassNotFoundException e) {

e.printStackTrace();

}try{

conn=DriverManager.getConnection(URL, USERNAME, PASSWORD);

}catch(SQLException e) {

e.printStackTrace();

}returnconn;

}**

*关闭数据库连接*@param conn数据库连接*@param prsts PreparedStatement 对象*@param rs结果集*

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

rs.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (prsts != null) {try{

prsts.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (conn != null) {try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}**

*执行增、删、改SQL语句*

*@param sql*sql语句*@param param*值集*@param type*值类型集* @return受影响的行数*

public int executeUpdate(String sql, Object[] param, int[] type) {int rows = 0;

Connection conn= this.getConn();

PreparedStatement prsts= null;try{

prsts=conn.prepareStatement(sql);for (int i = 1; i <= param.length; i++) {

prsts.setObject(i, param[i- 1], type[i - 1]);

}

rows=prsts.executeUpdate();

}catch(SQLException e) {

e.printStackTrace();

}finally{this.closeAll(conn, prsts, null);

}returnrows;

}**

*执行查询SQL语句*

*@param sql*sql语句*@param param*值集*@param type*值类型集* @return结果集*

public List executeQuery(String sql, Object[] param, int[] type) {

ResultSet rs= null;

List list= null;

Connection conn= this.getConn();

PreparedStatement prsts= null;try{

prsts=conn.prepareStatement(sql);for (int i = 1; i <= param.length; i++) {

prsts.setObject(i, param[i- 1], type[i - 1]);

}

rs=prsts.executeQuery();

list= newArrayList();

ResultSetMetaData rsm=rs.getMetaData();

Map map= null;while(rs.next()) {

map= newHashMap();for (int i = 1; i <= rsm.getColumnCount(); i++) {

map.put(rsm.getColumnName(i), rs.getObject(rsm.getColumnName(i)));

}

list.add(map);

}

}catch(SQLException e) {

e.printStackTrace();

}finally{this.closeAll(conn, prsts, rs);

}returnlist;

}

}