userdao.java

点餐系统 非常好的 jsp mysql 我也是别人那里下载来的

package DAO;
import java.sql.*;
import Entity.UserBean;
import java.util.*;
public class UserDAO {
	OperateDB db=new OperateDB();
	ResultSet rs=null;	
	//根据用户id查询用户信息
	public UserBean GetUserById(String id)
	{
		     UserBean bean=new UserBean();
			try{
				String sql="select * from Userinfo where uid='"+id+"'";
			    rs=db.GetQuery(sql);
				if(rs.next())
				{					
					bean.setUname(rs.getString(3));
					bean.setUdegree(rs.getString(11));
					bean.setUIP(rs.getString(14));
				}
			}catch(Exception ex)
			{
				System.out.println("根据用户id查询用户信息出现异常！"+ex.toString());
			}
			
			return bean;
		
	}
	
	public UserBean CheckLogin(String uname,String pwd)
	{
		UserBean bean=null;
		try{
			String sql="select * from UserInfo where Uname='"+uname+"' and Upwd='"+pwd+"'";
			System.out.println("登陆sql="+sql);
			 rs=db.GetQuery(sql);
			if(rs.next())
			{
			    bean=new UserBean();		
				//System.out.println("登陆bean="+rs.next());//在此写这句话会出现异常？？？
				bean.setUid(rs.getString(1));			
				bean.setUpwd(rs.getString(2));
				bean.setUname(rs.getString(3));
				bean.setUquestion(rs.getString(4));
				bean.setUanswer(rs.getString(5));
				bean.setUtelephone(rs.getString(6));
				bean.setUaddress(rs.getString(7));
				bean.setUmailnumber(rs.getString(8));
				bean.setUIDcard(rs.getString(9));
				bean.setUemail(rs.getString(10));
				bean.setUdegree(rs.getString(11));
				bean.setUsonum(rs.getInt(12));
				System.out.println("343434343");
				bean.setUIP(rs.getString(14));		
			}		
			
		}catch(Exception ex)
		{
			System.out.println("检查登陆信息出现异常！"+ex.toString());
		}
		return bean;
		
	}
	public ArrayList<UserBean> GetSODesc()
	{
		ArrayList<UserBean> list=new ArrayList<UserBean>();			
		try{
			String sql="select top 10 uname,usonum from UserInfo order by usonum desc";			
			 rs=db.GetQuery(sql);
			while(rs.next())
			{
				UserBean bean=new UserBean();		
				
				bean.setUname(rs.getString(1));
			
				bean.setUsonum(rs.getInt(2));
			
				list.add(bean);
			}		
			
		}catch(Exception ex)
		{
			System.out.println("查询前10位so币用户的信息出现异常！"+ex.toString());
		}
		
		return list;
		
		
	}
    //查询用户总数
	public int GetUserCount()
	{
		 int count=0;
		try{
			String sql="select count(*) from userinfo";
			rs=db.GetQuery(sql);
			if(rs.next())
				count=rs.getInt(1);			
		}catch(Exception ex)
		{
			System.out.println("查询用户总数出现异常！"+ex.toString());
		}
		
		return count;
		
	}
	//查询最新注册的用户
	public UserBean GetNewUser()
	{
		 UserBean bean=new UserBean();
		try{
			String sql="select top 1 uname from Userinfo order by Uregistetime desc";
		    rs=db.GetQuery(sql);
			if(rs.next())
			{
				bean.setUname(rs.getString(1));
			}
		}catch(Exception ex)
		{
			System.out.println("查询最新注册的用户出现异常！"+ex.toString());
		}
		
		return bean;		
	}
	//添加注册用户
	public int AddUser(UserBean bean)
	{
		int count=0;
			try{
				String sql="insert into UserInfo(uid,upwd,uname,Uquestion,Uanswer,Utelephone," +
						"Uaddress,Umailnumber,UIDcard,Uemail,UIP) values('"+bean.getUid()
						+"','"+bean.getUpwd()+"','"+bean.getUname()+"','"+bean.getUquestion()
						+"','"+bean.getUanswer()+"','"+bean.getUtelephone()+"','"
						+bean.getUaddress()+"','"+bean.getUmailnumber()+"','"
						+bean.getUIDcard()+"','"+bean.getUemail()+"','"+bean.getUIP()+"')";
			   count=db.ReturnLine(sql);
			}catch(Exception ex)
			{
				System.out.println("添加注册用户出现异常！"+ex.toString());
			}			
			return count;
		
	}
	//更新so币
	public int UpdateSo(String sql)
	{
		int row=0;
		try {
			row=db.ReturnLine(sql);	
			
		} catch (Exception e) {
			System.out.println("更新so币出现异常！"+e.toString());
			e.printStackTrace();
		}
		return row;
	}

}