adminbeanbo.java

这是一个购物网站可以实现购物的功能还有后台管理

package com.back.model;
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 com.my.model.ConnDB;
import com.my.model.GoodsBean;
public class AdminBeanBO 
{
	private ResultSet rs=null;
	   private Connection ct=null;
	   private PreparedStatement ps=null;
	   private Statement sm=null;
	   private int pageSize = 3;
		private int rowCount = 0;
		private int pageCount = 0;
	   public int checkUser(String u)
	   {   int a=0;
	      try
	      {
	    	  ct=new ConnDB().getConn();
				ps=ct.prepareStatement("select * from users1 where username='"+u+"'");
				rs=ps.executeQuery();
				if(rs.next())
				{
					a=1;
				}			
	      }
	      catch(Exception e)
	      {
	    	  e.printStackTrace();
	      }finally{
				this.close();
			}
	   
		   return a;
	   }
	   public int addUser(String u,String t,String p1,String p2,String a,String p3,String e ,String p4)
	   {
	   			int b=0;	
	   			int m=checkUser(u, p1, p2);
	       try
	   	  {
	   		if(m==1)
	   		{
	   			b=2;//用户名为空
	   		}else if(m==2)
	   		{
	   			b=3;//密码为空
	   		}else if(m==3)
	   		{
	   			b=4;//确认密码为空
	   		}else if(m==4)
	   		{
	   			b=5;//两次密码不一致
	   		}else if(m==5)
	   		{
	   			int n=this.checkUser(u);
	   			if(n==1)
	   			{
	   				b=6;
	   			}else {
	   			ct=new ConnDB().getConn();
	   			sm=ct.createStatement();
	   			String sql="insert into users1 (username,truename,password,email,phone,address,postcode,grade) values ('"+u+"','"+t+"','"+p1+"','"+e+"','"+p3+"','"+a+"','"+p4+"','1')";
	   			int l=sm.executeUpdate(sql);
	   			if(l==1)
	   			{
	   				b=1;//注册成功
	   			}
	   		}
	   	 }
	  }
	   			catch(Exception ex)
	   			{
	   				ex.printStackTrace();
	   			}finally{
	   				this.close();
	   			}
	   			return b;
	   }
	   public int checkUser(String u,String p1,String p2)
	   {   int c=0;
		   if(u.equals("")|u==null)
		   {
			   c=1;
		   }else if(p1.equals("")|p1==null)
		   {
			   c=2;
		   }else if(p2.equals("")|p2==null)
		   {
			   c=3;
		   }else if(!p1.equals(p2))
		   {
			   c=4;
		   }else
		   {
			   c=5;
		   }	
		   return c;
	   }
	   public  int checkUser(String u, String p) {
	        int b=0;
			try {
				ct = new ConnDB().getConn();
				ps = ct.prepareStatement("select password,grade from users1 where username='"+ u + "'");
				 rs = ps.executeQuery();
				if (rs.next()) {
					if (rs.getString(1).equals(p)) {
						 if(rs.getInt(2)==1)
						 {
							 b=1;//登录成功
						 }else{
							 b=4;//无权限
						 }
					}else if(rs.getString(1)!=p)
					{
						b=2;//密码错误
					}	
				}else 
				{
					b=3;//无该用户
				}
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				this.close();
			}
			return b;
		}
	  public boolean deleteUser(int id )
	  {
		  boolean b=false;
		  try
		  {
			  ct=new ConnDB().getConn();
			  sm=ct.createStatement();
			  int l=sm.executeUpdate("delete from users1 where userId='"+id+"'");
			  if(l==1)
			  {
				  b=true;
			  }
		  }catch(Exception e)
		  {
			  e.printStackTrace();
		  }finally
		  {
			  this.close();
		  }
		  return b;
	  }
	   public boolean updateUser(String u,String t,String a,String p3,String e,String p4)
		{
			 boolean b=false;
			 try{
				 ct=new ConnDB().getConn();
					sm=ct.createStatement();
					int l=sm.executeUpdate("update users1 set truename='"+t+"',address='"+a+"',phone='"+p3+"',email='"+e+"',postcode='"+p4+"' where username='"+u+"'");
					//System.out.println(l);				
					if(l==1)
					{
						b=true;
					}
				}
				catch(Exception ex)
				{
					ex.printStackTrace();
				}finally{
					this.close();
				}
				return b;
			 }
	   public int getPageCount() {
			try {
				ct = new ConnDB().getConn();
				sm=ct.createStatement();
				rs = sm.executeQuery("select count(*) from users1");
				if (rs.next()) {
					rowCount = rs.getInt(1);
					//System.out.println(rowCount);
				}
				if (rowCount % pageSize == 0) {
					pageCount = rowCount / pageSize;
				} else {
					pageCount = rowCount / pageSize + 1;
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
			return pageCount;
		}
	   public ArrayList<AdminBean> getUsersByPage(int pageSize,int pageNow)
	   {
		   ArrayList<AdminBean> al=new ArrayList<AdminBean>();
		   try
		   {
			   ct=new ConnDB().getConn();
			   ps=ct.prepareStatement("select * from users1 limit "+(pageNow-1)*pageSize+","+pageSize+"");
			   rs=ps.executeQuery();
			   while(rs.next())
			   {
				   AdminBean ab=new AdminBean();
				   ab.setUserId(rs.getInt(1));
				   ab.setUsername(rs.getString(2));
				   ab.setTruename(rs.getString(3));
				   ab.setPassword(rs.getString(4));
				   ab.setEmail(rs.getString(5));
				   ab.setPhone(rs.getString(6));
				   ab.setAddress(rs.getString(7));
				   ab.setPostcode(rs.getString(8));
				   ab.setGrade(rs.getInt(9));
				   al.add(ab);
			   }
		   }
		   catch(Exception e)
		   {
			   e.printStackTrace();
		   }finally
		   {
			   this.close();
		   }
		   return al;
	   }
	   public AdminBean getUserBean1(String u)
	   {
		   AdminBean ab=new AdminBean();
		   try
		   {
			   ct = new ConnDB().getConn();
			   ps = ct.prepareStatement("select * from users1 where email='"+ u + "'");
		   //ps.setString(1, u);
		   rs=ps.executeQuery();
		   if(rs.next())
		   {
			   ab.setUserId(rs.getInt(1));
			   ab.setUsername(rs.getString(2));
			   ab.setTruename(rs.getString(3));
			   ab.setPassword(rs.getString(4));
			   ab.setEmail(rs.getString(5));
			   ab.setPhone(rs.getString(6));
			   ab.setAddress(rs.getString(7));
			   ab.setPostcode(rs.getString(8));
			   ab.setGrade(rs.getInt(9));
			   /*System.out.println(ab.getUserId());
			   System.out.println(ab.getUsername());
			   System.out.println(ab.getTruename());
			   System.out.println(ab.getPassword());
			   System.out.println(ab.getEmail());
			   System.out.println(ab.getPhone());
			   System.out.println(ab.getAddress());
			   System.out.println(ab.getPostcode());
			   System.out.println(ab.getGrade());*/
		   }else
		   {
			   ab=null;
		   }
		   
		   }
		   catch(Exception e)
		   {
			   e.printStackTrace();
		   }finally{
			   this.close();
		   }
		   return ab;
	   }
	   public AdminBean getUserBean(String u)
	   {
		   AdminBean ab=new AdminBean();
		   try
		   {
			   ct = new ConnDB().getConn();
			   ps = ct.prepareStatement("select * from users1 where username='"+ u + "'");
		   //ps.setString(1, u);
		   rs=ps.executeQuery();
		   if(rs.next())
		   {
			   ab.setUserId(rs.getInt(1));
			   ab.setUsername(rs.getString(2));
			   ab.setTruename(rs.getString(3));
			   ab.setPassword(rs.getString(4));
			   ab.setEmail(rs.getString(5));
			   ab.setPhone(rs.getString(6));
			   ab.setAddress(rs.getString(7));
			   ab.setPostcode(rs.getString(8));
			   ab.setGrade(rs.getInt(9));
			   /*System.out.println(ab.getUserId());
			   System.out.println(ab.getUsername());
			   System.out.println(ab.getTruename());
			   System.out.println(ab.getPassword());
			   System.out.println(ab.getEmail());
			   System.out.println(ab.getPhone());
			   System.out.println(ab.getAddress());
			   System.out.println(ab.getPostcode());
			   System.out.println(ab.getGrade());*/
		   }else
		   {
			   ab=null;
		   }
		   
		   }
		   catch(Exception e)
		   {
			   e.printStackTrace();
		   }finally{
			   this.close();
		   }
		   return ab;
	   }
	   public void close() {
			try {
				if (rs != null) {
					rs.close();
					rs = null;
				}
				if (ps != null) {
					ps.close();
					ps = null;
				}
				if (ct != null) {
					ct.close();
					ct = null;
				}
			} catch (SQLException e) {

				e.printStackTrace();
			}
		}
}