JDBC Sample

package com.sds.jdbc.board;

import java.sql.*;

public class SearchBoardList {
     private Connection conn;
     private Statement stmt;
     private ResultSet rs;
 
     private String driver = "oracle.jdbc.driver.OracleDriver";
     private String url = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
     private String id = "hr";
     private String pass = "hr";
     private String sql = " select * from board ";
 
 public void getBoardList(){
      try {
           Class.forName(driver);
           conn = DriverManager.getConnection(url, id, pass);
           stmt = conn.createStatement();
           rs = stmt.executeQuery(sql);
   
           while(rs.next()){
                System.out.print("SEQ : " + rs.getString("seq") + "\t\t");
                System.out.println("TITLE : " + rs.getString("title"));
           }
      } catch (Exception e) {
           e.printStackTrace();
      } finally {
           try {
                rs.close();
                stmt.close();
                conn.close();
           } catch (SQLException e) {
                e.printStackTrace();
           }
      }
 
 }
 
     public static void main(String[] args) {
          SearchBoardList sb1 = new SearchBoardList();
          sb1.getBoardList();
     }
}