首页 > 代码库 > java深入探究16-mybatis

java深入探究16-mybatis

链接:http://pan.baidu.com/s/1skJ4TNB 密码:koo9

1.引入mybatis

  jsbc简单易学,上手快,非常灵活构建SQL,效率高但代码繁琐,难以写出高质量的代码

  hibernate不用写SQL,完全以面向对象的方式设计和访问但处理复杂业务时,灵活度差

  所以中间产物:mybatis就应运而生

2.mybatis说法和特定

  1)MyBatis 本是apache的一个开源项目iBatis, 2010年这个项目由apache software foundation 迁移到了google code,并且改名为MyBatis 201311月迁移到Github

  2iBATIS一词来源于“internet”“abatis”的组合,是一个基于Java的持久层框架。iBATIS提供的持久层框架包括SQL MapsData Access ObjectsDAO

  3jdbc/dbutils/springdaohibernate/springormmybaits同属于ORM解决方案之一

3.mybatis快速入门

  1)导入jar包(5个核心包+2个数据库访问包):asm-3.3.1.jar;cglib-2.2.2.jar;commons-logging-1.1.1.jar;log4j-1.2.16.jar;mybatis-3.1.1.jar;mysql-connector-java-5.1.7-bin.jar;ojdbc5.jar

  2)创建sql:

 

技术分享
--mysql语法
create table students(
   id  int(5) primary key,
   name varchar(10),
   sal double(8,2)
);
--oracle语法
create table students(
   id  number(5) primary key,
   name varchar2(10),
   sal number(8,2)
);
View Code

 

 创建Student.java

技术分享
/**
 * 学生
 * @author AdminTC
 */
public class Student {
    private Integer id;
    private String name;
    private Double sal;
    public Student(){}
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Double getSal() {
        return sal;
    }
    public void setSal(Double sal) {
        this.sal = sal;
    }
}
View Code

  3)配置映射文件StudentMapper.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="mynamespace">
    <insert id="add1">
        insert into students(id,name,sal) values(1,哈哈,7000)
    </insert>
    <insert id="add2" parameterType="cn.itcast.javaee.mybatis.app05.Student">
        insert into students(id,name,sal) values(#{id},#{name},#{sal})
    </insert>
</mapper>
View Code

 

  4)配置mybatis.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=http://www.mamicode.com/"com.mysql.jdbc.Driver"/>    
                <property name="url" value=http://www.mamicode.com/"jdbc:mysql://127.0.0.1:3306/mybatis"/>    
                <property name="username" value=http://www.mamicode.com/"root"/>    
                <property name="password" value=http://www.mamicode.com/"root"/>    
            </dataSource>
        </environment>    
    </environments>
    <mappers>
        <mapper resource="cn/itcast/javaee/mybatis/app05/StudentMapper.xml"/>
    </mappers>
</configuration>
View Code

  5)创建MyBatisUtil工具类

技术分享
/**
 * MyBatis工具类
 * @author AdminTC
 */
public class MyBatisUtil {
    private static ThreadLocal<SqlSession> threadLocal = new ThreadLocal<SqlSession>();
    private static SqlSessionFactory sqlSessionFactory;
    static{
        try {
            Reader reader = Resources.getResourceAsReader("mybatis.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (IOException e) {
            e.printStackTrace();
            throw new RuntimeException(e);
        }
    }
    private MyBatisUtil(){}
    public static SqlSession getSqlSession(){
        SqlSession sqlSession = threadLocal.get();
        if(sqlSession == null){
            sqlSession = sqlSessionFactory.openSession();
            threadLocal.set(sqlSession);
        }
        return sqlSession;
    }
    public static void closeSqlSession(){
        SqlSession sqlSession = threadLocal.get();
        if(sqlSession != null){
            sqlSession.close();
            threadLocal.remove();
        }
    }
    public static void main(String[] args) {
        Connection conn = MyBatisUtil.getSqlSession().getConnection();
        System.out.println(conn!=null?"连接成功":"连接失败");
    }
}
View Code

  6)创建StudentDao

技术分享
/**
 * 持久层
 * @author AdminTC
 */
