From a65e232e93762ad414ef6a9d144c967993f14c3a Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Fri, 20 Aug 2021 09:40:59 +0800
Subject: [PATCH] 1.用户
---
src/main/java/org/springblade/common/utils/MysqlCenlint.java | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 58 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/common/utils/MysqlCenlint.java b/src/main/java/org/springblade/common/utils/MysqlCenlint.java
index d593980..550cca0 100644
--- a/src/main/java/org/springblade/common/utils/MysqlCenlint.java
+++ b/src/main/java/org/springblade/common/utils/MysqlCenlint.java
@@ -39,6 +39,64 @@
}
/**
+ * 连接mysql数据库 修改
+ * @param sql
+ */
+ public static void update(String sql) {
+ 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";
+ Class.forName ( driver );
+ Connection conn = (Connection) DriverManager.getConnection ( url, user, password );
+ if (!conn.isClosed ()) {
+ System.out.println ( "数据库连接成功：" );
+ String sqls = sql; //sql
+ PreparedStatement ps = conn.prepareStatement ( sqls );
+ ps.executeUpdate();
+ ps.close ();
+ conn.close ();
+ }
+ } catch (ClassNotFoundException e) {
+ e.printStackTrace ();
+ } catch (SQLException e) {
+ e.printStackTrace ();
+ }
+ }
+
+ /**
+ * 连接mysql数据库 删除
+ * @param sql
+ */
+ public static void delete(String sql) {
+ 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";
+ Class.forName ( driver );
+ Connection conn = (Connection) DriverManager.getConnection ( url, user, password );
+ if (!conn.isClosed ()) {
+ System.out.println ( "数据库连接成功：" );
+ String sqls = sql; //sql
+ PreparedStatement ps = conn.prepareStatement ( sqls );
+ ps.executeUpdate();
+ ps.close ();
+ conn.close ();
+ }
+ } catch (ClassNotFoundException e) {
+ e.printStackTrace ();
+ } catch (SQLException e) {
+ e.printStackTrace ();
+ }
+ }
+
+ /**
* 删除本地文件
*/
public static void delete(){
--
Gitblit v1.9.3