package java_jdbc;
import java.sql.*;
public class Member_jdbc { String[] Info = null; Connection conn = null; Statement stmt = null; ResultSet rs = null; public Member_jdbc(String[] info){ this.Info = info; boolean result = dbLoad();
if (result){ String[] ConnUrl = dbConnection(); String sql = this.Statement(); ResultSet rs = Execute(ConnUrl, sql); if(rs != null){ // rs의 값이 null 있지않을경우 true 를 Return String str = RecordSet(rs); Screen(str); } } } public boolean dbLoad(){ // 드라이버 성공 여부 확인 메서드 boolean result = false; String driver = "oracle.jdbc.driver.OracleDriver"; try{ Class.forName(driver); result = true; } catch(ClassNotFoundException e){ Screen("Failed Driver Load"); } return result; }
// 오라클 데이터베이스 연동 해주기 driver:ip:1521:xe:id:passwd public String[] dbConnection(){
String[] ConnUrl = {"jdbc:oracle:thin:" + Info[0] +":1521:xe", Info[1] ,Info[2]}; return ConnUrl; } public String Statement(){ String sql = "SELECT M_ID, M_PASSWORD FROM M"; return sql; } public ResultSet Execute(String[] ConnUrl, String sql) { try{ conn = DriverManager.getConnection(ConnUrl[0], ConnUrl[1], ConnUrl[2]); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException e){ Screen(e.toString()); } finally{ return rs; } } public String RecordSet(ResultSet rs) {
String Result=""; try{ Result += "--------------------------------------\n"; Result += "ID PASSWORD\n"; Result += "--------------------------------------\n"; while(rs.next()){ Result += rs.getString(1) + " "+rs.getString(2)+"\n"; } Result += "---------------------------------\n"; } catch(SQLException e){ Screen(e.toString()); } finally{ try{ rs.close(); stmt.close(); conn.close(); } catch(SQLException e) {Screen(e.toString());} finally{ return Result;} } }
public void Screen(String str){ //System.out.println을 찍지않기위한 메서드 생성 System.out.println(str); } } |