API 接口参考:http://jvm123.com/2020/08/spring-zhong-shi.html
pom.xml 文件:
org.elasticsearch.client
elasticsearch-rest-high-level-client
7.13.3
yml文件:
# 开发环境数据源配置
spring:
elasticsearch:
rest:
uris: http://192.168.1.198:9200
datasource:
type: com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
druid:
# 主库数据源
master:
url: jdbc:mysql://rm-uf658ly8804f04r25ro.mysql.rds.aliyuncs.com:3306/realize-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
username: root
password: 123456
# 从库数据源
slave:
# 从数据源开关/默认关闭
enabled: false
url:
username:
password:
# 初始连接数
initialSize: 5
# 最小连接池数量
minIdle: 10
# 最大连接池数量
maxActive: 20
# 配置获取连接等待超时的时间
maxWait: 60000
# 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
timeBetweenEvictionRunsMillis: 60000
# 配置一个连接在池中最小生存的时间,单位是毫秒
minEvictableIdleTimeMillis: 300000
# 配置一个连接在池中最大生存的时间,单位是毫秒
maxEvictableIdleTimeMillis: 900000
# 配置检测连接是否有效
validationQuery: SELECt 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
webStatFilter:
enabled: true
statViewServlet:
enabled: true
# 设置白名单,不填则允许所有访问
allow:
url-pattern: /druid
@RestController
@Transactional(rollbackFor = Exception.class)
@RequestMapping("/system/SysESLawsAndRegulationsController")
public class SysESLawsAndRegulationsController extends EsbaseController {
@Autowired
ISysESLawsAndRegulationsService ISysESLawsAndRegulationsService;
@Autowired
ILawsAndRegulationsService iLawsAndRegulationsService;
@GetMapping("/a")
public String a() {
return "a";
}
//删除索引
@GetMapping("/deleteIndex")
public Boolean deleteIndex() {
return iLawsAndRegulationsService.deleteIndex();
}
//创建索引,存入数据
@GetMapping("/create")
public Boolean create() throws IOException {
return iLawsAndRegulationsService.esTest();
}
@GetMapping("/getESLawsAndRegulations")
public TableDataInfo getText(String marketNum,
String incentiveNum,
String enterpriseNum,
String title,
String fullText,
Integer thevalidity,
Integer pageNum,
Integer pageSize
) throws IOException {
// System.out.println("参数"+marketNum +","+ incentiveNum +","+ enterpriseNum +","+title +","+fullText +","+thevalidity);
// System.out.println("分页:"+pageNum+","+pageSize);
List