package bdqn.newsMange.Dao;/*** 公共类* @author Administrator**/import java.sql.*;import java.util.List;public class BaseDao {Connection conn=null;PreparedStatement ps=null;ResultSet rs=null;public Connection getConnection() throws ClassNotFoundException, SQLException{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");if(conn==null){conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databasename=newsDB;User=sa;Password=171268");}return conn;}//增删改public int executeUpdate(String sql, List<Object> prams)throws ClassNotFoundException, SQLException {int rel = -1;conn = getConnection();/*if(conn.isClosed()){conn=null;conn = getConnection();}*/ps = conn.prepareStatement(sql);if (prams != null) {for (int i = 0; i < prams.size(); i++) {ps.setObject(i + 1, prams.get(i));}}rel = ps.executeUpdate();return rel;}//查询public ResultSet executeQurey(String sql,List<Object>prams) throws ClassNotFoundException, SQLException{conn=getConnection();ps=conn.prepareStatement(sql);if(prams!=null){for (int i = 0; i < prams.size(); i++) {ps.setObject(i+1, prams.get(i));}}rs=ps.executeQuery();return rs;}//关闭资源public void closeAll(){if(rs!=null){try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(ps!=null){try {ps.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if(conn!=null){try {conn.close();conn=null;} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}
