您当前的位置： 首页 > 慢生活 > 程序人生 网站首页程序人生

03-mybatis快速入门-代码实现

发布时间：2025-01-22 21:39:26编辑：雪饮阅读（）

基于org,apache.maven.archetypes:maven-archetype-quickstart骨架建立新的module
建立完成后在pom.xml中配置依赖
<dependencies>
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.32</version>
  </dependency>
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
  </dependency>
  <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
    <scope>test</scope>
  </dependency>
  <dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
  </dependency>
</dependencies>
在src/main下面建立java目录并建立package如sp24.domain
然后在domain下面建立类：
package sp24.domain;

public class User {
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}
然后在src/main下建立resources目录并在resources目录下面建立同上面package相同路径如sp24/mapper
然后在这个mapper目录下面建立如UserMapper.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="userMapper">
    <!--查询操作-->
    <select id="findAll" resultType="sp24.domain.User">
        select * from user
    </select>
</mapper>
然后在resources目录建立如sqlMapConfig.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="developement">
        <environment id="developement">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://192.168.217.132/mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="1448169a3cb137d7"/>
            </dataSource>
        </environment>
    </environments>
   

    <!--加载映射文件-->
    <mappers>
        <mapper resource="sp24/mapper/UserMapper.xml"></mapper>
    </mappers>


</configuration>
然后在src目录下面建立test/java，然后在test/java目录下面也建立像是上面main/java下面的同样的package，如sp24,然后在test/java/sp24中建立测试类：
package sp24;

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 sp24.domain.User;

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

public class MyBatisTest {
    @Test
    public void test1() throws IOException {
        //获取核心配置文件
        InputStream resourceAsStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        //获得session工厂对象
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resourceAsStream);
        //获得session会话对象
        SqlSession sqlSession=sqlSessionFactory.openSession();
        //执行操作 参数：namespace+id
        List<User> userList=sqlSession.selectList("userMapper.findAll");
        //打印数据
        System.out.println(userList);
        //释放资源
        sqlSession.close();
    }
}
然后数据库中创建数据表
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `gender` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `addr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
并插入测试数据
INSERT INTO `user` VALUES (1, 'zhangsan', '123', '男', '北京');
INSERT INTO `user` VALUES (2, '李四', '234', '女', '天津');
INSERT INTO `user` VALUES (3, '王五', '11', '男', '西安');
INSERT INTO `user` VALUES (4, '小五', NULL, NULL, NULL);
INSERT INTO `user` VALUES (5, '1', '2', NULL, NULL);
INSERT INTO `user` VALUES (6, 'admin', '123', NULL, NULL);
INSERT INTO `user` VALUES (7, '不用', 'buyong', NULL, NULL);
INSERT INTO `user` VALUES (8, 'zhangsan2', '22222', NULL, NULL);
INSERT INTO `user` VALUES (9, 'zhangsan222', '2222', NULL, NULL);
INSERT INTO `user` VALUES (10, 'xy220807', '123', NULL, NULL);
INSERT INTO `user` VALUES (11, 'xy22080702', '12234', NULL, NULL);
INSERT INTO `user` VALUES (12, '', '', NULL, NULL);
最后运行这个test1方法进行测试。