package com.db;
import java.sql.*;

public class JdbcOracleInsertPre{

	public static void main(String args[]) {
		String url = "jdbc:oracle:thin:@localhost:1521:xe";
		String user = "scott";
		String passwd = "tiger";

		Connection conn;
		Statement stat;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver"); //1.jdbc 드라이버 등록
			conn = DriverManager.getConnection (url, user, passwd); // 2.connection 객체 얻어내기

			stat = conn.createStatement(); // 3. statement객체 얻어내기

			String q = "select * from addressBook order by id";//4.쿼리 실행
			ResultSet rs = stat.executeQuery(q);  //5. 결과처리



			while(rs.next()==true) { //6.결과처리
				String id = rs.getString(1);
				String name = rs.getString(2);
				String phone = rs.getString(3);
				String address = rs.getString(4);
				String company = rs.getString(5);

				System.out.println(id+"--"+name+"--"+phone+"--"+address+"--"+company);
			}

			stat.close();
			conn.close();
		} catch ( Exception e ) {
			e.printStackTrace();
		}
	}
}