MyBatis框架简单使用
1.添加mybatis包
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.15</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
<scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
2.添加db.properties
这里后面没有使用这种方式,因为解析不了,不知道为啥
# 数据库配置文件
db.driver=com.mysql.cj.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=Asia/Shanghai
db.username=root
db.password=123456
这里有两点需要注意的地方
1.driver的写法:com.mysql.cj.jdbc.Driver和com.mysql.jdbc.Driver的区别
https://blog.csdn.net/superdangbo/article/details/78732700
2.serverTimezone=Asia/Shanghai千万不要大小写写错,否则...
3.创建SqlMapConfig.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>
<!--加载数据库配置文件-->
<!-- <properties resource="db.properties"/>-->
<!--配置properties-->
<properties>
<property name="driver" value="com.mysql.cj.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=Asia/Shanghai"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</properties>
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
<!-- 别名设置,全路径名改成类名-->
<typeAliases>
<!-- 该包下面实体类全部采用别名形式-->
<package name="com.mybatis.entity"/>
</typeAliases>
<!--数据库配置环境-->
<environments default="mysql">
<!-- 配置mysql的环境-->
<environment id="mysql">
<!-- 配置事务 -->
<transactionManager type="JDBC"></transactionManager>
<!--配置连接池-->
<dataSource type="POOLED">
<property name="driver" value="${driver}"></property>
<property name="url" value="${url}"></property>
<property name="username" value="${username}"></property>
<property name="password" value="${password}"></property>
</dataSource>
</environment>
</environments>
<!-- 配置映射文件的位置 -->
<mappers>
<!-- <package name="com.mybatis.mapper"></package>-->
<mapper resource="com/mybatis/mapper/UserMapper.xml"></mapper>
</mappers>
</configuration>
这里注意两点:
1.没有使用解析的方式,而是直接写的数据库连接配置信息
2.下面mapper的写法
写法不一样
报错:Could not find resource com.mybatis.mapper
com/mybatis/mapper/UserMapper.xml
之前写的是com.mybatis.mapper是错的会找不到mapper对应的xml文件
https://www.cnblogs.com/mkl7/p/10745371.html
4.创建Mapper以及Mapper.xml
UserMapper
package com.mybatis.mapper;
import com.mybatis.entity.User;
import java.util.List;
public interface UserMapper {
User selectUserById(Long id);
List<User> selectAllUsers();
void delectUserById(Long id);
}
UserMapper.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:填写映射当前的Mapper接口,所有的增删改查的参数和返回值类型,
就可以直接填写缩写,不区分大小写,直接通过方法名去找类型-->
<mapper namespace="com.mybatis.mapper.UserMapper">
<!-- 根据id查询用户-->
<select id="selectUserById" parameterType="java.lang.Long" resultType="user">
select * from mybatis_user where id=#{value}
</select>
<!-- 查询所有用户-->
<select id="selectAllUsers" resultType="User">
select * from mybatis_user
</select>
<!-- 根据id删除用户-->
<delete id="delectUserById" parameterType="java.lang.Long">
delete from mybatis_user where id=#{value}
</delete>
</mapper>
entity包下User实体
package com.mybatis.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private Long id;
private String username;
private String password;
}
5.log4j配置文件
log4j.properties
### 设置###
log4j.rootLogger = debug,stdout,D,E
### 输出信息到控制抬 ###
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.out
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} method:%l%n%m%n
### 输出DEBUG 级别以上的日志到=D://Projects/java/Mybatis/logs/log.log ###
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = D://Projects/java/Mybatis/logs/log.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = DEBUG
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n
### 输出ERROR 级别以上的日志到=D://Projects/java/Mybatis/logs/log.log ###
log4j.appender.E = org.apache.log4j.DailyRollingFileAppender
log4j.appender.E.File =D://Projects/java/Mybatis/logs/log.log
log4j.appender.E.Append = true
log4j.appender.E.Threshold = ERROR
log4j.appender.E.layout = org.apache.log4j.PatternLayout
log4j.appender.E.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n
6.测试类
package com.mybatis.mapper;
import com.mybatis.entity.User;
import junit.framework.TestCase;
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.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.Reader;
public class UserMapperTest extends TestCase {
private SqlSession sqlSession;
private UserMapper mapper;
@Before
public void setup() {
System.out.println("begin:before");
try {
//mybatis连接工厂
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsReader("SqlMapConfig.xml"));
//mybatis连接对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//mybatis的mapper的代理对象
mapper = sqlSession.getMapper(UserMapper.class);
System.out.println("#######################");
System.out.println(mapper);
} catch (IOException e) {
e.printStackTrace();
}
}
@Test
public void testSelectAllUsers() {
SqlSessionFactory sqlSessionFactory = null;
try {
Reader r=Resources.getResourceAsReader("SqlMapConfig.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(r);
} catch (IOException e) {
e.printStackTrace();
}
//mybatis连接对象
SqlSession sqlSession = sqlSessionFactory.openSession();
//mybatis的mapper的代理对象
mapper = sqlSession.getMapper(UserMapper.class);
System.out.println(mapper);
System.out.println(sqlSession);
mapper.selectAllUsers().forEach(System.out::println);
}
@Test
public void testSelectUserById() {
User user = mapper.selectUserById(1L);
System.out.println(user);
}
@Test
public void testDelectUserById() {
mapper.delectUserById(3L);
// mybatis默认情况是手动提交事务的
sqlSession.commit();
}
@After
public void tearDown() {
if (sqlSession != null) {
sqlSession.close();
}
}
}
这里有个问题就是我的@Before没有起作用,所以我把连接先写在函数中
运行结果只有查询
中间碰到的一切爆红的错误,都是因为书写不正确的粗心导致,仔细检查
在pom文件中需要注意添加
<!--maven默认打包是不会认为资源文件需要打入包内,所以需要设置-->
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
<include>**/*.properties</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>