1.关于Mybatis的环境配置
如有问题,多多指教<*_*>
第一步:
首先新建一个普通的maven项目
然后在pom.xml中导入相关的依赖,复制下列代码到pom.xml中即可:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>MybatisLearn1</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.7</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<resources>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
<plugins>
<!-- 解决idea maven工程的module的Language Level总是自动变到5-->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.10.0</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
这里是导入了数据库还有mybatis的依赖,可以在maven项目中查看:
然后我们需要在resource的资源文件夹下新建一个编写mybatis的核心配置文件:
内容如下:
<?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="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/user?useSSL=false&useUnicode=true&characterEncoding=UTF-8"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="Mapper/makerMybatis.xml"/>
</mappers>
</configuration>
同时注意这里
<mappers> <mapper resource="Mapper/makerMybatis.xml"/> </mappers>
<!-- mappers 元素则包含了一组映射器(mapper),这些映射器的 XML 映射文件包含了 SQL 代码和映射定义信息。-->
<!-- 每一个Mapper.xml都需要在mybatis核心配置文件中注册 -->
所以我们进行相应的配置,新建一个makerMybatis.xml,让它与我们相应的接口对接
然后我们要去编写mybatis的工具类去获取salsession对象
代码如下:
package utils;
import com.sun.deploy.model.Resource;
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 java.io.IOException;
import java.io.InputStream;
public class Mybatisutil {
public static SqlSessionFactory build;
static {
String resource = "Mybatis.xml";
try {
InputStream inputStream = Resources.getResourceAsStream(resource);
build = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
return build.openSession();
}
}
2.进行实体类,接口,接口对应的xml文件的编写
接口如下:
实体类:
配置的xml文件:
***这里要注意语法的编写,不能有一点点偏差,本人在这遇到过坑5555555***
3.测试类的编写
我的代码如下:
public class Test {
@org.junit.Test
public void gets(){
SqlSession session = null;
try {
session= Mybatisutil.getSqlSession();
UserMapper userMapper=session.getMapper(UserMapper.class);
List<Maker> makers=userMapper.selectall();
for(Maker maker: makers)
{
System.out.println(maker);
}
}catch (Exception e)
{
}finally {
if(session!=null)
session.close();
}
}
}
//接下来的方法测试依次类推
完结!!!