一、怎么使用mybatis

1.导入jar包
2.编写连接数据库的xml配置文件

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3.   PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.   "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6.   <environments default="development">
  7.     <environment id="development">
  8.       <transactionManager type="JDBC"/>
  9.       <dataSource type="POOLED">
  10.         <property name="driver" value="${driver}"/>
  11.         <property name="url" value="${url}"/>
  12.         <property name="username" value="${username}"/>
  13.         <property name="password" value="${password}"/>
  14.       </dataSource>
  15.     </environment>
  16.   </environments>
  17.   <mappers>
  18.     <mapper resource="org/mybatis/example/BlogMapper.xml"/>
  19.   </mappers>
  20. </configuration>

3.编写连接xml的配件文件
XML映射代码块

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.   PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.   "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="org.mybatis.example.BlogMapper">
  6.   <select id="selectBlog" parameterType="int" resultType="Blog">
  7.     select * from Blog where id = #{id}
  8.   </select>
  9. </mapper>