프로그래밍/JDBC

JDBC 실습(1)

꿈풀이 2012. 6. 20. 18:10

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();
            }
        }
    }
}

결과