Mybatis(2)

生命周期和作用域

生命周期和作用域是至关重要的,因为错误的使用会导致非常严重的并发问题

SqlSessionFactoryBuilder

这个类可以被实例化、使用和丢弃，一旦创建了 SqlSessionFactory，就不再需要它了。
因此 SqlSessionFactoryBuilder 实例的最佳作用域是方法作用域（也就是局部方法变量）。

SqlSessionFactory

说白了就是数据库连接池。SqlSessionFactory 一旦被创建就应该在应用的运行期间一直存在，没有任何理由丢弃它或重新创建另一个实例。
使用 SqlSessionFactory 的最佳实践是在应用运行期间不要重复创建多次，多次重建 SqlSessionFactory 被视为一种代码“坏习惯”。因此 SqlSessionFactory 的最佳作用域是应用作用域。

SqlSession

连接到连接池的一个请求
每个线程都应该有它自己的 SqlSession 实例。SqlSession 的实例不是线程安全的，因此是不能被共享的，所以它的最佳的作用域是请求或方法作用域。
用完之后需要赶紧关闭,否则资源被占用。

Mybatis日志

有五种方式

SLF4J | LOG4J | LOG4J2

JDK_LOGGING

COMMONS_LOGGING

STDOUT_LOGGING

NO_LOGGING

第一步：导入依赖

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

第二步:在mybatis-config.xml中设置

    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>

第三步:创建log4j.properties

log4j.rootLogger=debug, stdout, R

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p - %m%n

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=firestorm.log

log4j.appender.R.MaxFileSize=100KB
log4j.appender.R.MaxBackupIndex=1

log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n

log4j.logger.com.codefutures=DEBUG

参数传递

1.简单的参数我们不需要parameterType 参数定义

List<User> selectUser(int id);

2.多个参数我们需要使用@param来绑定 以@para()中的值为准

User selectOne(@Param("id") int id,@Param("name") String name);

3.传入对象,需要使用parameterType

//java
int insertUser(User user);

//xml
<insert id="insertUser" parameterType="User">
        insert into user (id, name, psw)
        values (#{id}, #{name}, #{psw})
</insert>

万能Map

1.接口

public void addUser(Map<String,Object> map);

2.UserMapper.xml

<insert id="addUser2" parameterType="map">
    insert into user (id,name,psw) values (#{idd},#{namee},#{psww})
</insert>

3.测试

public class MyTest {   
    @Test
    public void test3(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        HashMap<String, Object> map = new HashMap<String, Object>();
        map.put("idd",111);
        map.put("namee","李文博");
        map.put("psww",123456);
        mapper.addUser2(map);
        sqlSession.commit();
        sqlSession.close();
    }
}

Map传递参数，直接在sql中取出key即可！

POJO 对象输出映射

如果表中的类名与类中的属性名完全相同,mybatis会自动将查询结果封装 到POJO对象中.

如果java中使用标准驼峰命名,数据库中使用下划线连接命名,可以开始全局设置实现自动转换
例如数据库名user_Name 实体类中属性名 userName 就可以对应

<setting name="mapUnderscoreToCamelCase" value="true"/>

结果处理

Map

1.接口

User selectOneUser(int id);

2.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.lwb.dao.UserMapper"> 
    <!--结果集映射-->
    <resultMap id="UserMap" type="User">
        <!--column数据库中的字段   property实体类中的属性 -->
        <result column="idd" property="id"/>
        <result column="namee" property="name"/>
        <result column="psw" property="psw"/>
    </resultMap>
    <select id="selectOneUser" parameterType="int" resultMap="UserMap">
        select  idd,namee,psw from user where idd=#{idd}
    </select>
</mapper>

3.测试

    @Test
    public void deleteUserTest(){
        SqlSession sqlSession = MybatisUtils.getSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.selectOneUser(41);
        System.out.println(user.toString());
        sqlSession.commit();
        sqlSession.close();*/
    }

作用

1.解决了数据库字段名和实体类属性名不一致的问题

组成

association 一个复杂类型的关联；许多结果将包装成这种类型
collection 一个复杂类型的集合
property 映射到列结果的字段或属性
column 数据库中的列名
javaType 一个 Java 类的全限定名，或一个类型别名

多表关联处理结果集

多对一

1.创建实体类

学生类:

package com.lwb.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
    private int id;
    private String name;
    private Teacher teacher;
    List<Student> student;
}

教师类

package com.lwb.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Teacher {
    private int tid;
    private String tname;
}

2.配置接口

package com.lwb.dao;
public interface UserMapper {
    Student selStudent(int id);
    
    Teacher selTeacher(int tid);
}

3.配置xml文件

(1)按照查询嵌套处理

<?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.lwb.dao.UserMapper">
    <select id="selStudent" resultMap="studentMap">
        select * from student where id = #{id}
    </select>
    
    <resultMap id="studentMap" type="Student">
        <result property="id" column="id"/>
        <result property="name" column="name"/>
        <collection property="teacher" column="tid" javaType="Teacher" select="selTeacher"></collection>
    </resultMap>
    <select id="selTeacher" resultType="Teacher">
        select * from teacher where tid = #{tid}
    </select>
</mapper>

(2)按照结果嵌套处理

<?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.lwb.dao.UserMapper">
    <select id="selStudent" resultMap="studentMap1">
        select student.id, student.name, teacher.tid, teacher.tname
        from teacher,
             student
        where student.tid = teacher.tid
          and student.id = #{student.id}
    </select>

    <resultMap id="studentMap1" type="student">
        <result property="id" column="student.id"/>
        <result property="name" column="student.name"/>
        <association property="teacher" javaType="teacher">
            <association property="tname" column="teacher.tname"/>
            <association property="tid" column="teacher.tid"/>
        </association>

    </resultMap>

</mapper>

4.测试

package com.lwb.pojo;

import com.lwb.dao.UserMapper;
import com.lwb.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class MyTest {
    @Test
    public void selStudent() {
        SqlSession sqlSession = MybatisUtils.getSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        Student student = mapper.selStudent(1);
        System.out.println(student.toString());
        sqlSession.commit();
        sqlSession.close();
    }
}
/*
Student(id=1, name=小明, teacher=Teacher(tid=1, tname=李文博))
DEBUG - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@4ba2ca36]
DEBUG - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@4ba2ca36]
DEBUG - Returned connection 1268959798 to pool.
*/

一对多

1.配置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.lwb.dao.UserMapper">


    <select id="getTeacher" parameterType="int" resultMap="teacherMap">
        select student.id sid, student.name sna, teacher.tid tid, teacher.tname tna
        from teacher,
             student
        where student.tid = teacher.tid
          and teacher.tid = #{tid}
    </select>

    <resultMap id="teacherMap" type="Teacher">
        <result property="tid" column="tid"></result>
        <result property="tname" column="tna"></result>
        <collection property="student" ofType="Student">
            <result column="sid" property="id"/>
            <result column="sna" property="name"/>
        </collection>
    </resultMap>
</mapper>