userdelete.java

用JSP写的在线书店,只是初步写,没有用到架构,看看就行了

package dbBean;

import java.sql.ResultSet;
import java.sql.SQLException;

public class userDelete
{
    public boolean delete(String id)
    {
    	boolean tell;
       if(id=="")
       {
    	   return false;
       }
       else
       {
    	 dbConnection  dbConn=new dbConnection();
       	 dbConn.getConnect("bookshop", "manager", "123");
       	 int userid=Integer.parseInt(id);
       	 String sql="delete from Consumer where User_ID="+userid ;
       	 tell=dbConn.deleteSql(sql);
       }
       System.out.print(tell);
       return tell;
    }
    public boolean update(String id,int type)
    {
    	boolean tell;
        if(id=="")
        {
     	   return false;
        }
        else
        {
        	
     	     dbConnection  dbConn=new dbConnection();
        	 dbConn.getConnect("bookshop", "manager", "123");
        	int userid=Integer.parseInt(id);
        	if(type==2)
        	{
        	 String sql="update Consumer set Lock1=1 where User_ID="+userid ;
        	 tell=dbConn.deleteSql(sql);
        	 if(tell==true)
        	  return tell;
        	 else
        		 return false;
			}
        	if(type==3)
        	{
        		String sql="update Consumer set Lock1=0 where User_ID="+userid ;
           	 tell=dbConn.deleteSql(sql);
           	 if(tell==true)
           	  return tell;
           	 else
           		 return false;
        	}
        
        }
        return false;
    }
}