-- 컬럼수 조회 

import java.sql.*;

try{
       String driver = "oracle.jdbc.driver.OracleDriver";
       String url = "jdbc:oracle:thin:@localhost:1521:ORCL";

       Class.forName(driver);
       Connection conn = DriverManager.getConnection(url, "userid", "passwd");

       String Qry=" select * from ab";

       Statement Stmt = conn.createStatement();
       ResultSet Rs = Stmt.ExecuteQuery(Qry);

 

//**** 컬럼 갯수를 알고싶을때
       ResultSetMetaData Rsmd = Rs.getMetaData();

       int ColumnCount=Rsmd.getColumnCount();

//****

 

}catch(Exception e){
       e.printStackTrace()
}


+ Recent posts