扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

java鎬庝箞鑾峰彇鏁版嵁搴撳厓鏁版嵁

扬州沐宇科技
2023-09-27 09:24:04
Java, 鏁版嵁搴?/a>

鍦↗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>

扫码添加客服微信