mybatis复习1-入门案例注解版

mybatis入门案例注解版：

目录结构：

按思维顺序编写：

1、pojo实体类Bookborrow.java`

package com.shuai.pojo;

public class Bookborrow {
    String stuName;
    Integer bookId;

    public String getStuName() {
        return stuName;
    }

    public void setStuName(String stuName) {
        this.stuName = stuName;
    }

    public Integer getBookId() {
        return bookId;
    }

    public void setBookId(Integer bookId) {
        this.bookId = bookId;
    }

    @Override
    public String toString() {
        return "bookborrow{" +
                "stuName='" + stuName + '\'' +
                ", bookId=" + bookId +
                '}';
    }
}

2、DAO层被代理接口bookborrow （这里添加注解）

package com.shuai.dao;

import com.shuai.pojo.Bookborrow;

import java.util.List;

public interface IBookborrow {
	@Select("select * from bookborrow")
    List<Bookborrow>  getAllBookborrow();

}

3、Mybatis核心配置文件：负责配置数据库相关信息，绑定映射的那些xml文件（注意，这里mapper中用class属性指定接口）

<?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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?
                                          useSSL=true$amp;useUnicode=true$amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper class="com.shuai.dao.IBookborrow"/>
    </mappers>
</configuration>

5、编写测试类

import com.shuai.dao.IBookborrow;

import com.shuai.pojo.Bookborrow;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class Demo {
    public static void main(String[] args) throws IOException {

        //1读取mybatis配置文件
       InputStream in =  Resources.getResourceAsStream("MapperConfig.xml");
        //2创建sqlsessionFactory工厂
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

        SqlSessionFactory build = builder.build(in);
        //3生产sqlsession对象
        SqlSession sqlSession = build.openSession();
        //4得到DAO接口的代理对象
        IBookborrow mapper = sqlSession.getMapper(IBookborrow.class);
        List<Bookborrow> allBookborrow = mapper.getAllBookborrow();
        for(Bookborrow bk : allBookborrow){
            System.out.println(bk);
        }
		//5、释放资源
        sqlSession.close();
        in.close();
    }
}

特别记忆节点：

1、mybatis核心配置文件中mapper标签，用class指定包含注解的接口
3、Resources.getResourceAsStream(）方法需要添加依赖

<dependency>
            <groupId>javax.annotation</groupId>
            <artifactId>javax.annotation-api</artifactId>
            <version>1.3.1</version>
 </dependency>