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;
}
}
转载于:https://blog.51cto.com/zhouying/623166