package dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashSet;

import userBean.UserBean;
import util.UserUtil;

public class UserDao {
 
// 插入
 public void insertSql(UserBean ub) throws Exception{
  String s1 = ub.getName();
  String s2 = ub.getSex();
  String s3 = ub.getBrith();
  String s4 = ub.getPassword();
  
  String sql = "insert into tlogin2 values(" +"'" +s1 +"',"+"'"+ s2 +"',"+ "'" + s3 + "'," + "'" + s4 + "');";
  
  UserUtil uu = new UserUtil();
  Statement s = uu.getStatement();
  s.execute(sql); 
 }
 
// 查出所有的数据
 public HashSet<UserBean> getAllUsers() throws Exception{
  String sql = "select * from tlogin2;";
  UserUtil uu = new UserUtil();
  
  ResultSet rs = uu.executeQuery(sql);
  HashSet<UserBean> hs = new HashSet<UserBean>();
  while(rs.next()){
   UserBean ub = new UserBean();
   ub.setName(rs.getString(1));
   ub.setSex(rs.getString(2));
   ub.setBrith(rs.getString(3));
   ub.setPassword(rs.getString(4));
   hs.add(ub);
  }
  return hs; 
 }
 

}