Mybatis-传统dao

---

:::tip

说明：本章内容是博主的Java学习笔记，

:::

1.创建bean类

package com.wqm.domain;

public class Student {

    private Integer id;
    private String name;
    private String email;
    private Integer age;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", email='" + email + '\'' +
                ", age=" + age +
                '}';
    }
}

2.创建StudentDao接口

package com.wqm.dao;

import com.wqm.domain.Student;

import java.util.List;

public interface StudentDao {

    List<Student> selectStudent();

    int insertStudent(Student student);



}

3.创建StudentDao.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wqm.domain.Student">

    <select id="selectStudent" resultType="com.wqm.domain.Student">
      select id,name,email,age from student order by id
    </select>

    <insert id="insertStudent">
        insert into  student values (#{id},#{name},#{email},#{age});
    </insert>



</mapper>

4.创建Dao接口的实现类

package com.wqm.dao.impl;

import com.wqm.dao.StudentDao;
import com.wqm.domain.Student;
import com.wqm.util.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;

import java.util.List;

public class StudentDaoImpl implements StudentDao {
    @Override
    public List<Student> selectStudent() {
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        String sqlID = "com.wqm.domain.Student.selectStudent";
        //执行sql语句
        List<Student> students =  sqlSession.selectList(sqlID);

        for(Student stu:students){
            System.out.println(stu);
        }

        //关闭
        sqlSession.close();

        return students;



    }

    @Override
    public int insertStudent(Student student) {
        SqlSession sqlSession = MyBatisUtils.getSqlSession();
        String sqlID = "com.wqm.domain.Student.insertStudent";
        //执行sql语句
        int nums = sqlSession.insert(sqlID,student);
        //提交事务
        sqlSession.commit();
        //关闭
        sqlSession.close();

        return nums;
    }
}

5.测试类

public class App 
{
    public static void main( String[] args )
    {

        StudentDao dao = new StudentDaoImpl();
        List<Student> students = dao.selectStudent();

        for(Student student : students){
            System.out.println(student);
        }



    }
}

6.运行结果