Mybatis入门

 

官网 http://mybatis.github.io/

下载路径：https://github.com/mybatis/mybatis-3/releases

文档：http://mybatis.github.io/mybatis-3/zh/getting-started.html

http://www.mybatis.org/mybatis-3/zh/

 

1.加入依赖

<dependency>  <groupId>org.mybatis</groupId>  <artifactId>mybatis</artifactId>  <version>3.2.8</version></dependency>

 

2.mybatis的配置

数据库配置:url=jdbc:oracle:thin:@localhost:1521:orcldriverClass=oracle.jdbc.OracleDriveruserName=mybatispassword=123456  <?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><!--  是mybaitis的核心配置文件1.数据库的链接信息(连接池) --><properties resource="cn/et/lesson01/jdbcoracle.properties"></properties>  <environments default="development">    <environment id="development">    <!-- 事务管理器默契使用jdbc事务 -->      <transactionManager type="JDBC"/>      <dataSource type="POOLED">        <property name="driver" value="${driverClass}"/>        <property name="url" value="${url}"/>        <property name="username" value="${userName}"/>        <property name="password" value="${password}"/>      </dataSource>    </environment>  </environments>  <mappers>  <mapper resource="cn/et/lesson01/foodmap.xml"/>  </mappers></configuration>

3.从 XML 中构建 SqlSessionFactory

String resource = "org/mybatis/example/mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

 

 

4.映射的 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="org.mybatis.example.BlogMapper">  <select id="selectBlog" resultType="a">    select * from Blog where id = #{id}  </select></mapper>