JDBC 레코드 검색

Java_jdbc.java 

package java_jdbc; import java.sql.*; public class Java_jdbc {  String[] Info = {"@112.169.178.99", "JAVA", "JAVA"};     public static void main(String[] args) {         Member_jdbc M = new Member_jdbc(Info);     } }

 

Member_jdbc.java 

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

    

결과