JDBC 실습(1)
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();
}
}
}
}
결과