From 30df94c05573a426d030510d4dd58ae1d93bfb7a Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Mon, 06 Dec 2021 14:03:37 +0800
Subject: [PATCH] 1.资格审查排序
---
src/main/java/org/springblade/modules/FTP/MysqlCenlint.java | 24 ++++++++++++++++++------
1 files changed, 18 insertions(+), 6 deletions(-)
diff --git a/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java b/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
index fe1f72c..0b0493f 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.constant.FtpConstant.localPath;
+import static org.springblade.common.constant.FtpConstant.sql_connect_dev;
+
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 = sql_connect_dev; //换成要连接的数据库信息
String user = "root";
String password = "zhba0728";
Class.forName ( driver );
@@ -46,8 +49,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 = sql_connect_dev; //换成要连接的数据库信息
String user = "root";
String password = "zhba0728";
Class.forName ( driver );
@@ -75,8 +78,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 = sql_connect_dev; //换成要连接的数据库信息
String user = "root";
String password = "zhba0728";
Class.forName ( driver );
@@ -105,4 +108,13 @@
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