package com.ltkj.web.controller.system;
|
|
import cn.hutool.core.date.DateUtil;
|
import com.alibaba.fastjson.JSONArray;
|
import com.alibaba.fastjson.JSONObject;
|
import com.ltkj.common.core.controller.BaseController;
|
import com.ltkj.common.core.domain.AjaxResult;
|
import com.ltkj.hosp.domain.TjCustomer;
|
import com.ltkj.hosp.service.ITjCustomerService;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.RestController;
|
|
import javax.annotation.Resource;
|
import java.io.Serializable;
|
import java.sql.ResultSet;
|
import java.sql.ResultSetMetaData;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @Company: 西安路泰科技有限公司
|
* @Author: lige
|
* @Date: 2023/12/13 19:33
|
*/
|
@RestController
|
@RequestMapping("/json/parse")
|
public class JsonController extends BaseController implements Serializable {
|
@Resource
|
private ITjCustomerService tjCustomerService;
|
|
|
/**
|
* 化验检查页面列表
|
*/
|
@GetMapping("/huaYangetProList")
|
@ApiOperation("影像/化验检查页面列表")
|
public AjaxResult huaYangetProList(@RequestParam String deptId,
|
@RequestParam(defaultValue = "1") Integer page,
|
@RequestParam(defaultValue = "10") Integer pageSize,
|
@RequestParam String cusName,
|
@RequestParam String tjNumber) {
|
return AjaxResult.success(tjCustomerService.getJsonParseCustomerList(deptId, page, pageSize, cusName, tjNumber));
|
}
|
|
|
/**
|
* 将结果集信息转换为JSON数组的形式
|
*
|
* @param rs sql语句查询出来的结果集
|
* @return 返回一个JSON数组
|
* @throws Exception
|
*/
|
public static JSONArray formatRsToJsonArray(ResultSet rs) throws Exception {
|
ResultSetMetaData md = rs.getMetaData();
|
int num = md.getColumnCount();
|
JSONArray array = new JSONArray();
|
while (rs.next()) {
|
JSONObject mapOfColValues = new JSONObject();
|
for (int i = 1; i <= num; i++) {
|
Object o = rs.getObject(i);
|
mapOfColValues.put(md.getColumnName(i), rs.getObject(i));
|
}
|
array.add(mapOfColValues);
|
}
|
return array;
|
}
|
|
}
|
