From 8853292babb2ad94de4a3207966f1e83b767cd2d Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Sun, 17 Sep 2023 16:38:34 +0800
Subject: [PATCH] 新增流程节点进程查询接口
---
src/main/java/org/springblade/modules/FTP/MysqlCenlint.java | 51 +++++++++++++++++++++++++++++++++------------------
1 files changed, 33 insertions(+), 18 deletions(-)
diff --git a/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java b/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
index 86f4a22..51f2b9a 100644
--- a/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
+++ b/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
@@ -1,11 +1,16 @@
package org.springblade.modules.FTP;
+import org.springblade.common.config.DataSyncConfig;
+import org.springblade.common.config.FtpConfig;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
+
+import static org.springblade.common.config.FtpConfig.localPath;
+
public class MysqlCenlint {
@@ -17,15 +22,17 @@
try {
int ColumnCount;
//int RowCount;
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://223.82.109.183:2083/zhba"; //换成要连接的数据库信息
- String user = "root";
- String password = "zhba0728";
+ String driver = DataSyncConfig.driver;
+ //换成要连接的数据库信息
+ String url = DataSyncConfig.url;
+ String user = DataSyncConfig.username;
+ String password = DataSyncConfig.password;
Class.forName ( driver );
Connection conn = (Connection) DriverManager.getConnection ( url, user, password );
if (!conn.isClosed ()) {
System.out.println ( "数据库连接成功：" );
- String sqls = sql; //sql
+ //sql
+ String sqls = sql;
PreparedStatement ps = conn.prepareStatement ( sqls );
boolean execute = ps.execute();
ps.close ();
@@ -46,10 +53,11 @@
try {
int ColumnCount;
//int RowCount;
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://223.82.109.183:2083/zhba"; //换成要连接的数据库信息
- String user = "root";
- String password = "zhba0728";
+ String driver = DataSyncConfig.driver;
+ //换成要连接的数据库信息
+ String url = DataSyncConfig.url;
+ String user = DataSyncConfig.username;
+ String password = DataSyncConfig.password;
Class.forName ( driver );
Connection conn = (Connection) DriverManager.getConnection ( url, user, password );
if (!conn.isClosed ()) {
@@ -75,10 +83,11 @@
try {
int ColumnCount;
//int RowCount;
- String driver = "com.mysql.jdbc.Driver";
- String url = "jdbc:mysql://223.82.109.183:2083/zhba"; //换成要连接的数据库信息
- String user = "root";
- String password = "zhba0728";
+ String driver = DataSyncConfig.driver;
+ //换成要连接的数据库信息
+ String url = DataSyncConfig.url;
+ String user = DataSyncConfig.username;
+ String password = DataSyncConfig.password;
Class.forName ( driver );
Connection conn = (Connection) DriverManager.getConnection ( url, user, password );
if (!conn.isClosed ()) {
@@ -96,11 +105,17 @@
}
}
- /**
- * 删除本地文件
- */
- public static void delete(){
- File file = new File("D:\\anbao\\sql.json");
+// /**
+// * 删除本地文件
+// */
+// public static void deletes(String fileName){
+// File file = new File("D:\\"+fileName);
+// if (file.isFile() && file.exists()) {
+// file.delete();
+// }
+// }
+ public static void deletess(String fileName){
+ File file = new File(localPath+fileName);
if (file.isFile() && file.exists()) {
file.delete();
}
--
Gitblit v1.9.3