From 30b3905e88495611704e356a1d3ced094e2a503d Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 25 Oct 2021 16:56:16 +0800
Subject: [PATCH] 1.登录返回数据修改 2.现场检查接口修改
---
src/main/java/org/springblade/modules/FTP/MysqlCenlint.java | 18 +++++++++++-------
1 files changed, 11 insertions(+), 7 deletions(-)
diff --git a/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java b/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
index 26bd3fb..d6fd9aa 100644
--- a/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
+++ b/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
@@ -7,6 +7,9 @@
import java.sql.PreparedStatement;
import java.sql.SQLException;
+import static org.springblade.common.config.FtpConfig.localPath;
+import static org.springblade.common.config.FtpConfig.sqlConnect;
+
public class MysqlCenlint {
/**
@@ -17,8 +20,8 @@
try {
int ColumnCount;
//int RowCount;
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://223.82.109.183:2083/zhba"; //换成要连接的数据库信息
+ String driver = "com.mysql.cj.jdbc.Driver";
+ String url = sqlConnect; //换成要连接的数据库信息
String user = "root";
String password = "zhba0728";
Class.forName ( driver );
@@ -26,6 +29,7 @@
if (!conn.isClosed ()) {
System.out.println ( "数据库连接成功：" );
String sqls = sql; //sql
+ System.out.println("sqls = " + sqls);
PreparedStatement ps = conn.prepareStatement ( sqls );
boolean execute = ps.execute();
ps.close ();
@@ -46,8 +50,8 @@
try {
int ColumnCount;
//int RowCount;
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://223.82.109.183:2083/zhba"; //换成要连接的数据库信息
+ String driver = "com.mysql.cj.jdbc.Driver";
+ String url = sqlConnect; //换成要连接的数据库信息
String user = "root";
String password = "zhba0728";
Class.forName ( driver );
@@ -75,8 +79,8 @@
try {
int ColumnCount;
//int RowCount;
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://223.82.109.183:2083/zhba"; //换成要连接的数据库信息
+ String driver = "com.mysql.cj.jdbc.Driver";
+ String url = sqlConnect; //换成要连接的数据库信息
String user = "root";
String password = "zhba0728";
Class.forName ( driver );
@@ -109,7 +113,7 @@
* 删除本地文件
*/
public static void deletess(String fileName){
- File file = new File("D:\\anbao\\"+fileName);
+ File file = new File(localPath+fileName);
if (file.isFile() && file.exists()) {
file.delete();
}
--
Gitblit v1.9.3