www.pudn.com > BuyFlowers.rar > 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; 
 
	} 
}