springboot mybatis 连接mysql

最新推荐文章于 2024-01-23 18:19:22 发布

转载最新推荐文章于 2024-01-23 18:19:22 发布 · 122 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/zk875/blog/827764

文章标签：

#数据库 #java #json

1、添加pom依赖

        <!-- Mybatis -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.2.0</version>
		</dependency>
        <!-- MYSQL -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

2、创建接口Mapper（不是类）和对应的Mapper.xml文件

如果习惯了springmvc的话，那么他就是对应的dao层

UserDao.java

@Mapper
public interface UserDao {
	
	/**
	 * findOne
	 * @param id
	 * @return
	 */
	@Select(value="select *from boot_user where id=#{id}")
	UserInfo findOne(int id);

	/**
	 * findAll
	 * @return
	 */
	List<UserInfo> findAll();
}

UserDao.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.zk.dao.UserDao">

    <!-- findAll -->
    <select id="findAll" resultType="UserInfo">
        select * from boot_user
    </select>
</mapper>

3、实体类

public class UserInfo implements Serializable {
	private static final long serialVersionUID = 6519997700281088880L;
	
	private int id;
	
	private String name;
	
	private String tel;
	
	@JSONField(format="yyyy-MM-dd")
	private Date createTime;
setter getter省略
}

4、修改application.properties 配置文件

#mybatis
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.type-aliases-package=com.zk.domain

#DATASOURCE
#初始化数据
spring.datasource.schema=classpath:init-sql/schema.sql
#换链接池，默认是tomcat的连接池
#spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#高版本mysql需要指定useSSL
spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=true
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

5、在Controller或Service调用方法测试

    @ResponseBody
    @RequestMapping("/finduser")
    public String findUser() {
        return JSON.toJSONString(userService.findAll());
    }

效果：

转载于:https://my.oschina.net/zk875/blog/827764