JDBC.java ~~~ package zyw.tools; import java.io.IOException; import java.io.InputStream; import java.sql.*; import java.util.Properties; public class JDBC { private static String driver;//快捷鍵Ctrl+Art+f private static String url; private static String username; private static String password; static { try { ClassLoader classLoader = JDBC.class.getClassLoader(); InputStream resourceAsStream = classLoader.getResourceAsStream("db.properties"); Properties properties=new Properties(); properties.load(resourceAsStream); driver = properties.getProperty("driver"); url = properties.getProperty("url"); username = properties.getProperty("username"); password = properties.getProperty("password"); } catch (IOException e) { e.printStackTrace(); } } public static Connection getConnection() { Connection connection = null; //注冊驅動，獲取連接 try { /* Class.forName("com.mysql.jdbc.Driver"); String url="jdbc:mysql://122.14.200.136:3306/javadb"; connection = DriverManager.getConnection(url, "root", "6a133f0024");*/ Class.forName(driver); connection = DriverManager.getConnection(url, username, password); } catch (Exception e) { e.printStackTrace(); } return connection; } public static void release(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet) { //釋放資源 if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { e.printStackTrace(); } } if (preparedStatement != null) { try { preparedStatement.close(); } catch (SQLException e) { e.printStackTrace(); } } if (connection != null) { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } } } ~~~ 調用方法 ~~~ Connection connection =JDBC.getConnection(); JDBC.release(connection,preparedStatement,resultSet); ~~~ db.properties文件放在src目錄下 ~~~ driver=com.mysql.jdbc.Driver url=jdbc:mysql://122.14.200.136:3306/javadb username=root password=xxx ~~~