Mybatis搭建框架

1.在数据库中创建数据

CREATE TABLE `t_person`(
    `id` int(32) NOT NULL AUTO_INCREMENT,
    `name` varchar(32) DEFAULT NULL,
    `nickname` varchar(32) DEFAULT NULL,
    `age` int(32) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO `t_person`     VALUES ('1','zs','zz','3');
INSERT INTO `t_person` VALUES ('2','lisi','ll','4');
INSERT INTO `t_person` VALUES('3','wangwu','ww','5');
视图如下：

2.创建实体类
简单代码如下：
 

public class PersonMapper {
    private Integer id;
    private String name;
    private String nickname;
    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 getNickname() {
        return nickname;
    }

    public void setNickname(String nickname) {
        this.nickname = nickname;
    }

    public Integer getAge() {
        return age;
    }

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

 3.创建接口制定方法

public interface PersonMapper {
    public Integer findCount();
}

4.由于我们使用的是maven所以在pom.xml中导包

<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.1</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.36</version>
    </dependency>

（如果使用的是java-web,则下载包后，导包通过如下添加)

 5.创建连接数据库的xml文件：mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
        "http://ibatis.apache.org/dtd/ibatis-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/db_mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

6.创建可以对接接口类，后对数据库进行操作的xml文件：PersonMapper.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.kgc.mapper.PersonMapper">
    <select id="findCount" resultType="java.lang.Integer">
        select count(*) from t_person
    </select>
</mapper>

7.创建测试类

public class TestMybatis {
    @Test
    public void testHelloWorld() throws IOException {
        //1.定义配置文件
        String config="mybatis-config.xml";
        //2.读取配置文件
        InputStream in= Resources.getResourceAsStream(config);
        //3.创建SqlSessionFactionBuilder对象
        SqlSessionFactoryBuilder builder =new SqlSessionFactoryBuilder();
        //4.创建SqlSessionFactory对象
        SqlSessionFactory factory=builder.build(in);
        //5.获取sqlSession对象
        SqlSession sqlSession = factory.openSession();
        //6.执行sql语句
        Integer count=sqlSession.getMapper(PersonMapper.class).findCount();
        System.out.println("count:"+count);
        //7.关闭sqlSession对象
        sqlSession.close();
    }
}

注意：各个类的位置如下

 各类型的包设置途径如下