userhandle.java

图书商城系统

package com.tang.foruse;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserHandle {
	
	GetConn gc = null;

	PreparedStatement pstm = null;
	
	Connection conn = null;
	
	ResultSet rs = null;
	
	public UserHandle() {
		gc = new GetConn();
	}
	
	public UserBean getUserBean(int uid)
	{
		UserBean userbean = new UserBean();
		conn = gc.GetConnectioon();
		try {
			pstm = conn.prepareStatement("select * from users where id = ?");
			pstm.setInt(1, uid);
			rs = pstm.executeQuery();
			if(rs.next())
			{
				userbean.setId(rs.getInt(1));
				userbean.setUsername(rs.getString(2));
				userbean.setPassword(rs.getString(3));
				userbean.setMoney(rs.getDouble(4));
				userbean.setEmail(rs.getString(5));
				userbean.setAddress(rs.getString(6));
				userbean.setZipcode(rs.getLong(7));
				userbean.setPhonenum(rs.getLong(8));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return userbean;
	}
	public String getPassword(int id)
	{
		String password = null;
		password = this.getUserBean(id).getPassword();
		return password;
		
	}
}