Mybatis传统DAO方式进行数据库表的操作

传统DAO方式进行数据库表的操作

用传统DAO方式进行Student表的查询操作

流程代码

1. 新建StudentDaoImpl类,在该类中实现接空中的select(insert,delete,update相同)方法.

   import com.bipt.dao.StudentDao;
   import com.bipt.domain.Student;
   import com.bipt.utiles.MyBatisUtils;
   import org.apache.ibatis.session.SqlSession;
   import java.util.List;
   public class StundentDaoImpl implements StudentDao {
       @Override
       public List<Student> selectStudents() {
           //获取sqlsession对象
           SqlSession sqlSession = MyBatisUtils.getSqlSession();
           String sqlId = "com.bipt.dao.StudentDao.selectStudents";
           //执行sql语句
           List<Student> students = sqlSession.selectList(sqlId);
           //关闭sqlSession对象
           return students;
       }
   }
   

2. 新建TestMyBatis类,进行查询.

   package com.bipt.utiles;
   import com.bipt.dao.impl.StundentDaoImpl;
   import com.bipt.domain.Student;
   import java.util.List;
   public class TestMyBatis {
       public static void main(String[] args) {
           StundentDaoImpl stundentDao = new StundentDaoImpl();
           List<Student> students = stundentDao.selectStudents();
           for (Student stu : students) {
               System.out.println(stu);
           }
       }
   }
   

用传统DAO方式进行Student表的插入操作

1. 在StudentDaoImpl中实现StudentDao接口中的insertStudent(Student student)方法

   package com.bipt.dao.impl;
   import com.bipt.dao.StudentDao;
   import com.bipt.domain.Student;
   import com.bipt.utiles.MyBatisUtils;
   import org.apache.ibatis.session.SqlSession;
   import java.util.List;
   public class StundentDaoImpl implements StudentDao {
       @Override
       public int insertStudent(Student student) {
           //获取sqlSession对象
           SqlSession sqlSession = MyBatisUtils.getSqlSession();
           String sqlId = "com.bipt.dao.StudentDao.insertStudent";
           int unm = sqlSession.insert(sqlId,student);
           //提交事务
           sqlSession.commit();
           //关闭对象
           sqlSession.close();
           return unm;
       }
   }
   

2. 在测试类中编写insert代码

   private static void insertStudent() {
       StundentDaoImpl studentDao = new StundentDaoImpl();
       Student student = new Student();
       student.setId(1004);
       student.setName("刘备");
       student.setAge(14);
       student.setEmail("dunshan@163.com");
       int i = studentDao.insertStudent(student);
       System.out.println("添加了"+i+"条数据");
   }