- public class BaseDao {
- protected Connection conn;
- protected PreparedStatement ps;
- protected ResultSet rs;
- //建立连接
- public boolean getConnection(){
- String driver=ConfigManager.getInstance().getString("jdbc.driver_class");
- String url=ConfigManager.getInstance().getString("jdbc.connection.url");
- String username=ConfigManager.getInstance().getString("jdbc.connection.username");
- String password=ConfigManager.getInstance().getString("jdbc.connection.password");
- try {
- Class.forName(driver);
- conn=DriverManager.getConnection(url,username, password);
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- return false;
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- return true;
- }
- //增加,修改,删除
- public int executeUpdate(String sql, Object[] params){
- getConnection();
- intupdateRow=0;
- try {
- ps=conn.prepareStatement(sql);
- //填充占位符
- for(inti=0;i){
- ps.setObject(i+1, params[i]);
- }
- updateRow = ps.executeUpdate();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return updateRow;
- }
- //查询
- public ResultSet executeSQL(String sql, Object[] params){
- getConnection();
- try {
- ps=conn.prepareStatement(sql);
- //填充占位符
- for(inti=0;i){
- ps.setObject(i+1, params[i]);
- }
- rs = ps.executeQuery();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return rs;
- }
- // 关闭资源
- public boolean closeResource() {
- if(rs!=null){
- try {
- rs.close();
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- }
- if(ps!=null){
- try {
- ps.close();
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- }
- if(conn!=null){
- try {
- conn.close();
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- }
- return true;
- }
- }
来源: