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;
}
}