Mybatis实现sql执行的第一种方式,写接口的实现类

 1 package com.bjpowernode.dao.impl;
 2 
 3 import com.bjpowernode.dao.StudentDao;
 4 import com.bjpowernode.domain.Student;
 5 import com.bjpowernode.utils.MybatisUtils;
 6 import org.apache.ibatis.session.SqlSession;
 7 
 8 import java.util.List;
 9 
10 public class StudentDaoImpl implements StudentDao {
11 
12     @Override
13     public List<Student> selectStudents() {
14         String sqlId = "com.bjpowernode.dao.StudentDao.selectStudents";
15         SqlSession sqlSession = MybatisUtils.getSqlSession();
16         List<Student> list = sqlSession.selectList(sqlId);
17         return list;
18     }
19 
20     @Override
21     public int insertStudent(Student student) {
22         String sqlId = "com.bjpowernode.dao.StudentDao.insertStudent";
23         SqlSession sqlSession = MybatisUtils.getSqlSession();
24         int num = sqlSession.insert(sqlId,student);
25         sqlSession.commit();
26         return num;
27     }
28 
29     public static void main(String[] args) {
30         StudentDaoImpl dao = new StudentDaoImpl();
31 /*        List<Student> list = dao.selectStudents();
32         for(Student stu:list){
33             System.out.println("查询出的学生信息:"+stu);
34         }*/
35         Student student = new Student();
36         student.setAge(20);
37         student.setEmail("ww@qq.com");
38         student.setId(1004);
39         student.setName("王五");
40         int num = dao.insertStudent(student);
41         System.out.println("执行了"+num+"行数据的插入操作");
42     }
43 }

 

posted @ 2021-02-21 20:58  渐行、渐远  阅读(196)  评论(0)    收藏  举报