配置文件
server:
port: 80
mybatis:
mapper-locations: classpath:mapping/*.xml # 指定mapper文件的位置
type-aliases-package: com.mason.pojo # 指定要指定别名的包,此包中所有类首字母小写作为别名,这样mapper文件中就省事一点
spring:
datasource:
druid:
password: 1234
username: root
url: jdbc:mysql://localhost:3306/mason_blog?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
driver-class-name: com.mysql.cj.jdbc.Driver
thymeleaf:
cache: false # 关闭缓存
#设置日志级别
logging:
level:
root: info
com.mason: debug
创建dao层接口
package com.mason.dao;
import com.mason.pojo.User;
import org.springframework.data.repository.query.Param;
public interface UserDao {
public User findUser(@Param("username") String username,
@Param("password") String password);
}
创建mapper文件
<?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.mason.dao.UserDao">
<select id="findUser" parameterType="String" resultType="User">
select * from t_user where username=#{username} and password=#{password} limit 0,1
</select>
</mapper>
主函数加上扫描注解@MapperScan(“com.mason.dao”)
@SpringBootApplication
@MapperScan("com.mason.dao")
public class MasonBlogApplication {
public static void main(String[] args) {
SpringApplication.run(MasonBlogApplication.class, args);
}
}