MyBatis入门经典教程

MyBatis入门经典教程

创建一个新的maven项目工程

导入所需maven坐标

创建实体类和对用的DAO接口

在Resourc文件夹下创建与DAO对应的映射文件

创建MyBatis配置文件，并添加文档约束

 

测试效果

---

 

1. 创建一个新的maven项目工程

2. 导入所需maven坐标
    

          <dependency>
              <groupId>org.mybatis</groupId>
              <artifactId>mybatis</artifactId>
              <version>3.4.5</version>
          </dependency>
          <dependency>
              <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
              <version>8.0.20</version>
          </dependency>
          <dependency>
              <groupId>log4j</groupId>
              <artifactId>log4j</artifactId>
              <version>1.2.12</version>
          </dependency>

    

3. 创建实体类和对用的DAO接口

4. 在Resourc文件夹下创建与DAO对应的映射文件

5. 创建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">

   <?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>
       <typeAliases>
           <package name="com.uxteam.domain"/>
       </typeAliases>
       <environments default="mysql">
           <environment id="mysql">
               <transactionManager type="JDBC"/>
               <dataSource type="POOLED">
                   <property name="driver" value="com.mysql.jdbc.Driver"/>
                   <property name="url" value="jdbc:mysql://192.168.38.201:3306/DBMyBatis"/>
                   <property name="username" value="root"/>
                   <property name="password" value="***"/>
               </dataSource>
           </environment>
       </environments>
       <mappers>
           <mapper resource="com/uxteam/dao/IUserDao.xml"/>
       </mappers>
   </configuration>

    

6. 测试效果
    

    InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
           SqlSessionFactoryBuilder sbuilder = new SqlSessionFactoryBuilder();
           SqlSessionFactory factory = sbuilder.build(inputStream);
           SqlSession session = factory.openSession();
           IUserDao dao = session.getMapper(IUserDao.class);