數據庫連接

2019-11-08 03:06:49

字體：大中小

來源：轉載

供稿：網友

package org.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class MySQLConnection {PRivate static final String Url = "jdbc:mysql://127.0.0.1:3306/test";// MySql的連接地址private static final String UserName = "root";// MySql的用戶名private static final String PassWord = "1234";// MySql的密碼// <1>獲取數據庫連接資源public Connection getConnection() {Connection conn = null;try {Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection(Url, UserName, PassWord);} catch (Exception e) {System.out.println("<===連接數據庫失敗===>" + e);e.printStackTrace();}return conn;}// <2>關閉數據庫連接public void close(Connection conn) {if (conn != null) {try {conn.close();} catch (SQLException e) {System.out.println("<===關閉數據庫連接失敗===>" + e);e.printStackTrace();}}}// <3>關閉數據庫描述public void close(Statement ps) {if (ps != null) {try {ps.close();} catch (SQLException e) {System.out.println("<===關閉數據庫描述失敗===>" + e);e.printStackTrace();}}}// <4>關閉數據庫結果集public void close(ResultSet rs) {if (rs != null) {try {rs.close();} catch (SQLException e) {System.out.println("<===關閉數據庫結果集失敗===>" + e);e.printStackTrace();}}}}

上一篇：打印"*"等腰三角形

下一篇：c語言指針鏈表