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