provider.java

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

package dbBean;

import java.sql.ResultSet;

public class provider
{  
	dbConnection  dbConn;
	public provider()
	{
		 dbConn=new dbConnection();
      	dbConn.getConnect("bookshop", "manager", "123");
	}
    public int insertProvider(String provider)
    {
    	String sql="select Salesman_ID from Salesman where salesmanName='"+provider+"'";
    	ResultSet rs=dbConn.selectSql(sql);
    	int tell=0;
      	try{
      		if(rs.next())
      	{
      			tell=Integer.parseInt(rs.getString(1));
      			
      	}
      	else
      		{
      			int salesman_id=0;
          		sql="select max(Salesman_ID)from Salesman";
          		rs=dbConn.selectSql(sql);
          		//ResultSet rs2=dbConn.selectSql(sql);
          		if(rs.next())
          		{
          			String temp=rs.getString(1);
          			salesman_id=Integer.parseInt(temp)+1;
          		  }
          		else
          		{salesman_id=0;}
          		sql="insert into Salesman( salesmanName,Salesman_ID) values('"+provider+"','"+salesman_id+"')";
                dbConn.deleteSql(sql);
                tell=salesman_id;
                
          	   }
      		}
      	catch(Exception e)
      	{
      		e.printStackTrace();
      	} 
      	return tell;
    }
    public ResultSet search(String provider)
    {
    	String sql="select * from Salesman where salesmanName='"+provider+"'";
    	ResultSet rs=dbConn.selectSql(sql);
    	return rs;
    }
    public boolean delete(String provider_id)	
    {
    	String sql="delete from Salesman where Salesman_ID='"+provider_id+"'";
    	boolean tell=dbConn.deleteSql(sql);
    	return tell;
    }
    public boolean update(String provider_id,String address,String email)
    {
    	String sql="update Salesman set Emails='"+email+"' ,Mailing_address='"+address+"' where Salesman_ID='"+provider_id+"'";
        boolean tell=dbConn.deleteSql(sql);
        return tell;
    }
    public boolean providerAdd(String name,String address,String email,String account)
    {
    	boolean tell=false;
    	try{String sql="select max(Salesman_ID) from Salesman";
  		ResultSet rs=dbConn.selectSql(sql);
  		ResultSet rs2=dbConn.selectSql(sql);
  		int salesman_id=0;
  		
  		if(rs2.next())
  		{   /**if(rs.getString(1)==null)
  		    {
  			{salesman_id=0;}
  		     }
  		else
  		**/
  			String id=rs.getString(1);
  			System.out.println(id);
  			{salesman_id=Integer.parseInt(rs.getString(1))+1;
  			System.out.print(id);
  		  }	}
  		sql="insert into Salesman(Salesman_ID,salesmanName,Bank_account,Mailing_address,Emails) values ("+salesman_id+",'"+name+"',"+account+",'"+address+"','"+email+"'";
        tell=dbConn.deleteSql(sql);
    	}
    catch(Exception e)
    {
    	e.printStackTrace();
    	tell=false;
    }
    return tell;
}
}