mybatis(一)第一个mybatis入门程序用例

• 目录
  

mybatis（一）

1、第一个mybatis 程序用例

---

1.1、官方文档地址

https://mybatis.org/mybatis-3/zh/getting-started.html

1.2、maven导入

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.13.1</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.22</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.6</version>
    </dependency>
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.18</version>
    </dependency>
</dependencies>

1.3、编写第一个mybatis入门测试类

• mysql新建测试用表并插入数据

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `pwd` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `user` VALUES (1, 'user1', 'pwd1');
INSERT INTO `user` VALUES (2, 'user2', 'pwd2');
INSERT INTO `user` VALUES (3, 'user3', 'pwd3');
COMMIT;

• 新建User类，对应user表字段

package com.szm.pojo;
import lombok.Data;
/**
 * TODO
 *
 * @author suzhengmin
 * @data 2021/9/29 3:48 下午
 */
@Data
public class User {
    private int id;
    private String name;
    private String pwd;
}

• 编写操作mapper接口：

package com.szm.mapper;

import com.szm.pojo.User;

import java.util.List;

/**
 * TODO
 * @author suzhengmin
 * @data 2021/9/29 5:54 下午
 */
public interface UserMapper {

    List<User> selectUsers();

}

• 在项目resource路径下新建核心配置文件mybatis.xml、配置数据库以及mapper映射文件：

<?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.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&amp;useJDBCCompliantTimezoneShift=true&amp;useLegacyDatetimeCode=false&amp;serverTimezone=Asia/Shanghai&amp;rewriteBatchedStatements=true"/>
                <property name="username" value="root"/>
                <property name="password" value="Test#123345"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mybatis-mapper/UserMapper.xml"/>
    </mappers>
</configuration>

• 新建映射文件UserMapper.xml,其中namespace指向UserMapper接口路径：

<?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">
<!--namespace绑定dao层接口位置-->
<mapper namespace="com.szm.mapper.UserMapper">
    <select id="selectUser" resultType="com.szm.pojo.User">
    select * from user
  </select>
</mapper>

• 编写测试类

@Test
public void test() throws IOException {
  String resources = "mybatis-config.xml";
  InputStream in = Resources.getResourceAsStream(resources);
  SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);
  SqlSession sqlSession = sqlSessionFactory.openSession(true);
  UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  List<User> users = mapper.selectUser(1);
  users.stream().forEach((e) -> {
    System.out.println(e.toString());
  });
  sqlSession.close();
}

• 运行结果

/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/bin/java -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=57282:/Applications/IntelliJ IDEA.app/Contents/bin -Dfile.encoding=UTF-8 -classpath /Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar:/Applications/IntelliJ IDEA.app/Contents/plugins/junit/lib/junit5-rt.jar:/Applications/IntelliJ IDEA.app/Contents/plugins/junit/lib/junit-rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/ant-javafx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/javafx-mx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/packager.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/sa-jdi.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_191.jdk/Contents/Home/lib/tools.jar:/Users/suzhengmin/ideaProject/MystudyProject/mybatis/mybatis-01/target/test-classes:/Users/suzhengmin/ideaProject/MystudyProject/mybatis/mybatis-01/target/classes:/Users/suzhengmin/maven/local/junit/junit/4.13.1/junit-4.13.1.jar:/Users/suzhengmin/maven/local/org/hamcrest/hamcrest-core/1.3/hamcrest-core-1.3.jar:/Users/suzhengmin/maven/local/mysql/mysql-connector-java/8.0.22/mysql-connector-java-8.0.22.jar:/Users/suzhengmin/maven/local/com/google/protobuf/protobuf-java/3.11.4/protobuf-java-3.11.4.jar:/Users/suzhengmin/maven/local/org/mybatis/mybatis/3.5.6/mybatis-3.5.6.jar:/Users/suzhengmin/maven/local/org/projectlombok/lombok/1.18.18/lombok-1.18.18.jar com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 Test1,test
User(id=1, name=user1, pwd=pwd1)
User(id=2, name=user2, pwd=pwd2)
User(id=3, name=user3, pwd=pwd3)

Process finished with exit code 0