userbeanbo.java

来自「这是一个购物网站可以实现购物的功能还有后台管理」· Java 代码 · 共 207 行

package com.my.model;

import java.sql.*;


public class UserBeanBO 
{
	private Statement sm = null;
	private ResultSet rs=null;
	   private Connection ct=null;
	   private PreparedStatement ps=null;
	   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 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 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 if(n==0)
			{
				ct=new ConnDB().getConn();
			sm=ct.createStatement();
			String sql="insert into users1 (username,truename,password,email,phone,address,postcode) values ('"+u+"','"+t+"','"+p1+"','"+e+"','"+p3+"','"+a+"','"+p4+"')";
			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)
	   {   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 UserBean getUserBean(String u)
	   {
		   UserBean ub=new UserBean();
		   try
		   {
			   ct = new ConnDB().getConn();
			   ps = ct.prepareStatement("select * from users1 where username='"+ u + "'");
		   //ps.setString(1, u);
		   rs=ps.executeQuery();
		   if(rs.next())
		   {
			   ub.setUserId(rs.getInt(1));
			   ub.setUsername(rs.getString(2));
			   ub.setTruename(rs.getString(3));
			   ub.setPassword(rs.getString(4));
			   ub.setEmail(rs.getString(5));
			   ub.setPhone(rs.getString(6));
			   ub.setAddress(rs.getString(7));
			   ub.setPostcode(rs.getString(8));
			   ub.setGrade(rs.getInt(9));
			   /*System.out.println(ub.getUserId());
			   System.out.println(ub.getUsername());
			   System.out.println(ub.getTruename());
			   System.out.println(ub.getPassword());
			   System.out.println(ub.getEmail());
			   System.out.println(ub.getPhone());
			   System.out.println(ub.getAddress());
			   System.out.println(ub.getPostcode());
			   System.out.println(ub.getGrade());*/
		   }
		   
		   }
		   catch(Exception e)
		   {
			   e.printStackTrace();
		   }finally{
			   this.close();
		   }
		   return ub;
	   }
	   
	   
	   public  int checkUser(String u, String p) {
	        int b=0;
			try {
				ct = new ConnDB().getConn();
				ps = ct.prepareStatement("select password from users1 where username='"+ u + "'");
				 rs = ps.executeQuery();
				if (rs.next()) {
					if (rs.getString(1).equals(p)) {
						 b = 1;
					}else if(rs.getString(1)!=p)
					{
						b=2;
					}	
				}else 
				{
					b=3;
				}
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				this.close();
			}
			return b;
		}
	   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();
			}
		}
}