?? userbean.java
字號:
package com.qrsx.buyflowers.beans;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import java.util.ArrayList;
public class UserBean extends DBConnection {
private UserClass userClass;// 本類的實體對象
private Collection collection = null;
private PreparedStatement ptst = null;
private ResultSet rs = null;
public UserBean() throws ClassNotFoundException, SQLException {
super();
}
public void setUserInfo(UserClass userClass) {
this.userClass = userClass;
}
public Collection getUserInfo(){
collection = new ArrayList();
collection.add(userClass);
return collection;
}
public void addUserInfo() {
String sql = "insert into users(usersName,usersPass,usersRepass,usersPassQuestion,usersPassReply,usersTrueName,usersAddress,usersPhone,usersE_mail) values(?,?,?,?,?,?,?,?,?);";
try {
ptst = con.prepareStatement(sql);
ptst.setString(1, this.userClass.getUsersName());
ptst.setString(2, this.userClass.getUsersPass());
ptst.setString(3, this.userClass.getUsersRepass());
ptst.setString(4, this.userClass.getUsersPassQuestion());
ptst.setString(5, this.userClass.getUsersPassReply());
ptst.setString(6, this.userClass.getUsersTrueName());
ptst.setString(7, this.userClass.getUsersAddress());
ptst.setString(8, this.userClass.getUsersPhone());
ptst.setString(9, this.userClass.getUsersE_mail());
ptst.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Boolean checkUserInfo() {
String sql = "select usersName,usersPass from users where usersName=? and usersPass=?";
Boolean flag = false;
try {
ptst = con.prepareStatement(sql);
ptst.setString(1, this.userClass.getUsersName());
ptst.setString(2, this.userClass.getUsersPass());
rs = ptst.executeQuery();
while (rs.next()) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
public Collection getUserByUserName(String usersName) {
String sql = "select * from users where usersName=?";
try {
ptst = con.prepareStatement(sql);
collection = new ArrayList();
ptst.setString(1, usersName);
rs = ptst.executeQuery();
while (rs.next()) {
userClass = new UserClass();
userClass.setUsersId(rs.getString("usersID"));
userClass.setUsersName(rs.getString("usersName"));
userClass.setUsersTrueName(rs.getString("usersTrueName"));
userClass.setUsersAddress(rs.getString("usersAddress"));
userClass.setUsersE_mail(rs.getString("usersE_mail"));
collection.add(userClass);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return collection;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -