private String unm;
private String upass;
public String getUnm() {
return unm;
}
public void setUnm(String unm) {
this.unm = unm;
}
public String getUpass() {
return upass;
}
public void setUpass(String upass) {
this.upass = upass;
}
}
public class UserbeanCL {
//登录验证
Connection cn = null;
boolean flag = false;
public boolean denglu(String usernm, String upass) {
String mysql = "select * from user where user =? and password = ?";
PreparedStatement pst = null;
ResultSet rs = null;
cn = (new Conn()).getConn();
try {
pst=cn.prepareStatement(mysql);
pst.setString(1, usernm);
pst.setString(2, upass);
rs = pst.executeQuery();
if (rs.next()) {
flag = true;
//response.sendRedirect("goods.jsp");
}
} catch (SQLException ex) {
Logger.getLogger(UserbeanCL.class.getName()).log(Level.SEVERE, null, ex);
} finally {
try {
//rs.close();
//pst.close();
cn.close();
} catch (SQLException e) {
}
}
return flag;
}
ArrayList<Userbean> myusers = new ArrayList<>();
public ArrayList<Userbean> listallgoods() {
String mysql = "select * from goods";
Statement st;
ResultSet rs;
try {
cn = (new Conn()).getConn();
st = cn.createStatement();
rs = st.executeQuery(mysql);
myusers = new ArrayList<>();
Userbean myu;
while (rs.next()) {
myu = new Userbean();
myu.setUnm(rs.getString(1));
myu.setUpass(rs.getString(2));
myusers.add(myu);
}
} catch (SQLException ex) {
Logger.getLogger(UserbeanCL.class.getName()).log(Level.SEVERE, null, ex);
}
return myusers;
}
}