刚刚，改造了下BaseDao……

Bertha 。 2022-12-25 02:49 129阅读 0赞

![format_png][]

![format_png 1][]

今天在上课的时候，带着学生们写底层的jdbc连接数据库并且对数据表进行增删改查，写的那就一个痛苦啊……

从创建实体类到写Dao层代码再到表现层的Jsp页面，    写了好久好久……

终于写完了！！！

其实吧，主要还是DaoImpl层的代码写的太多，代码过于臃肿，反而BaseDao这个“工具类”却写的一点点。

于是，这不刚刚就把这个BaseDao改进了一下，将凡是公共可以共用的代码都提到了BaseDao中，DaoImpl层光写所需要实现的sql语句和对应的参数即可，剩下的任务由BaseDao去执行。

下面是BaseDao的代码：

package org.dao;
    
    import java.sql.*;
    import java.util.List;
    
    import com.sun.org.glassfish.external.statistics.annotations.Reset;
    
    
    /**
     * 
     * @author 24519
     * 连接数据库的工作类
     *
     */
    public class BaseDaoNew {
      
      private Connection conn = null;
      private PreparedStatement pre;
      private ResultSet rs;
      //连接数据库
      public Connection getConn(){
        try{
          //加载驱动
          Class.forName("com.mysql.jdbc.Driver");
          //数据库连接字符串
          String url
           = "jdbc:mysql://localhost:3306/schooldb?user=root&password=root";
          //连接数据库
          conn = DriverManager.getConnection(url);
        }catch(Exception ex){
          ex.printStackTrace();
        }
        return conn;
      }
      
      //增删改
      public int ExecuteUpdate(String sql,List params) throws SQLException{
        int rel = 0;
        conn = getConn();
          pre = conn.prepareStatement(sql);
          if(params!=null){
            for(int i = 0;i<params.size();i++){
              pre.setObject(i+1, params.get(i));
            }
          }
          rel = pre.executeUpdate();
        
        return rel;
      }
      
      //查询
      public ResultSet ExecuteQuerty(String sql,List params) throws SQLException{
        conn = getConn();
        pre = conn.prepareStatement(sql);
        if(params!=null){
          for(int i = 0;i<params.size();i++){
            pre.setObject(i+1, params.get(i));
          }
        }
        
        return pre.executeQuery();
        
      }
      
        
        
      
      
      //关闭连接
      public void closeConn(Connection conn,
              PreparedStatement pre,ResultSet rs){
          try {
            if(rs!=null){
              rs.close();
            }
            if(pre!=null){
              pre.close();
            }
            if(conn!=null){
              conn.close();
            }
          } catch (SQLException e) {
            e.printStackTrace();
        }
        
      }
      
      
    
    }

可以看得出来，我们将连接数据库，增删改、查询以及关闭连接都提取成独立的方法，在Impl层直接调用对应的是方法即可。

