JDBC 컬럼이름은 출력되는데 안에 값들이 안보입니다
-
게시물 수정 , 삭제는 로그인 필요
import oracle.sql.ORAData;
import java.sql.*;
public class Jdbc {
public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:xe";
String user="ORA";
String pwd="1234";
Connection con = null;
PreparedStatement pstmt = null;
String sql;
ResultSet rs = null;
ResultSetMetaData rsmd;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pwd);
sql = "SELECT * FROM employee";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
for (int i = 1; i <= cols; i++) {
System.out.println(rsmd.getColumnName(i));
}
System.out.println();
while (rs.next()) {
for(int i = 1; i <= cols; i++)
System.out.print(rs.getObject(i));
System.out.println();
}
rs.close();
pstmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
실행은 잘되는데 결과값을 보면 컬럼 이름만 보입니다..
import oracle.sql.ORAData;
import java.sql.*;
public class Jdbc {
public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:xe";
String user="ORA";
String pwd="1234";
Connection con = null;
PreparedStatement pstmt = null;
String sql;
ResultSet rs = null;
ResultSetMetaData rsmd;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pwd);
sql = "SELECT * FROM employee";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
for (int i = 1; i <= cols; i++) {
System.out.println(rsmd.getColumnName(i));
}
System.out.println();
while (rs.next()) {
for(int i = 1; i <= cols; i++)
System.out.print(rs.getObject(i));
System.out.println();
}
rs.close();
pstmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
![](https://img-api.cboard.net/img_n.php?image_url=https://kin-phinf.pstatic.net/20220514_282/16525190727915qJ15_PNG/jdbc.png)