mybatis 基本入门

2.1MyBatis框架简介
（1）MyBatis框架就是对JDBC的封装.主要目的简化JDBC开发流程,实现事务松耦合管理,将实体类与SQL命令进行动态对应.
（2）起源于Apache的Ibatis项目,2010年迁移到Google.被正式命名为MyBatis.最后在2013年迁移到Github
（3）MyBatis框架使用简单,同时由于提供了中文官方文档,一般在一天左右即可以掌握.
2.2MyBatis下载
MyBatis的官网： https://github.com/mybatis/mybatis-3

第3章MyBatis开发流程
3.1添加MyBatis依赖jar

3.2开发一个实体映射类

3.3开发一个SQL映射文件
在src/main/resource下创建与当前表对应的SQL映射文件用于声明SQL语句

3.4开发MyBatis核心配置文件
在src/main/resources下创建MyBatis-config.xml作为核心配置文件

3.5开发MyBatis基本调用流程

pom文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.kaikeba</groupId>
  <artifactId>01_MyBatis</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  
   
  <dependencies>
            <dependency>
	  <groupId>org.mybatis</groupId>
	  <artifactId>mybatis</artifactId>
	  <version>3.4.6</version>
    </dependency>    
	<dependency>
	    <groupId>mysql</groupId>
	    <artifactId>mysql-connector-java</artifactId>
	    <version>5.1.38</version>
	</dependency>
    <dependency>
	    <groupId>junit</groupId>
	    <artifactId>junit</artifactId>
	    <version>4.12</version>
	    <scope>test</scope>
    </dependency>

     <dependency>
	    <groupId>log4j</groupId>
	    <artifactId>log4j</artifactId>
	    <version>1.2.17</version>
    </dependency>
  
  
  
  
  </dependencies>
</project>

log4j

##define an appender named console
log4j.appender.console=org.apache.log4j.ConsoleAppender
#The Target value is System.out or System.err
log4j.appender.console.Target=System.out
#set the layout type of the apperder
log4j.appender.console.layout=org.apache.log4j.PatternLayout
#set the layout format pattern
log4j.appender.console.layout.ConversionPattern=[%-5p] %m%n

##define a logger
log4j.rootLogger=debug,console


config.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=***

myBatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<environment id="development">
  <transactionManager type="JDBC"/>
  <dataSource type="POOLED">
    <property name="driver" value="${jdbc.driver}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
  </dataSource>
</environment>

<environment id="development2">
  <transactionManager type="JDBC"/>
  <dataSource type="POOLED">
    <property name="driver" value="${jdbc.driver}"/>
    <property name="url" value="jdbc:mysql://localhost:3306/test"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
  </dataSource>
</environment>

DeptMapper.xml

<?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.kaikeba.dao.DeptMapper">
 
 <insert id="saveDept">
        insert into dept(deptno,dname,loc)
        values(#{deptNo},#{dname},#{loc})
 </insert>
 
 <select id="deptFindById" resultType="Dept">
        select * from dept where deptno=#{deptno}
 </select>
   
   
</mapper>

DeptMapper

package com.kaikeba.dao;

import com.kaikeba.beans.Dept;

public interface DeptMapper {
   public Dept deptFindById(Integer deptno);
}