如何在整个JavaMySQL应用程序中使用一个数据库连接对象？

使用单例设计模式。下面是返回单个对象的 Java 代码 -

ConnectDatabase.java

import java.sql.Connection; import java.sql.DriverManager; public class ConnectDatabase { static Connection conn = null; public static Connection getConnection() { if (conn != null) return conn; String database = "test"; String Username = "root"; String password = "123456"; return getConnection(database, Username, password); } private static Connection getConnection(String databaseName, String UserName, String password) { try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost/" + databaseName + "?user=" + UserName + "&password=" + password); } catch (Exception e) { e.printStackTrace(); } return conn; } }登录后复制

CallConnection.java

import java.sql.Connection; public class CallConnection { public static void main(String[] args) { Connection con = ConnectDatabase.getConnection(); if (con != null) { System.out.println("Connection successful !!!"); } } } 登录后复制