public class StudentDao {
    /**
     * 增加学生(无参)
     */
    public void add1() throws Exception{
        SqlSession sqlSession = MyBatisUtil.getSqlSession();
        try{
            sqlSession.insert("mynamespace.add1");
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            sqlSession.commit();
        }
        MyBatisUtil.closeSqlSession();
    }
    /**
     * 增加学生(有参)
     */
    public void add2(Student student) throws Exception{
        SqlSession sqlSession = MyBatisUtil.getSqlSession();
        try{
            sqlSession.insert("mynamespace.add2",student);
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            sqlSession.commit();
        }
        MyBatisUtil.closeSqlSession();
    }
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        dao.add1();
        dao.add2(new Student(2,"呵呵",8000D));
    }
}
View Code

4. mybatis工作流程

 

  1)通过Reader对象读取src目录下的mybatis.xml配置文件(改文件的名字和位置可变)
  2)通过SqlSessionFactoryBuilder对象创建sqlSessionFactory对象
  3)从当前线程中获取SqlSession对象
  4)事务开始,mybatis中默认
  5)通过sqlSession对象读取StudentMapper.xml映射文件中操作编号,从而读取sql语句
  6)事务提交必写
  7)关闭SqlSession对象并且分离当前线程与sqlSession对象,让GC尽早回收

5.mybatis配置文件解析

  1)StudentMapper.xml文件,提倡放在与实体同目录下,文件名任意
  2)environments连接环境信息优化:
    1.建一个db.properties用来存放连接信息
    2.在mybatis中properties属性可以加载这个配置信息
    3.连接环境配置属性值就可以用${mysql.url}形式从配置文件中获取了
  3)StudentMapper.xml中insert标签parameterType="app04.Student"每次要类全路径
    简化方式:
      1.mybatis中添加
      <!-- 设置类型别名 -->
      <typeAliases>
      <typeAlias type="app04.Student" alias="student"/>
      </typeAliases>
      2.之后在StudentMapper.xml中写类型时都可以用简称student了

