Mybatis学习笔记-入门案例

Mybatis学习笔记-入门案例

---

Step1：导入jar包
mybatis-3.1.1.jar—-核心包
asm-3.3.1.jar
cglib-2.2.2.jar
commons-logging-1.1.1.jar
log4j-1.2.16.jar
slf4j-api-1.6.2.jar
slf4j-log4j12-1.6.2.jar
mysql-connector.jar

Step2：引入mybatis核心配置文件sqlMapperConfig.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="mysql_environment">
        <environment id="mysql_environment">
        <!--制定事务管理器-->
        <transactionManager type="JDBC" />
            <dataSource type="POOLED"> 
<!--配置数据库信息-->
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/test" />
<property name="username" value="zhangdd" /><property name="password" value="zd1991.." />
            </dataSource>
        </environment>
    </environments> 
    <mappers>
     <mapper resource = "com/mybatis/test/entity/PetMapper.xml"/>
    </mappers>
</configuration>

Step3：创建数据库表（略）
Step4：创建实体类

package com.mybatis.test.entity;
import java.io.Serializable;
//@Alias("Pet")
public class Pet implements Serializable{

    private String name;
    private String species;
    private String sex;

    public Pet(){}

    public Pet(String name, String species, String sex){
        this.name = name;
        this.species = species;
        this.sex = sex;
    //System.out.println("Over Load Constructor Is Invoked.");
    }

    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getSpecies() {
        return species;
    }
    public void setSpecies(String species) {
        this.species = species;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    @Override
    public String toString() {
        return "Pet [name=" + name + ", species=" + species + ", sex=" + sex+ "]";
    }
}

Step5：引入sql映射PetMapper.xml（ClassNameMapper.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">
<!--
namespace：为该映射制定唯一名称空间，调用sql时sql语句唯一标识符的以部门-->
<mapper namespace="com.mybatis.test.entity.Pet">
     <!--自定义sql代码段，方便sql语句的书写及维护-->
     <sql id="column">
       name,species,sex
    </sql>
    <!-- 主键自增 -->
    <insert id="insertOneIdAutoIncrement" 
         parameterType = "Pet" useGeneratedKeys = "true" 
                keyProperty="id">
         insert into pet_temp 
             (<include refid="column"/>) 
         values 
             (#{name},#{species},#{sex})
    </insert>
    <!--删除-->
    <delete id="deleteItem" parameterType="string">
         delete from pet where name = #{name}
    </delete>
    <!--修改-->
     <update id="updateItem" parameterType="string">
         update pet set owner = #{owner} where name = 'Lucy'
    </update>
 <!--查询-->
 <select id="selectMap" resultType="com.mybatis.test.entity.Pet">
        select <include refid="column"/>
        from pet
 </select>

Step6：测试

package com.mybatis.test;
import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import com.mybatis.test.entity.Department;
import com.mybatis.test.entity.Employee;
import com.mybatis.test.entity.Pet;
import com.mybatis.test.entity.PetMapper;

public class MyBatisTest {


    private SqlSessionFactory sessionFactory;
    private SqlSession session;

    @Before
    public void inti(){
        try {
        //加载核心配置文件
               InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
       //构建工厂实例
       sessionFactory = new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

   /**
     * delete one item.
     * */
    @Test
    public void deleteOneItem(){
        session = sessionFactory.openSession();
        session.delete("com.mybatis.test.entity.Pet.deleteItem", "fang");
        session.commit();
        session.close();
    }
    /**
     * update one item.
     * */
    @Test
    public void updateOneItem(){
        session = sessionFactory.openSession();
        session.update("com.mybatis.test.entity.Pet.updateItem", "zhangsan");
        session.commit();
        session.close();
    }
        /**
     * select map
     * */
    @Test
    public void seletMap(){
        session = sessionFactory.openSession();
        Map<String,Pet> result = session.selectMap("com.mybatis.test.entity.Pet.selectMap", "name");
        System.out.println(result);
        session.close();
    }
    /**
     * insert one : bean
     * */
    @Test
    public void insertOneBean(){
        session = sessionFactory.openSession();
        Pet pet = new Pet("Lucy","dog","m");
        int result = session.insert("com.mybatis.test.entity.Pet.insertOneColumn", pet);
        System.out.println(result);
        session.commit();
        session.close();
    }

在书写sql配置文件及调用Mybatis API实现与数据库的交互时，统一效果可能有多重写法，mybatis提供丰富的参数类型支持及结果集配置，在后续小节注意示例。