使用mybatis

最新推荐文章于 2025-08-22 13:45:39 发布

weixin_33884611

最新推荐文章于 2025-08-22 13:45:39 发布

阅读量78

点赞数

CC 4.0 BY-SA版权

文章标签： java 数据库 python

原文链接：https://my.oschina.net/u/3100849/blog/3054729

2019独角兽企业重金招聘Python工程师标准>>>

1.引入依赖

		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.0.0</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>

2.添加数据源配置

在application.properties文件中添加数据库配置

spring.datasource.url=jdbc:mysql://192.168.0.112:3306/secms_ods?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

Spring Boot 会自动加载 spring.datasource.* 相关配置，数据源就会自动注入到 sqlSessionFactory 中，sqlSessionFactory 会自动注入到 Mapper 中。

3.数据层编码

public interface SysUserMapper {

	User findUserByName(String userName);
}

mapper文件：SysUserMapper.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" >
<mapper namespace="com.jiafeng.dao.SysUserMapper">
	<resultMap id="result" type="com.jiafeng.domain.User">
		<id property="id" column="user_id" />
		<result property="userName" column="user_name" />
		<result property="passWord" column="password" />
	</resultMap>
	
	<select id="findUserByName" resultMap="result" parameterType="string">
		SELECT user_id,user_name,`password` FROM `user` WHERE user_name=#{userName}
	</select>

</mapper>

添加mybatis基础配置：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>
    <typeAliases>
        <typeAlias alias="Integer" type="java.lang.Integer" />
        <typeAlias alias="Long" type="java.lang.Long" />
        <typeAlias alias="HashMap" type="java.util.HashMap" />
        <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" />
        <typeAlias alias="ArrayList" type="java.util.ArrayList" />
        <typeAlias alias="LinkedList" type="java.util.LinkedList" />
    </typeAliases>
</configuration>

在application.properties中配置加载mapper文件

mybatis.config-location=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

在启动类中增加@MapperScan扫描配置mapper类路径

@SpringBootApplication
@ServletComponentScan
@MapperScan("com.jiafeng.dao")
public class Application {

	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}

}

至此可以在service层调用数据层房屋数据库。

转载于:https://my.oschina.net/u/3100849/blog/3054729