一: xml/注解完成基本的crud
1.1:mybatis的基础环境搭建
步骤:
1.创建maven工程
2.导入mybatis的jar包和数据库驱动包,log4j.jar(方便打印sql日志)
3.配置mybatis核心配置文件,jdbc.properties,log4j.properties
4.创建表,实体类
5.创建Mapper接口和对应的映射文件
6.在mybatis核心配置文件中加载映射文件
7.使用junit测试,或者使用maven的mvn test来查看测试结果(一次性测试结果打印到控制台,而且由于线程的原因,打印的顺序显示可能不一致)
1、创建maven工程
2、导入jar坐标
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.6</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
注意:在导入完jar坐标后,发现jar包根据就没有引入进来,可能要设置File - > Settings -> Build, Execution, Deployment -> Build Tools -> Maven | Importing -> 勾选Import Maven projects automatically
3、配置文件
- jdbc.properties
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&useUnicode=true&charaterEncoding=utf-8&useSSL=false
jdbc.user=root
jdbc.password=123456
- mybatis-config.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-->
<properties resource="jdbc.properties"></properties>
<!-- 配置MyBatis运⾏行行环境 -->
<environments default="development">
<environment id="development">
<!-- 配置JDBC事务管理理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- POOLED配置JDBC数据源连接池 -->
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"></property>
<!--在配置文件中需要将: &改为&-->
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="\com.wzj.mapper\PersonMapper.xml"></mapper>
</mappers>
</configuration>
- log4j.properties
### direct log messages to stdout ###
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=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
### set log levels - for more verbose logging change 'info' to 'debug' ###
log4j.rootLogger=debug, stdout
注:将log4j.rootLogger=
info
, stdout,改成log4j.rootLogger=debug
, stdout即可
4、创建表
CREATE TABLE `person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
5、创建实体类(根据表创建)
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Person {
private Integer id;
private String name;
}
6、创建Mapper接口
public interface PersonMapper {
void save(Person person);
void delete(Serializable id);
void update(Person person);
Person findById(Serializable id);
List<Person> findAll();
}
7、创建对应的映射文件
<?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.wzj.mapper.PersonMapper">
<!-- void save(Person person);-->
<insert id="save" parameterType="com.wzj.domain.Person">
insert into person(name) values(#{name})
</insert>
<!--void delete(Serializable id);-->
<delete id="delete">
delete from person where id = #{id}
</delete>
<!-- void update(Person person);-->
<update id="update" parameterType="com.wzj.domain.Person">
update person set name = #{name} where id = #{id}
</update>
<!--Person findById(Serializable id);-->
<select id="findById" resultType="com.wzj.domain.Person">
select * from person where id = #{id}
</select>
<!--List<Person> findAll();-->
<select id="findAll" resultType="com.wzj.domain.Person">
select * from person
</select>
</mapper>
8、加载核心配置文件
<mappers>
<mapper resource="\com.wzj.mapper\PersonMapper.xml"></mapper>
</mappers>
注:resource属性是相当于类路径下加载的,我这里的创建的
com.wzj.mapper
idea并没有帮我创建成三个文件夹,而是就是一个文件夹的名称(很坑)。你可以使用show in explorer
查看一下就知道了,因为这个原因导致我之前报错,一直说找不到这个映射文件
9、测试(选中Mapper接口右键,生成对应的测试类)
public class PersonMapperTest {
private SqlSession sqlSession;
private PersonMapper mapper;
@Before
public void setUp() throws Exception {
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
sqlSession = sqlSessionFactory.openSession(true);
mapper = sqlSession.getMapper(PersonMapper.class);
}
@After
public void tearDown() throws Exception {
sqlSession.close();
}
@Test
public void save() {
Person person = new Person();
person.setName("wzj");
mapper.save(person);
}
@Test
public void delete() {
mapper.delete(2);
}
@Test
public void update() {
mapper.update(new Person(1,"tom"));
}
@Test
public void findById() {
Person person = mapper.findById(1);
System.out.println(person);
}
@Test
public void findAll() {
List<Person> ps = mapper.findAll();
ps.forEach(person -> System.out.println(person));
}
}
注:其实上面的已经实现了xml完成简单的增删改查
1.2:使用注解完成简单的crud
使用注解的话,唯一的不同,就是不需要写映射文件了,将映射文件中的sql语句,通过对应的注解直接写到接口中的方法上,还是在核心配置文件加载映射文件不太同,其实都是一样的
- Mapper接口
public interface PersonMapper {
@Insert("insert into person(name) values(#{name})")
void save(Person person);
@Delete("delete from person where id = #{id}")
void delete(Serializable id);
@Update("update person set name = #{name} where id = #{id}")
void update(Person person);
@Select("select * from person where id = #{id}")
Person findById(Serializable id);
@Select("select * from person")
List<Person> findAll();
}
- 引入映射文件
<mappers>
<package name="com.wzj.mapper"/>
</mappers>
name属性:表示扫描Mapper接口所在的包!
注:来自虽然帅,但是菜的cxy