Mybatis学习总结
1、创建一个maven项目
导入依赖
<!-- 导入依赖-->
<dependencies>
<!-- mysql加载驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<!-- mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!-- junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
</dependencies>
2、创建一个模块
配置核心文件
<?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>
<properties resource="db.properties">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis_db?useSSl=false&serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8"/>
</properties>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis_db?useSSl=false&serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper class="com.kwy.dao.StudentMapper"/>
<mapper class="com.kwy.dao.TeacherMapper"/>
</mappers>
</configuration>
在utils工具类中创建sqlSessionFactory方法,并返回sqlSession
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static{
try {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory= new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession() {
return sqlSessionFactory.openSession();
}
}
创建接受数据库的User实体类
创建操作数据库的Dao文件
<?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">
<!--column 对应数据库 property 对应要加入数据库的字段,可以在类中采用自己想要的名称-->
<mapper namespace="com.kwy.com.kwy.dao.UserMapper">
<resultMap id="UserMap" type="User">
<result column="id" property="id"/>
<result column="name" property="name"/>
<result column="pwd" property="pwd"/>
</resultMap>
<select id="getUserList" resultMap="UserMap">
select * from mybatis_db.mybatis_tb
</select>
<!-- parameterType参数的类型,resultType返回值类型 -->
<select id="getUserById" parameterType="int" resultType="com.kwy.com.kwy.pojo.User">
select * from mybatis_db.mybatis_tb where id=#{id}
</select>
<insert id="addUser" parameterType="com.kwy.com.kwy.pojo.User">
insert into mybatis_db.mybatis_tb value (#{id},#{name},#{pwd})
</insert>
</mapper>
配置xml文件,mabatis的方式实现数据库的调用
test文件
3、经典报错
Type interface com.kwy.com.kwy.dao.UserMapper is not known to the MapperRegistry.
没有配置mappers的路径,需要为mapper设置xml的路径
MapperRegistry注册绑定mapper文件
Exception in thread “main” org.apache.ibatis.exceptions.PersistenceException
这个问题时版本号不对应,可能是java的版本号,也可能是mysql
4、mapper
<!-- 每一个mapper.xml都需要在mybatis核心配置文件中注册-->
<mappers>
<mapper resource="com/kwy/com.kwy.dao/UserMapper.xml"/>
</mappers>
使用class、package需要接口名和同一包下的xml文件同名,才能保证文件运行
5 crud
1、namespace中的包名要和dao mapper 接口的包名一致
2、id时namespace中的方法名
6、开发流程
1、配置核心核心配置文件 mybatis-config
2、transactionManager 事务管理器,默认jdbc还有几乎不用的managed
3、dataSource 数据源pooled 、unpooled、
7、当属性名和数据库内的名称不同时的解决方式
1、修改数据库内的字符名
2 使用resultMap方式
<!--column 对应数据库 property 对应要加入数据库的字段,可以在类中采用自己想要的名称-->
<mapper namespace="com.kwy.com.kwy.dao.UserMapper">
<resultMap id="UserMap" type="User">
<result column="id" property="id"/>
<result column="name" property="name"/>
<result column="pwd" property="pwd"/>
</resultMap>
<select id="getUserList" resultMap="UserMap">
select * from mybatis_db.mybatis_tb
</select>
</mapper>
8、log4j
log4j.properties文件
#将等级为DEBUG的日志信息输出到console和file这两个目的地,console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file
#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=【%c】-%m%n
#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/kuang.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=【%p】【%d{yy-MM-dd}】【%c】%m%n
#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
9、limit分页
1 select * from user limit startindex pagesize
2 select * from user limit 4 从零到4
10、注解
可以使用java注解实现操作数据库的一些功能,但太过复杂的操作,用注解会导致错误,所以一般都用xml来实现mybatis的相关操作
使用注解实现接口:
@select("select * from user")
List<User> getUserList();
@Select("select * from mybatis_db.mybatis_tb where id=#{id}")
User getUserById(@Param("id") int id);
@Insert("insert into mybatis.tb value(#{id},#{name},#{pwd})")
void addUser(User user);
@Delete("delete from mybatis_tb where id=#{id}")
void deleteUser(@Param("id") int id);
@Update("update mybatis_tb set name=#{name},pwd=#{pwd} where id=#{id}")
void updataUser(User user);
@Param
基本类型和String类型需要加上
引用类型不需要加
只有一个基本类型可以不加,但是建议加上
11、lombok偷懒注解
@Getter and @Setter
@FieldNameConstants
@ToString
@EqualsAndHashCode
@AllArgsConstructor, @RequiredArgsConstructor and @NoArgsConstructor
@Log, @Log4j, @Log4j2, @Slf4j, @XSlf4j, @CommonsLog, @JBossLog, @Flogger, @CustomLog
@Data
@Builder
@SuperBuilder
@Singular
@Delegate
@Value
@Accessors
@Wither
@With
@SneakyThrows
@val
@var
experimental @var
@UtilityClass
Lombok config system
Code inspections
Refactoring actions (lombok and delombok)
12、多对一查询方式
<mapper namespace="com.kwy.dao.StudentMapper">
<select id="getStudentList" resultMap="StudentTeacher">
select * from mybatis_db.student
</select>
<resultMap id="StudentTeacher" type="com.kwy.pojo.Student">
<result property="sid" column="sid"/>
<result property="sname" column="sname"/>
<association property="teacher" column="t_id" javaType="com.kwy.pojo.Teacher" select="getTeacher"/>
</resultMap>
<select id="getTeacher" resultType="com.kwy.pojo.Teacher">
select * from mybatis_db.teacher where tid=#{t_id}
</select>
<select id="getStudent" resultMap="StudentTeacher2">
select s.sid std,s.sname stn,t.tname tn from mybatis_db.student s ,mybatis_db.teacher t where s.t_id=t.tid
</select>
<resultMap id="StudentTeacher2" type="com.kwy.pojo.Student">
<result property="sid" column="std"/>
<result property="sname" column="stn"/>
<association property="teacher" javaType="com.kwy.pojo.Teacher">
<result property="tname" column="tn"/>
</association>
</resultMap>
</mapper>
13、一对多查询方式
<mapper namespace="com.kwy.dao.TeacherMapper">
<select id="getTeacher" resultMap="TeacherStudent">
select * from mybatis_db.teacher t,mybatis_db.student s where t.tid=s.t_id
</select>
<resultMap id="TeacherStudent" type="com.kwy.pojo.Teacher">
<result property="tid" column="tid"/>
<result property="tname" column="tname"/>
<collection property="student" ofType="com.kwy.pojo.Student">
<result property="sid" column="sid"/>
<result property="sname" column="sname"/>
<result property="t_id" column="t_id"/>
</collection>
</resultMap>
<select id="getAllTeacher" resultMap="tas">
select *from mybatis_db.teacher
</select>
<resultMap id="tas" type="com.kwy.pojo.Teacher">
<result property="tid" column="tid"/>
<result property="tname" column="tname"/>
<collection property="student" javaType="ArrayList" ofType="com.kwy.pojo.Student" select="getStudents" column="tid"/>
</resultMap>
<select id="getStudents" resultType="com.kwy.pojo.Student">
select *from mybatis_db.student where t_id=#{tid}
</select>
</mapper>
14、动态sql
<select id="getStudentById" parameterType="map" resultType="com.kwy.pojo.Student">
select * from mybatis_db.student
<where>
<if test="sid != null">
sid=#{sid}
</if>
</where>
</select>
<update id="updateStudent" parameterType="Object">
UPDATE STUDENT
<set>
<if test="name!=null and name!='' ">
NAME = #{name},
</if>
<if test="hobby!=null and hobby!='' ">
MAJOR = #{major},
</if>
<if test="hobby!=null and hobby!='' ">
HOBBY = #{hobby}
</if>
</set>
WHERE ID = #{id};
</update>
sql标签,使用sql标签抽取公共部分,在需要使用的地方使用include引用即可
<sql>
<if test="name!=null and name!='' ">
NAME = #{name},
</if>
<if test="hobby!=null and hobby!='' ">
MAJOR = #{major},
</if>
<if test="hobby!=null and hobby!='' ">
HOBBY = #{hobby}
</if>
</sql>
15、缓存
将资源暂存在系统的资源中,再次访问不用访问磁盘,直接访问缓存数据
lru 最少使用 fifo 先进先出
在mybatis-config.xml中设置二级缓存
<setting name="cacheEnabled" value="true"/>
在映射文件中开启二级缓存
<cache eviction="LRU" flushInterval="100000" readOnly="true" size="1024"/>
…还有不足,后续复习再补充(QAQ)