package ch09;
 
 import java.sql.*;
 import java.util.*;
 import ch09.RegisterBean;
 
 public class MemberMgr {
    
 	private final String JDBC_DRIVER = "org.gjt.mm.mysql.Driver";
 	private final String JDBC_URL = "jdbc:mysql://cse-stu.hansung.ac.kr:3306/COM0026";
 	private final String USER = "sklee";
 	private final String PASS = "sklee123";
 
 	public MemberMgr() {
 	   try{
 	      Class.forName(JDBC_DRIVER);
 	   } catch(Exception e){
 	      System.out.println("Error: µå¶óÀ̹ö ·Îµù ½ÇÆÐ");
 	   }
	}
 
	public Vector getMemberList() {
	   Connection conn = null;
	   Statement stmt = null;
	   ResultSet rs = null;
	   Vector vecList = new Vector();
       
try {
	conn = DriverManager.getConnection(JDBC_URL,USER,PASS);
	String strQuery = "select * from member";
	stmt = conn.createStatement();
	rs = stmt.executeQuery(strQuery);
	
	while (rs.next()) {
	   RegisterBean regBean = new RegisterBean();
	   regBean.setMem_id (rs.getString("id"));
	   regBean.setMem_passwd (rs.getString("passwd"));

	   regBean.setMem_address (rs.getString("address"));
 	   regBean.setMem_job (rs.getString("job"));
               vecList.add(regBean);
	}
} catch (Exception ex) {
	System.out.println("Exception" + ex);
} finally {
	if(rs!=null)   try{rs.close();}  catch(SQLException e){}
	if(stmt!=null) try{stmt.close(); }catch(SQLException e){}
	if(conn!=null) try{conn.close();}catch(SQLException e){}
}
return vecList;
}
}