package com.controller;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import com.alibaba.fastjson.JSON;
import com.utils.StringUtil;
import org.apache.commons.lang3.StringUtils;
import org.json.JSONObject;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.util.ResourceUtils;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.annotation.IgnoreAuth;
import com.baidu.aip.face.AipFace;
import com.baidu.aip.face.MatchRequest;
import com.baidu.aip.util.Base64Util;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.entity.ConfigEntity;
import com.service.CommonService;
import com.service.ConfigService;
import com.utils.BaiduUtil;
import com.utils.FileUtil;
import com.utils.R;
/**
* 通用接口
*/
@RestController
public class CommonController {
private static final Logger logger = LoggerFactory.getLogger(CommonController.class);
@Autowired
private CommonService commonService;
/**
* Java代码实现MySQL数据库导出
*
* @param mysqlUrl MySQL安装路径
* @param hostIP MySQL数据库所在服务器地址IP
* @param userName 进入数据库所需要的用户名
* @param hostPort 数据库端口
* @param password 进入数据库所需要的密码
* @param savePath 数据库文件保存路径
* @param fileName 数据库导出文件文件名
* @param databaseName 要导出的数据库名
* @return 返回true表示导出成功,否则返回false。
*/
@IgnoreAuth
@RequestMapping("/beifen")
public R beifen(String mysqlUrl, String hostIP, String userName, String hostPort, String password, String savePath, String fileName, String databaseName) {
File saveFile = new File(savePath);
if (!saveFile.exists()) {// 如果目录不存在
saveFile.mkdirs();// 创建文件夹
}
if (!savePath.endsWith(File.separator)) {
savePath = savePath + File.separator;
}
PrintWriter printWriter = null;
BufferedReader bufferedReader = null;
try {
Runtime runtime = Runtime.getRuntime();
String cmd = mysqlUrl + "mysqldump -h" + hostIP + " -u" + userName + " -P" + hostPort + " -p" + password + " " + databaseName;
runtime.exec(cmd);
Process process = runtime.exec(cmd);
InputStreamReader inputStreamReader = new InputStreamReader(process.getInputStream(), "utf8");
bufferedReader = new BufferedReader(inputStreamReader);
printWriter = new PrintWriter(new OutputStreamWriter(new FileOutputStream(savePath + fileName), "utf8"));
String line;
while ((line = bufferedReader.readLine()) != null) {
printWriter.println(line);
}
printWriter.flush();
} catch (Exception e) {
e.printStackTrace();
return R.error("备份数据出错");
} finally {
try {
if (bufferedReader != null) {
bufferedReader.close();
}
if (printWriter != null) {
printWriter.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
return R.ok();
}
/**
* Java实现MySQL数据库导入
*
* @param mysqlUrl MySQL安装路径
* @param hostIP MySQL数据库所在服务器地址IP
* @param userName 进入数据库所需要的用户名
* @param hostPort 数据库端口
* @param password 进入数据库所需要的密码
* @param savePath 数据库文件保存路径
* @param fileName 数据库导出文件文件名
* @param databaseName 要导出的数据库名
*/
@IgnoreAuth
@RequestMapping("/huanyuan")
public R huanyuan(String mysqlUrl, String hostIP, String userName, String hostPort, String password, String savePath, String fileName, String databaseName) {
try {
Runtime rt = Runtime.getRuntime();
Process child1 = rt.exec(mysqlUrl+"mysql.exe -h" + hostIP + " -u" + userName + " -P" + hostPort + " -p" + password + " " + databaseName);
OutputStream out = child1.getOutputStream();//控制台的输入信息作为输出流
String inStr;
StringBuffer sb = new StringBuffer("");
String outStr;
BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(savePath+"/"+fileName), "utf-8"));
while ((inStr = br.readLine()) != null) {
sb.append(inStr + "\r\n");
}
outStr = sb.toString();
OutputStreamWriter writer = new OutputStreamWriter(out, "utf8");
writer.write(outStr);
// 注:这里如果用缓冲方式写入文件的话,会导致中文乱码,用flush()方法则可以避免
writer.flush();
out.close();
br.close();
writer.close();
} catch (Exception e) {
e.printStackTrace();
return R.error("数据导入出错");
}
return R.ok();
}
/**
* 饼状图求和
* @return
*/
@RequestMapping("/pieSum")
public R pieSum(@RequestParam Map<String,Object> params) {
logger.debug("饼状图求和:,,Controller:{},,params:{}",this.getClass().getName(),params);
List<Map<String, Object>> result = commonService.pieSum(params);
return R.ok().put("data", result);
}
/**
* 饼状图统计
* @return
*/
@RequestMapping("/pieCount")
public R pieCount(@RequestParam Map<String,Object> params) {
logger.debug("饼状图统计:,,Controller:{},,params:{}",this.getClass().getName(),params);
List<Map<String, Object>> result = commonService.pieCount(params);
return R.ok().put("data", result);
}
/**
* 柱状图求和单列
* @return
*/
@RequestMapping("/barSumOne")
public R barSumOne(@RequestParam Map<String,Object> params) {
logger.debug("柱状图求和单列:,,Controller:{},,params:{}",this.getClass().getName(),params);
List<Map<String, Object>> result = commonService.barSumOne(params);
List<String> xAxis = new ArrayList<>();//报表x轴
List<List<String>> yAxis = new ArrayList<>();//y轴
List<String> legend = new ArrayList<>();//标题
List<String> yAxis0 = new ArrayList<>();
yAxis.add(yAxis0);
legend.add("");
for(Map<String, Object> map :result){
String oneValue = String.valueOf(map.get("name"));
String value = String.valueOf(map.get("value"));
xAxis.add(oneValue);
yAxis0.add(value);
}
Map<String, Object> resultMap = new HashMap<>();
resultMap.put("xAxis",xAxis);
resultMap.put("yAxis",yAxis);
resultMap.put("legend",legend);
return R.ok().put("data", resultMap);
}
/**
* 柱状图统计单列
* @return
*/
@RequestMapping("/barCountOne")
public R barCountOne(@Requ
没有合适的资源?快使用搜索试试~ 我知道了~
基于Sringboot+Vue个人驾校预约管理系统代码.zip
共146个文件
java:145个
xml:1个
需积分: 5 0 下载量 44 浏览量
2024-01-03
12:51:43
上传
评论
收藏 250KB ZIP 举报
温馨提示
基于Sringboot+Vue个人驾校预约管理系统代码.zip
资源推荐
资源详情
资源评论
收起资源包目录
基于Sringboot+Vue个人驾校预约管理系统代码.zip (146个子文件)
CommonController.java 27KB
JiaolianController.java 26KB
YonghuController.java 21KB
JiaolianYuyueController.java 19KB
CheliangYuyueController.java 18KB
CheliangController.java 18KB
ForumController.java 16KB
JiaolianCollectionController.java 15KB
CheliangCollectionController.java 15KB
JiaolianLiuyanController.java 14KB
CheliangLiuyanController.java 13KB
DictionaryController.java 12KB
NewsController.java 12KB
ForumView.java 10KB
JiaolianCollectionView.java 9KB
JiaolianYuyueView.java 9KB
JiaolianEntity.java 9KB
JiaolianLiuyanView.java 9KB
ClazzDiff.java 9KB
CheliangCollectionView.java 8KB
CheliangYuyueView.java 8KB
CheliangLiuyanView.java 7KB
YonghuEntity.java 7KB
JiaolianYuyueEntity.java 7KB
CheliangYuyueEntity.java 7KB
JiaolianVO.java 7KB
ForumEntity.java 7KB
CheliangEntity.java 6KB
JiaolianModel.java 6KB
UsersController.java 6KB
JiaolianLiuyanEntity.java 5KB
CheliangLiuyanEntity.java 5KB
MPUtil.java 5KB
DictionaryServiceImpl.java 5KB
YonghuVO.java 5KB
CheliangYuyueVO.java 5KB
JiaolianYuyueVO.java 5KB
DictionaryEntity.java 5KB
ForumVO.java 5KB
NewsEntity.java 5KB
CheliangVO.java 5KB
YonghuModel.java 5KB
CheliangYuyueModel.java 4KB
JiaolianYuyueModel.java 4KB
CheliangCollectionEntity.java 4KB
JiaolianCollectionEntity.java 4KB
ForumModel.java 4KB
CheliangModel.java 4KB
CheliangLiuyanVO.java 4KB
JiaolianLiuyanVO.java 4KB
BaiduUtil.java 4KB
FileController.java 4KB
PoiUtil.java 4KB
JiaolianLiuyanModel.java 3KB
CheliangLiuyanModel.java 3KB
DictionaryVO.java 3KB
AuthorizationInterceptor.java 3KB
NewsVO.java 3KB
DictionaryModel.java 3KB
NewsModel.java 3KB
CheliangCollectionVO.java 3KB
JiaolianCollectionVO.java 3KB
ConfigController.java 3KB
CheliangCollectionModel.java 3KB
JiaolianCollectionModel.java 3KB
Query.java 3KB
TokenServiceImpl.java 2KB
DictionaryServletContextListener.java 2KB
CommonServiceImpl.java 2KB
TokenEntity.java 2KB
JiaolianView.java 2KB
PageUtils.java 2KB
CheliangView.java 2KB
CommonUtil.java 2KB
NewsView.java 2KB
YonghuView.java 2KB
InterceptorConfig.java 2KB
JiaolianCollectionServiceImpl.java 1KB
CheliangCollectionServiceImpl.java 1KB
JiaolianLiuyanServiceImpl.java 1KB
CheliangLiuyanServiceImpl.java 1KB
CheliangYuyueServiceImpl.java 1KB
JiaolianYuyueServiceImpl.java 1KB
UsersServiceImpl.java 1KB
JiaolianServiceImpl.java 1KB
CheliangServiceImpl.java 1KB
YonghuServiceImpl.java 1KB
ForumServiceImpl.java 1KB
NewsServiceImpl.java 1KB
CommonService.java 1KB
UsersEntity.java 1KB
DictionaryView.java 1KB
CommonDao.java 1KB
SpringContextUtils.java 1KB
ValidatorUtils.java 1KB
SQLFilter.java 1KB
HttpClientUtils.java 1013B
gerenjiaxiaoyuyueguanliApplication.java 951B
ConfigEntity.java 930B
ConfigServiceImpl.java 929B
共 146 条
- 1
- 2
资源评论
JAVA编码选手
- 粉丝: 5005
- 资源: 77
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 学生成绩管理系统c++ (代码).zip
- c语言学生管理系统-项目代码资料.zip
- 课程设计机器学习报告,垃圾分类系统.zip
- app-release.apk.zip
- python-leetcode面试题解之第421题数组中两个数的最大异或值.zip
- python-leetcode面试题解之第416题分割等和子集.zip
- python-leetcode面试题解之第414题第三大的数.zip
- python-leetcode面试题解之第412题Fizz-Buzz.zip
- python-leetcode面试题解之第409题最长回文串.zip
- python-leetcode面试题解之第408题有效单词缩写.zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功