usermanager.java

一个可以作为毕业设计的网上商城项目

package com.fang.shopping;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.fang.shppping.util.DB;

public class UserManager {
	public static List<User> getUsers()
	{
		List<User> list = new ArrayList<User>();
		Connection conn = null;
		ResultSet rs = null;
		
		try {
			conn = DB.getConn();
			String sql = "select * from ruser order by id desc";
			rs = DB.executeQuery(conn, sql);
			while(rs.next()){
				User u = new User();
				u.setId(rs.getInt("id"));
				u.setUserName(rs.getString("username"));
				u.setAddr(rs.getString("addr"));
				u.setPassWord(rs.getString("password"));
				u.setPhone(rs.getString("phone"));
				u.setRDate(rs.getTimestamp("rdate"));
				
				list.add(u);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DB.close(rs);
			DB.close(conn);
		}
		return list;
	}
	
	public static boolean foundUser(String username){ 
		Connection conn=DB.getConn();
		String sql="select * from ruser where username='"+username+"'";
//System.out.println(sql);
		ResultSet rs=DB.executeQuery(conn, sql);
		try {	
			while(rs.next()){

				return true;	
			}						
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DB.close(rs);
			DB.close(conn);
		}		
		return false;		
	}
	
	public static void deleteUser(int id){
		Connection conn = null;
		Statement stmt = null;
		try {
			conn = DB.getConn();
			stmt = DB.getStatement(conn);
			
			stmt.executeUpdate("delete from ruser where id=" + id);
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DB.close(stmt);
			DB.close(conn);
		}
	}
	
	public static boolean userExits(String username){
		
		
		return false;
	}
	
	public static boolean isPasswordCorrect(String username,String password){
		
		
		return false;
	}
	
	
	public static User validata(String username, String password) throws UserNotFoundException, PasswordErrorException 
	{
		User u = null;
		Connection conn = DB.getConn();
		String sql = "select * from ruser where username = '" + username + "'";
		Statement stmt = DB.getStatement(conn);
		ResultSet rs = DB.getResultSet(stmt, sql);
		try {
			if(!rs.next()) {
				throw new UserNotFoundException("用户不存在:" + username);
			} else {
				if(!password.equals(rs.getString("password"))) {
					throw new PasswordErrorException("密码不正确哦!");
				}
				u = new User();
				u.setId(rs.getInt("id"));
				u.setUserName(rs.getString("username"));
				u.setPassWord(rs.getString("password"));
				u.setAddr(rs.getString("addr"));
				u.setPhone(rs.getString("phone"));
				u.setRDate(rs.getTimestamp("rdate"));
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DB.close(rs);
			DB.close(stmt);
			DB.close(conn);
		}
	return u;
	}

}