Mybatis快速上手

Mybatis快速上手

1.导入mybatis所需要的依赖（这里是3.4.6版本）

一个myabtis依赖

<dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.6</version>
    </dependency>

一个mysql-jdbc依赖

	<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>

2.编写mybatis核心配置文件

先创建一个mybtais核心配置文件，名字叫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>
				    <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"/>
				                <property name="username" value="root"/>
				                <property name="password" value="root"/>
				            </dataSource>
				        </environment>
				    </environments>
				</configuration>

3.建立好自己的实体类、接口、接口映射

1.实体类

代码：

package cn.xinzhi.pojo;

public class User {
    private int id;
    private String name;
    private String pwd;
    private double balance;

    public int getId() {
        return id;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                ", balance=" + balance +
                '}';
    }

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

    public String getName() {
        return name;
    }

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

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    public double getBalance() {
        return balance;
    }

    public void setBalance(double balance) {
        this.balance = balance;
    }
}

2.接口

代码：

package cn.xinzhi.mapper;

import cn.xinzhi.pojo.User;

import java.util.List;

public interface IUser {
    List<User> query();
}

3.接口映射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="cn.xinzhi.mapper.IUser">
    <select id="query" resultType="cn.xinzhi.pojo.User">
        select * from user
    </select>
</mapper>

4.把mapper注册到mybatis核心配置文件中

代码：

 <mappers>
        <mapper resource="IUser.xml"></mapper>
    </mappers>

5.编写测试类测试

import cn.xinzhi.mapper.IUser;
import cn.xinzhi.pojo.User;
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;

public class Mytest {
    public static void main(String[] args) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        SqlSession sqlSession = sqlSessionFactory.openSession();
        IUser mapper = sqlSession.getMapper(IUser.class);


        for (User u:
                mapper.query()) {
            System.out.println(u.toString());
        }

    }
}

输出结果