public class UserDAO extends BaseDAO
{
 
 private static UserDAO Instance = new UserDAO();
 private static Log logger = LogFactory.getLog(UserDAO.class);
 
 // 인스턴스
 public static UserDAO getInstance()
 {
  return Instance;
 }
 public boolean isAdmin(ConnectionContext resource, UserForm userForm) throws Exception{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rs = null;
  StringBuffer sql_str = new StringBuffer();
  boolean isAdmin = false;
  
  try
  {
   conn = resource.getConnection();
   
   sql_str.append(" SELECT COUNT(0) ");
   sql_str.append(" FROM ADMIN_T WHERE ");
   sql_str.append(" USERID = ? AND ISADMIN = 'Y' ");
      
   pstmt = conn.prepareStatement(sql_str.toString());
   
   pstmt.setString(1, userForm.getSabun());
      
   rs = pstmt.executeQuery();
   
   logger.info("UserDAO.isAdmin excuted.");
   
   if(rs.next())
    if(rs.getInt(1) > 0)
     isAdmin = true;
  }
  catch(Exception e)
  {
   logger.error("Error at UserDAO.isAdmin" , e);
   throw e;
  }finally{
   if(rs != null) try{rs.close();} catch(SQLException e){}
   if(pstmt != null) try{pstmt.close();} catch(SQLException e){}
  }
  return isAdmin;
 }

 public UserVO getUser(ConnectionContext resource, UserForm userForm) throws Exception{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rs = null;
  StringBuffer sql_str = new StringBuffer();
  UserVO userVO = null;
  
  try
  {
   conn = resource.getConnection();
   
   sql_str.append(" SELECT * FROM USER_T WHERE USERID = ? ");
      
   pstmt = conn.prepareStatement(sql_str.toString());
   
   pstmt.setString(1, userForm.getSabun());
      
   rs = pstmt.executeQuery();
   
   logger.info("UserDAO.getUser excuted.");
   
   if(rs.next())
   {
    userVO = new UserVO();
    userVO.setName(rs.getString("NAME"));
    userVO.setSabun(rs.getString("SABUN"));
    userVO.setTelephone(rs.getString("TELEPHONE"));
   }
  }
  catch(Exception e)
  {
   logger.error("Error at getUser.getUser" , e);
   throw new Exception();
  }finally{
   if(rs != null) try{rs.close();} catch(SQLException e){}
   if(pstmt != null) try{pstmt.close();} catch(SQLException e){}
  }
  return userVO;
 }
}

public class UserVO
{
 private String sabun;
 private String name;
 private String post;
 private String telephone;
 private String cellphone;
 private boolean isAdmin;
 private String jumin;
 
 /**
  * @return the jumin
  */
 public String getJumin()
 {
  return jumin;
 }
 /**
  * @param jumin the jumin to set
  */
 public void setJumin(String jumin)
 {
  this.jumin = jumin;
 }
 /**
  * @return the cellphone
  */
 public String getCellphone()
 {
  return cellphone;
 }
 /**
  * @return the name
  */
 public String getName()
 {
  return name;
 }
 /**
  * @return the post
  */
 public String getPost()
 {
  return post;
 }
 /**
  * @return the sabun
  */
 public String getSabun()
 {
  return sabun;
 }
 /**
  * @return the telephone
  */
 public String getTelephone()
 {
  return telephone;
 }
 /**
  * @param cellphone the cellphone to set
  */
 public void setCellphone(String cellphone)
 {
  this.cellphone = cellphone;
 }
 /**
  * @param name the name to set
  */
 public void setName(String name)
 {
  this.name = name;
 }
 /**
  * @param post the post to set
  */
 public void setPost(String post)
 {
  this.post = post;
 }
 /**
  * @param sabun the sabun to set
  */
 public void setSabun(String sabun)
 {
  this.sabun = sabun;
 }
 /**
  * @param telephone the telephone to set
  */
 public void setTelephone(String telephone)
 {
  this.telephone = telephone;
 }
 /**
  * @return the isAdmin
  */
 public boolean isAdmin()
 {
  return isAdmin;
 }
 /**
  * @param isAdmin the isAdmin to set
  */
 public void setAdmin(boolean isAdmin)
 {
  this.isAdmin = isAdmin;
 }
}