技术分享
<?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="mynamespace">
    <insert id="add1">
        insert into students(id,name,sal) values(1,哈哈,7000)
    </insert>
    <insert id="add2" parameterType="cn.itcast.javaee.mybatis.app05.Student">
        insert into students(id,name,sal) values(#{id},#{name},#{sal})
    </insert>
</mapper>
View Code

6.mybatis映射文件祥解(StudentMapper.xml)

  StudentMapper:存放表映射;sql语句
  mybatis:连接环境信息,加载映射文件

7.基于MybatisUtil工具类,完成CURD操作

StudentMapper.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="app09.Student">
    
    <resultMap type="app09.Student" id="studentMap">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="sal" column="sal"/>
    </resultMap>
    
    <!-- 增加学生 -->
    <insert id="add" parameterType="app09.Student">
        insert into students(id,name,sal) values(#{id},#{name},#{sal})
    </insert>
    <!-- 根据ID查询学生
         如果参数不是一个实体的话,只是一个普通变量,例如:int,double,String
         这里的#{中间的变量名可以随便写},不过提倡就用方法的形参
     -->
    <select id="findById" parameterType="int" resultType="app09.Student">
        select * from students where id=#{id}
    </select>
    <!-- 查询所有学生 
         理论上resultType要写List<Student>
         但这里只需书写List中的类型即可,即只需书写Student的全路径名
    -->
    <select id="findAll" resultType="app09.Student">
        select id,name,sal from students
    </select>
    <!-- 更新学生 -->
    <update id="update" parameterType="app09.Student">
        update students set name=#{name},sal=#{sal}  where id=#{id}
    </update>
    <!-- 删除学生 -->
    <delete id="delete" parameterType="app09.Student">
        delete form students where id=#{id}
    </delete>
    
    <!-- 
        注意:这个insert/update/delete标签只是一个模板,在做操作时,其实是以SQL语句为核心的
             即在做增/删/时,insert/update/delete标签可通用,
             但做查询时只能用select标签
             我们提倡什么操作就用什么标签
    -->    
</mapper>
View Code

StudentDao.java

技术分享
package app09;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import util.MybatisUtil;

public class StudentDao {
    /**
     * 增加学生
     */
    public void add(Student student)throws Exception{
        SqlSession sqlSession=null;
        try{
            sqlSession=MybatisUtil.getSqlSession();
            //开始事务
            sqlSession.insert(Student.class.getName()+".add",student);
            sqlSession.commit();
            //提交
        }catch (Exception e) {
            e.printStackTrace();
            sqlSession.rollback();
        }finally{
            //解除关系让GC处理sqlSession对象
            MybatisUtil.closeSqlSession();
        }
    }
    /**
     *根据ID 查询学生
     */
    public Student findById(int id)throws Exception{
        SqlSession sqlSession=null;
        try{
            sqlSession=MybatisUtil.getSqlSession();
            //开始事务
            Student student=sqlSession.selectOne(Student.class.getName()+".findById", id);
            sqlSession.commit();
            return student;
            //提交
        }catch (Exception e) {
            e.printStackTrace();
            sqlSession.rollback();
            throw new RuntimeException();
        }finally{
            //解除关系让GC处理sqlSession对象
            MybatisUtil.closeSqlSession();
        }
    }
    /**
     *    查询所有学生
     */
    public List<Student> findAll()throws Exception{
        SqlSession sqlSession=null;
        try{
            sqlSession=MybatisUtil.getSqlSession();
            //开始事务
            return sqlSession.selectOne(Student.class.getName()+".findAll");
            
            //提交
        }catch (Exception e) {
            e.printStackTrace();
            sqlSession.rollback();
            throw new RuntimeException();
        }finally{
            //解除关系让GC处理sqlSession对象
            MybatisUtil.closeSqlSession();
        }
    }
    /**
     * 更新学生 
     */
    public void update(Student student) throws Exception{
        SqlSession sqlSession = null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
            sqlSession.update(Student.class.getName()+".update",student);
            sqlSession.commit();
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    /**
     * 删除学生 
     */
    public void delete(Student student) throws Exception{
        SqlSession sqlSession = null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
            sqlSession.delete(Student.class.getName()+".delete",student);
            sqlSession.commit();
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        //dao.add(new Student(1,"哈哈",7000D));
        //dao.add(new Student(2,"呵呵",8000D));
        //dao.add(new Student(3,"班长",9000D));
        //dao.add(new Student(4,"键状高",10000D));
        //Student student = dao.findById(4);
        //List<Student> studentList = dao.findAll();
        //for(Student student : studentList){
        //    System.out.print(student.getId()+":"+student.getName()+":"+student.getSal());
        //    System.out.println();
        //}
        Student student = dao.findById(3);
        System.out.println(student.getName());
        //student.setName("靓班长");
        //dao.update(student);
        
        //Student student = dao.findById(3);
        //System.out.print(student.getId()+":"+student.getName()+":"+student.getSal());
        
        //dao.delete(student);
    }
}
View Code

8.分页查询

技术分享
package app10;

import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import util.MybatisUtil;

public class StudentDao {
    public void add(Student student)throws Exception{
        SqlSession sqlSession=null;
        try{
            sqlSession.insert(Student.class.getName()+".add",student);
            sqlSession.commit();
        }catch (Exception e) {
            e.printStackTrace();
            sqlSession.rollback();
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    /**
     * 分页
     * 在映射文件中参数不能是多个,对个多个参数需要封装用map
     * @param start
     * @param size
     * @return
     */
    public List<Student> findAllWithFy(int start,int size){
        SqlSession sqlSession=null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
            
            Map<String,Object> map = new LinkedHashMap<String,Object>();
            map.put("pstart",start);
            map.put("psize",size);
            return sqlSession.selectList(Student.class.getName()+".findAllWithFy", map);
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw new RuntimeException();
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    /**
     * 分页有条件
     * 在映射文件中参数不能是多个,对个多个参数需要封装用map
     * @param start
     * @param size
     * @return
     */
    public List<Student> findAllWithFy(String name,int start,int size){
        SqlSession sqlSession=null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
            
            Map<String,Object> map = new LinkedHashMap<String,Object>();
            map.put("pstart",start);
            map.put("psize",size);
            map.put("pname", "%"+name+"%");
            return sqlSession.selectList(Student.class.getName()+".findAllByNameWithFy", map);
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw new RuntimeException();
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        
        //for(int i=1;i<=10;i++){
        //    dao.add(new Student(i,"哈哈",7000D));
        //}
        
        System.out.println("--------------------第一页");
        List<Student> studentList1=dao.findAllWithFy("xiao",0, 2);
        
        //List<Student> studentList1 = dao.findAllByNameWithFy("哈",0,3);
        for(Student s : studentList1){
            System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());
        }
        //System.out.println("--------------------第二页");
        //List<Student> studentList2 = dao.findAllByNameWithFy("哈",3,3);
        //for(Student s : studentList2){
        //    System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());
        //}
        //System.out.println("--------------------第三页");
        //List<Student> studentList3 = dao.findAllByNameWithFy("哈",6,3);
        //for(Student s : studentList3){
        //    System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());
        //}
        
    }
}
View Code
技术分享
<?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="app10.Student">
    
    <resultMap type="app10.Student" id="studentMap">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="sal" column="sal"/>
    </resultMap>
    

    <insert id="add" parameterType="app10.Student">
        insert into students(id,name,sal) values(#{id},#{name},#{sal})
    </insert>
    <select id="findAllWithFy" parameterType="map" resultMap="studentMap">
        select id,name,sal from students limit #{pstart},#{psize}
    </select>
    <select id="findAllByNameWithFy" parameterType="map" resultMap="studentMap">
        select id,name,sal from students where name like #{pname} limit #{pstart},#{psize}
    </select>
</mapper>
View Code

9。动态SQL操作

  1)动态查询:select id,name,sal from students where 1=1 and name=? and sal=?

技术分享
<where>
            <if test="pid!=null">
                and id=#{pid}
            </if>
            <if test="pname!=null">
                and name=#{pname}
            </if>
            <if test="psal=null">
                and sal=#{psal}
            </if>
</where>
View Code

StudentMapper.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="app11.Student">
    
    <resultMap type="app11.Student" id="studentMap">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="sal" column="sal"/>
    </resultMap>
    

    <select id="findAll" parameterType="map" resultMap="studentMap">
        select * from students
        <where>
            <if test="pid!=null">
                and id=#{pid}
            </if>
            <if test="pname!=null">
                and name=#{pname}
            </if>
            <if test="psal=null">
                and sal=#{psal}
            </if>
        </where>
    </select>
    
</mapper>
View Code

StudentDao.java

技术分享
package app11;

import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;

import util.MybatisUtil;

/**
 * 持久层 
 * @author AdminTC
 */
public class StudentDao {
    /**
     * 有条件的查询所有学生
     */
    public List<Student> findAll(Integer id,String name,Double sal) throws Exception{
        SqlSession sqlSession = null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
                
            Map<String,Object> map = new LinkedHashMap<String,Object>();
            map.put("pid",id);
            map.put("pname",name);
            map.put("psal",sal);
            
            return sqlSession.selectList(Student.class.getName()+".findAll",map);
        }catch(Exception e){
            e.printStackTrace();
            throw e;
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        List<Student> studentList = dao.findAll(4,null,null);
        for(Student s : studentList){
            System.out.println(s.getId()+":"+s.getName()+":"+s.getSal());
        }
    }
}
View Code

  2)动态更新:update students set name=?,sal=? where id=?

StudentDao.java

技术分享
package app12;

import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;

import util.MybatisUtil;

/**
 * 持久层 
 * @author AdminTC
 */
public class StudentDao {
    /**
     * 有条件更新学生
     */
    public void dynaUpdate(Integer id,String name,Double sal) throws Exception{
        SqlSession sqlSession = null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
                
            Map<String,Object> map = new HashMap<String, Object>();
            map.put("pid",id);
            map.put("pname",name);
            map.put("psal",sal);
            sqlSession.update("studentNamespace.dynaUpdate",map);
            sqlSession.commit();
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        //关注SQL的变化
        //dao.dynaUpdate(1,null,9000D);//update students set sal=? where id=?
        //dao.dynaUpdate(1,"笨笨",null);//update students set name=? where id=?
        dao.dynaUpdate(1,"笨笨",10000D);//update students set name=? and sal=? where id=?
    }
}
View Code

StudentMapper.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="studentNamespace">    

    <resultMap type="app12.Student" id="studentMap">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="sal" column="sal"/>
    </resultMap>

    <!-- set标签自动判断哪个是最后一个字段,会自动去掉最后一个,号 -->
    <update id="dynaUpdate" parameterType="map">
        update students 
        <set>
            <if test="pname!=null">
                students_name = #{pname},
            </if>
            <if test="psal!=null">
                students_sal = #{psal},            
            </if>
        </set>
        where students_id = #{pid}
    </update>
    
    
</mapper>
View Code

  3)动态删除

delete from students where id in (1,3,5,7)
select id,name,sal from students where id in (2,4,6,8)

StudentDao.java

技术分享
package app13;

import java.util.ArrayList;
import java.util.List;

import org.apache.ibatis.session.SqlSession;

import app13.StudentDao;

import util.MybatisUtil;

/**
 * 持久层 
 * @author AdminTC
 */
public class StudentDao {
    /**
     * 根据ID批量删除学生(数组版本)
     * @param ids
     * @throws Exception
     */
    public void dynaDeleteArray(int ...ids)throws Exception{
        SqlSession sqlSession=null;
        try{
            sqlSession=MybatisUtil.getSqlSession();
            sqlSession.delete(Student.class.getName()+".dynaDeleteArray",ids);
            sqlSession.commit();
        }catch (Exception e) {
            e.printStackTrace();
            sqlSession.rollback();
            throw new RuntimeException();
        }finally{
            MybatisUtil.closeSqlSession();
        }    
    }
    
    public void dynaDeleteList(List<Integer> ids)throws Exception{
        SqlSession sqlSession = null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
            sqlSession.delete("studentNamespace.dynaDeleteList",ids);
            sqlSession.commit();
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            MybatisUtil.closeSqlSession();
        }
    }
    
    

    
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        dao.dynaDeleteArray(2,4);
        
        //List<Integer> ids = new ArrayList<Integer>();
        //ids.add(6);
        //ids.add(8);
        //ids.add(9);
        //dao.dynaDeleteList(ids);
    }
}
View Code

StudentMapper.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="app13.Student">    

    <resultMap type="app13.Student" id="studentMap">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="sal" column="sal"/>
    </resultMap>
    
    <delete id="dynaDeleteArray">
        delete from students where id in
        <!-- foreach用于迭代数组元素
             open表示开始符号
             close表示结束符合
             separator表示元素间的分隔符
             item表示迭代的数组,属性值可以任意,但提倡与方法的数组名相同
             #{ids}表示数组中的每个元素值
         -->
         <foreach collection="array" open="(" close=")" separator="," item="ids">
             #{ids}
         </foreach>
    </delete>

    <delete id="dynaDeleteList">
        delete from students where id in
        <foreach collection="list" open="(" close=")" separator="," item="ids">
            #{ids}
        </foreach>
    </delete>
</mapper>
View Code

  4)动态插入:insert into student(id,name,sal) values(?,?,?)

