MyBatis教程

步骤：

（1）      导入MyBatis相关jar包，或者maven

<dependency>

  <groupId>org.mybatis</groupId>

  <artifactId>mybatis</artifactId>

  <version>x.x.x</version>

</dependency>

（2）      编写MyBatis核心配置文件mybatis-config.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="development">

                   <environment id="development">

                            <transactionManager type="JDBC" />

                            <dataSource type="POOLED">

                                     <property name="driver" value="com.mysql.jdbc.Driver" />

                                     <property name="url" value="jdbc:mysql://127.0.0.1:3306/test" />

                                     <property name="username" value="root" />

                                     <property name="password" value="root" />

                            </dataSource>

                   </environment>

         </environments>

         <mappers>

                   <mapper resource="com/oiios/entity/UserMapper.xml" />

         </mappers>

</configuration>

（3）      创建SQLSessionFactory对象，以及获得SQLSession对象

public class MyBatisUtil {

         public static SqlSessionFactory getSqlSessionFactory() throws IOException{

                   String resource = "mybatis-config.xml";

                   InputStream inputStream = Resources.getResourceAsStream(resource);

                   SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

                   return sqlSessionFactory;

         }

         public static SqlSession getSqlSession() throws IOException{

                   return getSqlSessionFactory().openSession();

         }

}

（4）      创建实体类

（5）      编写实体类的映射文件，以及sql语句

<?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="com.oiios.entity.UserMapper">

         <select id="selectUser" resultType="com.oiios.entity.User">

                   select * from user where username = #{username}

         </select>

</mapper>

（6）      测试

public class Test {

         public static void main(String[] args) throws IOException {

                   SqlSession session = MyBatisUtil.getSqlSession();

                   User user = session.selectOne("com.oiios.entity.UserMapper.selectUser", "yy");

                   System.out.println(user);

         }

}