@Override
      public Student login(String name, String pass,String info){
        Student student = new Student();
        String sql = "select * from student where sname = ? and spass = ?";
        BaseDaoNew base1 = new BaseDaoNew();
        List<Object> params = new ArrayList<Object>();
        params.add(name);
        params.add(pass);
        try {
          rs = base1.ExecuteQuerty(sql, params);
          while(rs.next()){
            student.setSid(rs.getInt(1));
            student.setSname(rs.getString(2));
            student.setSphone(rs.getString(3));
            student.setSpass(rs.getString(4));
            student.setSaddress(rs.getString(5));
            student.setSage(rs.getInt(6));
          }
        } catch (SQLException e) {
          e.printStackTrace();
        }finally{
          base1.closeConn(conn, pre, rs);
        }
        return student;

[分享几个花拳绣腿的网页布局！][Link 1]

[2020-11-10][Link 1]

[![format_png 2][] ][Link 1]

[常用CSS属性整理][CSS]

[2020-11-09][CSS]

[![format_png 3][] ][CSS]

[jsp的内置对象][jsp]

[2020-11-08][jsp]

[![format_png 4][] ][jsp]

[今天拍了一些照片！][Link 2]

[2020-11-09][Link 2]

[![format_png 5][] ][Link 2]

[我的职校新生活][Link 3]

[2020-11-07][Link 3]

[![format_png 6][] ][Link 3]

[今天，我们来抽个奖！！！！！][Link 4]

[2020-11-06][Link 4]

[![format_png 7][] ][Link 4]

[今天 ,给大家变个魔术!!!][Link 5]

[2020-11-05][Link 5]

[![format_png 8][] ][Link 5]

![format_png 9][]

![format_png 10][]

点分享

![format_png 11][]

点点赞

![format_png 12][]

点在看

[format_png]: /images/20221120/4ef27bddff404cde9aacabd7adf5dd6d.png
[format_png 1]: /images/20221120/03863dffc2a146b9bc951d44588367d1.png
[Link 1]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fedf2a0f864e475dbc6ca1af5e3a0755e4eb1cac559a708079582baa0ff0c9697066a7b40&idx=1&mid=2247497491&scene=21&sn=dab2e0fddfa3f0f5714a8c929896fef4#wechat_redirect
[format_png 2]: /images/20221120/59a7dc6e020b43c088888a5dc955d85d.png
[CSS]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fec19a0f8650ffa085fa28a7af55e1d20bfddf6a898c0ff6a2b1a8561969be8616159f9f7&idx=1&mid=2247497464&scene=21&sn=52cf04169fcb7d7096d77acc692549dd#wechat_redirect
[format_png 3]: /images/20221120/24da0662b10a476c9012b69163c2dfbc.png
[jsp]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fec9da0f8658b588dea733bd93fbbb311e0c671be8953cba62cadf28c99b4d00d54756f36&idx=1&mid=2247497340&scene=21&sn=ee91064ccdf698f5f364385d8fdc7c12#wechat_redirect
[format_png 4]: /images/20221120/959a234d876945df905faed68d6d66e6.png
[Link 2]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fec19a0f8650fa2965fce85737e1871aa3f0e6ad71265704d4e8b535e2a056077a5444f33&idx=2&mid=2247497464&scene=21&sn=18fd395628ffcfa6efb4fa513f7ef27a#wechat_redirect
[format_png 5]: /images/20221120/d714992b95814a78ab6087f136f46535.png
[Link 3]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fec90a0f865867a5811428da83433a8fb2c114db7cd1a647cdb6d0eec29f483a3ce1dff9f&idx=1&mid=2247497329&scene=21&sn=9996b0bf8deb5209abd1cb4fdcb97277#wechat_redirect
[format_png 6]: /images/20221120/e1ae9bb1ebc341edb25c433cad0dd6db.png
[Link 4]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fec8fa0f865991842e4617f61d11b3c693fc4d39ec37f04e67f7c674ff059975a4e69d835&idx=1&mid=2247497326&scene=21&sn=8b9bd3fe757246ffe9b21a94a5c06979#wechat_redirect
[format_png 7]: /images/20221120/175390a8c2044488b32d6a2c997a734b.png
[Link 5]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fecb2a0f865a48ae5b0374872b4392905eed765e7d78af83eb277087cadb692ac1de003d1&idx=1&mid=2247497299&scene=21&sn=86416b68240154881d16cc96fe75f59c#wechat_redirect
[format_png 8]: /images/20221120/f82494b57a6542cb9c5975f91eca8da9.png
[format_png 9]: /images/20221120/3f3e57ab252c4a59b6a195b00be15f73.png
[format_png 10]: /images/20221120/79813075409b4bffb5fb40247c0983a7.png
[format_png 11]: /images/20221120/2d04e81ef7124c868b5c99b826af035a.png
[format_png 12]: /images/20221120/90093ebf94c64864b3e76564aca0fa86.png