java鎬庝箞鑾峰彇鏁版嵁搴撳厓鏁版嵁
鍦↗ava涓紝鍙互浣跨敤JDBC锛圝ava Database Connectivity锛夋潵鑾峰彇鏁版嵁搴撶殑鍏冩暟鎹€備互涓嬫槸涓€浜涚ず渚嬩唬鐮侊紝婕旂ず濡備綍鑾峰彇鏁版嵁搴撳厓鏁版嵁锛?br/>
```java
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DatabaseMetadataExample {
public static void main(String[] args) {
try {
// 鍒涘缓鏁版嵁搴撹繛鎺?br/>
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
// 鑾峰彇鏁版嵁搴撳厓鏁版嵁
DatabaseMetaData metadata = conn.getMetaData();
// 鑾峰彇鏁版嵁搴撲骇鍝佸悕绉?br/>
String databaseProductName = metadata.getDatabaseProductName();
System.out.println("Database Product Name: " + databaseProductName);
// 鑾峰彇鏁版嵁搴撶増鏈?br/>
String databaseProductVersion = metadata.getDatabaseProductVersion();
System.out.println("Database Product Version: " + databaseProductVersion);
// 鑾峰彇鍙敤鐨勬暟鎹簱琛?br/>
ResultSet tables = metadata.getTables(null, null, null, new String[]{"TABLE"});
while (tables.next()) {
String tableName = tables.getString("TABLE_NAME");
System.out.println("Table Name: " + tableName);
}
// 鍏抽棴杩炴帴
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
涓婅堪浠g爜棣栧厛鍒涘缓浜嗕竴涓暟鎹簱杩炴帴锛岀劧鍚庝娇鐢ㄨ杩炴帴鑾峰彇浜嗘暟鎹簱鐨勫厓鏁版嵁銆傞€氳繃璋冪敤鍏冩暟鎹璞$殑鏂规硶锛屽彲浠ヨ幏鍙栨暟鎹簱浜у搧鍚嶇О銆佺増鏈紝浠ュ強鍙敤鐨勬暟鎹簱琛ㄧ瓑淇℃伅銆傛渶鍚庯紝杩炴帴琚叧闂€傝鏍规嵁瀹為檯鎯呭喌淇敼杩炴帴瀛楃涓层€佺敤鎴峰悕鍜屽瘑鐮併€?/p>
相关问答