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 }