From 52fcdf0dff15b882024581cb393fbcbe70f29148 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 22 Oct 2021 09:26:33 +0800
Subject: [PATCH] 出资人，主要管理人修改，新增字段 dept_id 修改保安公司绑定
---
src/main/java/org/springblade/modules/FTP/MysqlCenlint.java | 25 +++++++++++++++++++------
1 files changed, 19 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..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 );
@@ -105,4 +109,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