StudentMapper.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="studentNamespace">    

    <resultMap type="app14.Student" id="studentMap">
        <id property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="sal" column="sal"/>
    </resultMap>

    <!-- 定义sql片段   字段名,id属性值任意写-->
    <sql id="key">
        <trim suffixOverrides=",">
            <if test="id!=null">
                id,
            </if>
            <if test="name!=null">
                name,
            </if>
            <if test="sal!=null">
                sal,
            </if>
        </trim>
        
    </sql>
    <!-- 定义sql片段 ? -->
    <sql id="value">
        <!-- 去掉最后一个, -->
        <trim suffixOverrides=",">
            <if test="id!=null">
                #{},
            </if>
            <if test="name!=null">
                #{},
            </if>
            <if test="sal!=null">
                #{},
            </if>
        </trim>
        
    </sql>
    
    <insert id="dynaInsert" parameterType="day14.Student">
        insert into students(<include refid="key"></include>) values(<include refid="value"></include>)
    </insert>
    
</mapper>
View Code

StudentDao.java

技术分享
package app14;

import java.util.ArrayList;
import java.util.List;

import org.apache.ibatis.session.SqlSession;

import app13.Student;

import util.MybatisUtil;

/**
 * 持久层 
 * @author AdminTC
 */
public class StudentDao {
    /**
     * 动态插入学生
     */
    public void dynaInsert(Student student) throws Exception{
        SqlSession sqlSession = null;
        try{
            sqlSession = MybatisUtil.getSqlSession();
            sqlSession.insert("studentNamespace.dynaInsert",student);
            sqlSession.commit();
        }catch(Exception e){
            e.printStackTrace();
            sqlSession.rollback();
            throw e;
        }finally{
            //MybatisUtil.closeSqlSession();
        }
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    public static void main(String[] args) throws Exception{
        StudentDao dao = new StudentDao();
        //dao.dynaInsert(new Student(1,"哈哈",7000D));//insert into 表名(*,*,*) values(?,?,?)
        dao.dynaInsert(new Student(2,"哈哈",null));//insert into 表名(*,*) values(?,?)
        //dao.dynaInsert(new Student(3,null,7000D));//insert into 表名(*,*) values(?,?)
        //dao.dynaInsert(new Student(4,null,null));//insert into 表名(*) values(?)
    }
}
View Code

 

java深入探究16-mybatis