From 2ebca060a47784db76369a4aa84f63293da9be33 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 16 Jun 2022 10:08:08 +0800
Subject: [PATCH] 保安员新增同步编号问题
---
src/main/java/org/springblade/modules/FTP/MysqlCenlint.java | 11 +++++------
1 files changed, 5 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 3a5cbe8..33f5ab9 100644
--- a/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
+++ b/src/main/java/org/springblade/modules/FTP/MysqlCenlint.java
@@ -17,8 +17,7 @@
import java.sql.SQLException;
import java.util.Date;
-import static org.springblade.common.config.FtpConfig.localPath;
-import static org.springblade.common.config.FtpConfig.sqlConnect;
+import static org.springblade.common.config.FtpConfig.*;
@Component
public class MysqlCenlint {
@@ -45,15 +44,15 @@
public static void sqlConnect(String sql,Integer type){
String driver = "com.mysql.cj.jdbc.Driver";
String url = sqlConnect; //换成要连接的数据库信息
- String user = "root";
- String password = "zhba0728";
+ String user = sqlUsername;
+ String password = sqlPassword;
Connection conn = null;
PreparedStatement ps = null;
try {
Class.forName ( driver );
- conn = (Connection) DriverManager.getConnection ( url, user, password );
+ conn = DriverManager.getConnection ( url, user, password );
if (!conn.isClosed ()) {
- System.out.println ( "数据库连接成功：" );
+// System.out.println ( "数据库连接成功：" );
String sqls = sql;
ps = conn.prepareStatement ( sqls );
//判断是否为修改，删除
--
Gitblit v1.9.3