mybatis（5） ---- mybatis第一个程序，最后测试

项目结构

 

beans包：存放Javabean（实体类）

dao包：存放Dao层，映射文件，服务层即服务层实现类

 

Student.java  源码  :

package com.bjpowernode.beans;

public class Student {
    private Integer id;
    private String name;
    private int age;
    private double score;
    public Student(){
        super();
    }
    public Student(String name, int age, double score){
        super();
        this.name = name;
        this.age = age;
        this.score = score;
    }

    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 int getAge() {
        return age;
    }

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

    public double getScore() {
        return score;
    }


    public void setScore(double score) {
        this.score = score;
    }

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

 

IStudentDao.java   源码

package com.bjpowernode.dao;

import com.bjpowernode.beans.Student;


public interface IStudentDao {
    // 插入数据
    void insertStu(Student student);

}

 

StudentDaoImpl.java   源码：

package com.bjpowernode.dao;

import com.bjpowernode.beans.Student;
import org.apache.ibatis.builder.SqlSourceBuilder;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class StudentDaoImpl implements IStudentDao {

    @Override
    public void insertStu(Student student) {
        try {
            //1.加载主配置文件
            InputStream  inputStream = Resources.getResourceAsStream("mybatis.xml");
            //2.创建SqlSessionFactory对象
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            //3.创建SqlSession对象
            SqlSession sqlSession = sqlSessionFactory.openSession();

            //4.相关操作，"insertStudent" 是命名空间中的唯一标识符，用来查找mapper文件对应的语句。
            sqlSession.insert( "insertStudent", student );

            sqlSession.commit();
        } finally {
            sqlSession.close();
        }
    }

}

 

测试类 MyTest.java

package com.bjpowernode.test;

import com.bjpowernode.beans.Student;
import com.bjpowernode.dao.IStudentDao;
import com.bjpowernode.dao.StudentDaoImpl;
import org.junit.Before;
import org.junit.Test;

public class MyTest {
    IStudentDao dao;

    @Before
    public void before( ){
        dao = new StudentDaoImpl();
    }

    @Test
    public void testInsert(){
        Student student = new Student( "测试" , 23, 99);
        dao.insertStu( student );
    }
}

运行测试类，打开数据库查看测试结果：

 

下一篇：mybatis学习目录