Ex14_1.java
package ex14_1;
import java.sql.*;
public class Ex14_1 {
public static void main(String[] args){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@112.169.178.99:1521:xe";
String userid = "JAVA";
String passwd = "JAVA";
try{
Class.forName(driver);
conn = DriverManager.getConnection(url, userid, passwd);
stmt = conn.createStatement();
String query = "select m_id,m_name,m_points from m";
rs = stmt.executeQuery(query);
while(rs.next()){
String id = rs.getString("m_id");
String name = rs.getString("m_name");
int points = rs.getInt("m_points");
System.out.println(id+" "+name+" "+points);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
rs.close(); stmt.close(); conn.close();
}catch(SQLException e){ e.printStackTrace();
}
}
}
}
결과
'프로그래밍 > JDBC' 카테고리의 다른 글
JDBC 실습(2) (0) | 2012.07.16 |
---|---|
JDBC 초기 설정 (0) | 2012.07.16 |
JDBC 레코드 검색 (0) | 2012.06.20 |
JDBC 실행 순서 정리 (0) | 2012.06.20 |
JDBC ( SQL ) (0) | 2012.06.20 |