在pom.xml引入mysql连接包
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> |
application-data.properties配置
spring.datasource.driver-class-name = com.mysql.jdbc.Driver spring.datasource.url= jdbc:mysql://localhost/operation?useUnicode=yes&characterEncoding=UTF-8&useSSL=false spring.datasource.username = root spring.datasource.password = root spring.jpa.generate-ddl=true spring.jpa.show-sql=true |
application.properties中加data配置
server.port=8084 spring.profiles.active=data |
domian层
public class ParamConfigList { // 设备编号 // 设备id // id // 参数id // 参数类型 // 当前版本 // 配置版本 // 配置状态 // 车站id public ParamConfigList(String id,String param_id, String eui_id, String num, String paramType, String fromParamVerId, public String getNum() { public void setNum(String num) { public String getParamType() { public void setParamType(String paramType) { public String getFromParamVerId() { public void setFromParamVerId(String fromParamVerId) { public String getToParamVerId() { public void setToParamVerId(String toParamVerId) { public String getStatus() { public void setStatus(String status) { public String getEui_id() { public void setEui_id(String eui_id) { public String getParam_id() { public void setParam_id(String param_id) { public String getStationId() { public void setStationId(String stationId) { public String getId() { public void setId(String id) { } |
repository层
package com.gzydt.afc.moduleequipment.domain; import java.util.List; import javax.persistence.EntityManager; import org.springframework.stereotype.Component; @Component @SuppressWarnings("unchecked")
/** * 查找 **/ if (!CommonUtil.isEmtpy(page)) {
} |
service层
@Component
@Autowired
public List<Object> findEquiAndParam(String param_type, String nums, String stationIds, int page, int size) { List<String> stationIdsList = new ArrayList<>();
} |
controller层
@RestController
@Autowired
@GetMapping("list")
} |