第一个Mybatis程序
1.搭建环境
搭建数据库base_role
新建项目
-
新建一个maven项目
-
删除src目录
-
导入maven依赖
<!--导入依赖--> <dependencies> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-generator</artifactId> <version>3.4.1</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.37</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> </dependencies> <!-- 在build中配置resources,来防止资源导出失败的问题--> <build> <resources> <resource> <!-- 设定主资源目录 --> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> </resource> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>true</filtering> </resource> </resources> </build>
2.创建一个模块
- 创建db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/briup-ej?useSSL=false&useUnicode=true&characterEncoding=UTF-8
username=root
password=root
-
配置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 resource="db.properties"/> <!-- 别名--> <typeAliases> <typeAlias type="com.pojo.UserRole" alias="userRole"></typeAlias> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/dao/UserRoleMapper.xml"/> </mappers> </configuration>
-
编写Mybatis工具类
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
try {
//使用Mybatis第一步:获取sqlSessionFactory对象
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();
}
}
3.编写代码
- 实体类
package com.pojo;
public class UserRole {
private Long id;
private String name;
public UserRole() {
}
public UserRole(Long id, String name) {
this.id = id;
this.name = name;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public String toString() {
return "UserRole{" +
"id=" + id +
", name='" + name + '\'' +
'}';
}
}
-
Mapper接口
package com.dao; import com.pojo.UserRole; import java.util.List; public interface UserRoleMapper { List<UserRole> getUserRoleList(); }
-
接口实现类
<?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.dao.UserRoleMapper">
<select id="getUserRoleList" resultType="userRole">
select * from base_role
</select>
</mapper>
4.测试
- junit测试
public class UserRoleMapperTest {
@Test
public void test(){
//获得SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();//ctrl+alt+v快速生成返回值
//执行SQL
UserRoleMapper mapper = sqlSession.getMapper(UserRoleMapper.class);
List<UserRole> userRoleList = mapper.getUserRoleList();
for (UserRole userRole : userRoleList) {
System.out.println(userRole);
}
sqlSession.close();
}
}
5.测试完成
结果