Hello,Mybatis

MyBatis第一个程序

1. 搭建实验数据库

   CREATE TABLE `user` (  `id` int(20) NOT NULL,  `name` varchar(30) DEFAULT NULL,  `pwd` varchar(30) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   insert  into `user`(`id`,`name`,`pwd`) values (1,'Light','123456'),(2,'张三','abcdef'),(3,'李四','987654');
   

2. 导入MyBatis相关 jar 包

   • GitHub上找

   <!-- Mybatis的依赖-->
   <dependency>   
       <groupId>org.mybatis</groupId>   
       <artifactId>mybatis</artifactId> 
       <version>3.5.2</version>
   </dependency>
   <dependency>   
       <groupId>mysql</groupId> 
       <artifactId>mysql-connector-java</artifactId>
       <version>5.1.47</version>
   </dependency>
   

3. 编写MyBatis核心配置文件

   • 查看帮助文档

   <?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:7788/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=utf8"/>
                   <property name="username" value="root"/>
                   <property name="password" value="root"/>
               </dataSource>
           </environment>
       </environments>
       <mappers> //映射器
           <mapper resource="org/example/mapper/UserMapper.xml"/>
       </mappers>
   
   </configuration>
   

4. 编写MyBatis工具类

   • 查看帮助文档

   package org.example.utils;
   
   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 MybatisUtils {
       private static SqlSessionFactory sqlSessionFactory;
       static {
           String resource = "mybatis-config.xml";
           try {
               InputStream inputStream = Resources.getResourceAsStream(resource);
               sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
           } catch (IOException e) {
               throw new RuntimeException(e);
           }
       }
       public static SqlSession getSession(){
           return sqlSessionFactory.openSession();
       }
   }
   
   

5. 创建实体类

   public class User {   
       private int id;  //id    
       private String name;   //姓名   
       private String pwd;   //密码    
       //构造,有参,无参    //set/get    //toString()
   }
   

6. 编写Mapper接口类

   import java.util.List;
   public interface UserMapper {
       List<User> selectUser();
   }
   

7. 编写Mapper.xml配置文件

   • namespace 十分重要，不能写错！

   <?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="org.example.mapper.UserMapper">
       <select id="selectUser" resultType="org.example.pojo.User">
           select * from user
       </select>
   </mapper>
   

8. 编写测试类

   public class MyTest {
       @Test
       public void selectUser() {
           SqlSession session = MybatisUtils.getSession();
           UserMapper mapper = session.getMapper(UserMapper.class);
           List<User> users = mapper.selectUser();
           for(User user : users){
               System.out.println(user);
           }
           session.close();
       }
   }
   

9. 运行测试