Mybatis之接口式编程

Mybatis之接口式编程

1.创建学生数据库和表

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 

2.创建Java项目,导入Mybatis、MySQL以及与日志相关的jar包

log4j.properties文件

log4j.rootLogger=INFO, file, stdout

# write to stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS}  %5p --- [%50t]  %-80c(line:%5L)  :  %m%n

database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/student
jdbc.username=root
jdbc.password=123

3.编写与数据库对应的Javabean

package com.ldx.mybatis.bean;

import java.io.Serializable;

public class Student implements Serializable {

    public Integer id;
    public String lastname;
    public Integer age;
    public Student() {
    }

    public Student(Integer id, String lastname, Integer age) {
        this.id = id;
        this.lastname = lastname;
        this.age = age;
    }

    public Integer getId() {
        return id;
    }

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


    public Integer getAge() {
        return age;
    }

    public String getLastname() {
        return lastname;
    }

    public void setLastname(String lastname) {
        this.lastname = lastname;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", lastname='" + lastname + '\'' +
                ", age=" + age +
                '}';
    }



}

4.编写与Javabean对应的mapper映射文件
StudentMapper.xml
增删改查分别对应insert、delete、update、select
注：namespace的值要与对应的接口类路径一致
SQL语句对应的标签id值要与接口类中的方法名一致

<?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.ldx.mybatis.mapper.StudentMapper">
    <select id="getStudentById" resultType="student">
 select * from Student where id = #{id}
 </select>
    <select id="getAllStudent" resultType="student">
 select id,`name` lastname,age from Student
 </select>
    <!--useGeneratedKeys获取自动生成的主键 -->
    <insert id="insertStudent" parameterType="student" useGeneratedKeys="true" keyProperty="id">

        INSERT  INTO student VALUES (#{id},#{lastname},#{age})
    </insert>

    <update id="updateStudent" parameterType="student">
        UPDATE student SET
        `name`= #{lastname},
        age = #{age}
        WHERE id = #{id}
    </update>

    <delete id="deleteStudent">

        DELETE  FROM  student WHERE  id = #{id}
    </delete>
</mapper>

5.编写Mybatis核心配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="conf/database.properties">

    </properties>

    <typeAliases>

        <typeAlias type="com.ldx.mybatis.bean.Student" alias="student"></typeAlias>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="com\ldx\mybatis\mapper\StudentMapper.xml"/>
    </mappers>
</configuration>

6.编写测试程序
注：SQLSessionFactory对象不是线程安全的，因此不能设置为类成员属性，且每次都要重新获取，每次用完都要close（）掉；SQLSessionFactory的无参构造方法openSession，对数据库的如何修改增加删除等行为都不会自动提交到数据库，因此执行完相关的SQL语句要手动commit,查询操作则无影响，或者可以才有有参的方法设置自动提交

package com.ldx.mybatis.test;

import com.ldx.mybatis.bean.Student;
import com.ldx.mybatis.mapper.StudentMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class Test1 {
    public SqlSession getSqlSession()  {
        String resource="conf/mybatis-config.xml";
        InputStream inputStream= null;
        try {
            inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            return sqlSessionFactory.openSession();
        } catch (IOException e) {
        e.printStackTrace();
    }
        return null;
    }

    @Test
    public void select(){
        SqlSession sqlSession=getSqlSession();
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
        Student student = studentMapper.getStudentById(1);
        System.out.println(student.toString());
        sqlSession.close();
    }
    @Test
    public void selectAll(){
        SqlSession sqlSession = getSqlSession();
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
        List<Student> allStudent = studentMapper.getAllStudent();
        for(int i=0;i<allStudent.size();i++){
            System.out.println(allStudent.get(i).toString());
        }
        sqlSession.close();

    }
    @Test
    public void insert(){
        SqlSession sqlSession = getSqlSession();
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
        Student student=new Student(null, "ldx", 24);
        int insertResult = studentMapper.insertStudent(student);
        if(insertResult==1){
            sqlSession.commit();
            System.out.println("add success,the id of the new student is "+student.getId());
        }else{
            System.out.println("add fail");
        }
        
        sqlSession.close();
    }
    @Test
    public void update(){
        SqlSession sqlSession = getSqlSession();
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
        Student student = new Student(1,"lidexi1",25);
        int i = studentMapper.updateStudent(student);
        if(i==1){
            sqlSession.commit();
            System.out.println("update success");
        }else{
            System.out.println("update fail");
        }
        sqlSession.close();
    }

    @Test
    public void delete(){
        SqlSession sqlSession = getSqlSession();
        StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
        int i = studentMapper.deleteStudent(23);
        if(i==1){
            System.out.println("delete success");
            sqlSession.commit();
        }else{
            System.out.println("delete fail");
        }
        sqlSession.close();
    }
}