1.配置文件版
先看一下项目目录
引入项目相关依赖(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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.4.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>demo</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
application配置文件
#mysql驱动
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
#驱动路径,关联相关的数据库
spring.datasource.url =jdbc:mysql://localhost:3306/myemployees?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Hongkong
#数据库账号
spring.datasource.username = root
#数据库密码
spring.datasource.password = 123
#驼峰匹配原则 如果不加这句,xml文件里的resulttype就不会生效,因为和数据库列名和javabean属性名不一样
mybatis.configuration.map-underscore-to-camel-case=true
#扫描resources文件夹下的mapper包里的xml文件
mybatis.mapper-locations=classpath:mapper/*.xml
#扫描实体类 必须加
mybatis.type-aliases-package=com.example.demo.entity
数据库相关的表,我用的是jobs这张表,表内容如下
项目实体类,这个要根据数据库对应的表来设计
package com.example.demo.entity;
import lombok.Data;
import java.io.Serializable;
/**
* Created by 张靖奇 on 2020/1/31 19:10
*/
@Data
public class jobs implements Serializable {
private static final long serialVersionUID = 8655851615465363473L;
private String jobId;
private String jobTitle;
private int minSalary;
private int maxSalary;
}
mapper层
package com.example.demo.mapper;
/**
* Created by 张靖奇 on 2020/1/31 21:09
*/
import com.example.demo.entity.jobs;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;
//@Mapper,不加也可以,最好在启动类用mapperscan扫描
@Repository//如果不加这个注解service层会有警告
public interface jobsmapper {
/*
和配置文件中开启驼峰匹配规则作用相同,配置文件开启了驼峰匹配原则就不需要加这个了,其中column是表中列的名字,property是实体类属性名
@Results(
{@Result(column = "job_id",property = "jobId"),
@Result(column = "job_title",property = "jobTitle"),
@Result(column = "min_salary",property = "minSalary"),
@Result(column = "max_salary",property = "maxSalary")
}
)
*/
public List<jobs> getMyemployees (@Param("jobId") String jobId);
}
mapper.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.example.demo.mapper.jobsmapper"> <!--将这个接口指向对应的实现类,在接口中引入方法,和com.attendance.mapper.VocationMapper相对应-->
<resultMap type="com.example.demo.entity.jobs" id="getjobsmap">
<id column="job_id" property="jobId" />
<result column="job_title" property="jobTitle"/>
<result column="min_salary" property="minSalary" />
<result column="max_salary" property="maxSalary" />
</resultMap>
<select id="getMyemployees" parameterType="java.lang.String" resultType="jobs"> <!--用resultmap也可以-->
select * from jobs where job_id=#{jobId}
</select>
</mapper>
特别注意select中的几个参数,id为mapper中查询方法的名字。parameterType为查询方法中的参数类型。resultType为返回类型,我们要返回实体类jobs,所以值为jobs,因为开启了驼峰匹配原则所以不必担心数据库列名称和属性名称不统一,项目会自动帮我们映射的。当然也可以用resultmap,在xml文件中我已经写好了映射关系,所以用resultmap就不用在配置文件中开启驼峰匹配原则了
service层
package com.example.demo.service;
/**
* Created by 张靖奇 on 2020/1/31 21:10
*/
import com.example.demo.entity.jobs;
import com.example.demo.mapper.jobsmapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* Created by 张靖奇 on 2020/1/31 19:23
*/
@Service//代表处理业务逻辑层
public class jobsservice {
@Autowired//将mapper层注入,必须加
jobsmapper mapper;
public List<jobs> getMyemployees (String jobId){
return mapper.getMyemployees(jobId);
}
}
controller层
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
* Created by 张靖奇 on 2020/1/31 19:30
*/
@RestController
@RequestMapping
public class jobscontorller {
@Autowired//将service层自动注入
jobsservice jobsservice;
@GetMapping("/select/{jobId}")
public List<jobs> getMyemployees (@PathVariable("jobId") String jobId)
{ Logger r= LoggerFactory.getLogger(jobscontorller.class);
r.info("zzz");
return jobsservice.getMyemployees(jobId);
}
}
下面我们看看测试结果,在网页中输入http://localhost:8080/select/SA_REP
运行结果
数据库的内容就可以查出来了。谢谢浏览,记得点个赞哦!不懂的也可以在下面留言。