Mybatis实现Dao层的方式

Mybatis实现Dao层的方式

一.原生Dao层的实现

• jdbc工具类的加载

    public static String url=null;
    public static String username=null;
    public static String password=null;
    static{
   
        try {
   
            //读取本地类加载路径下的properties文件
            InputStream is = jdbcUtils.class.getClassLoader().getResourceAsStream("jdbc.properties");
           //读取数据properties集合中
            Properties properties=new Properties();
            properties.load(is);
           	//获取配置数据
             String driverClass = properties.getProperty("driverClass");
             url = properties.getProperty("url");
             username = properties.getProperty("username");
             password = properties.getProperty("password");
            //加载Driver驱动类
             Class.forName(driverClass);
        } catch (Exception e) {
   
            e.printStackTrace();
        }
    }
	//获取Connection连接对象
    public static Connection getConnection() throws SQLException {
   
        return DriverManager.getConnection(url,username,password);
    }

• Student接口

  //查询所有学生
  public abstract ArrayList<Student> findAll();
  

• Student接口实现类

   public ArrayList<Student> findAll() {
       
          try {
       
              //获取连接对象conn
              conn = jdbcUtils.getConnection();
              String sql = "select * from student";
              //编译sql语句
              pstat = conn.prepareStatement(sql);
             执行findAll方法
              rs = pstat.executeQuery