資源簡介
獲取表的結構,無論是任何數據庫,只要把驅動包加進去就可以了。
代碼片段和文件信息
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
public?class?DatabaseStruct?{
private?final?String?DRIVER?=?“oracle.jdbc.driver.OracleDriver“;
private?final?String?URI?=?“jdbc:oracle:thin:@192.168.1.6:1521:orcl“;
private?final?String?NAME?=?“xcww“;
private?final?String?PASSWORD?=?“1“;
private?Connection?conn?=?null?;
private?PreparedStatement?pstmt?=?null?;
private?ResultSet?rs?=?null?;
private?ResultSetmetaData?rsm?=?null?;
public?static?void?main(String[]?args)?{
DatabaseStruct?dbs?=?new?DatabaseStruct();
dbs.getT
評論
共有 條評論