producebean.java

用jsp+javabean做的一个网上花店

package com;

import java.util.ArrayList;
import java.util.Collection;
import java.sql.*;

public class ProduceBean
{
    private Connection con;
    ProduceClass produce=new ProduceClass();

    public ProduceBean()
    {
        try
        {
            con = DBConnection.getConnection();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
    
    public void setProduce(ProduceClass produce)
    {
    	this.produce = produce;
    }
    
    public Collection getAllProduce()
    {
        ProduceClass produce;
        ArrayList arraylist = new ArrayList();
        try
        {
            Statement statement = con.createStatement();
            ResultSet resultset = statement.executeQuery("select * from produce");


            while(resultset.next())
            {
                produce = new ProduceClass();
                int i=resultset.getInt(1);
                String s=resultset.getString(2);

                produce.setProduceId(i);
                produce.setProduceName(s);

                arraylist.add(produce);
            }

            con.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return arraylist;
    }
    
    public Collection getProduceByProduceId(String str)
    {
    	int id=Integer.parseInt(str);
        ProduceClass produce;
        ArrayList arraylist = new ArrayList();
        try
        {
                Statement statement = con.createStatement();
                ResultSet resultset = statement.executeQuery("select * from produce where produceId="+id);


                while(resultset.next())
                {
                    produce = new ProduceClass();
                    int i=resultset.getInt(1);
                    String s=resultset.getString(2);

                    produce.setProduceId(i);
                    produce.setProduceName(s);

                    arraylist.add(produce);
                }

                con.close();
        }

        catch(Exception e)
        {
                e.printStackTrace();
        }
        return arraylist;
    }
    
    public Collection getProduceByProduceName(String str)
    {
        ProduceClass produce;
        ArrayList arraylist = new ArrayList();
        try
        {
                Statement statement = con.createStatement();
                ResultSet resultset = statement.executeQuery("select * from produce where produceName='"+str+"'");


                while(resultset.next())
                {
                    produce = new ProduceClass();
                    int i=resultset.getInt(1);
                    String s=resultset.getString(2);

                    produce.setProduceId(i);
                    produce.setProduceName(s);

                    arraylist.add(produce);
                }

                con.close();
        }

        catch(Exception e)
        {
                e.printStackTrace();
        }
        return arraylist;
    }
    
    public Collection getAllProduceDetails(int i)
    {
        ProduceDetailsClass produceDetail;
        ArrayList arraylist = new ArrayList();
        try
        {
                Statement statement = con.createStatement();
                ResultSet resultset = statement.executeQuery("select * from produceDetails where produceId='" + i + "'");


                while(resultset.next())
                {
                    produceDetail = new ProduceDetailsClass();
                    int i1=resultset.getInt(1);
                    String s=resultset.getString(2);
                    int i2=resultset.getInt(3);
                    int i3=resultset.getInt(4);

                    produceDetail.setProduceId(i1);
                    produceDetail.setProduceName(s);
                    produceDetail.setSortId(i2);
                    produceDetail.setGoodsId(i3);

                    arraylist.add(produceDetail);
                }

                con.close();
        }

        catch(Exception e)
        {
                e.printStackTrace();
        }
        return arraylist;
    }

	public void addProduce()throws Exception
    {
        try
        {

              PreparedStatement stm=con.prepareStatement("insert into produce values(?)");
              stm.setString(1,produce.getProduceName());

              try
              {
                  stm.executeQuery();
              }
              catch(Exception e)
              {
              }


        }
        catch(Exception e)
        {
                e.printStackTrace();
                throw e;
        }
    }
    public void deleteProduce(String s)
    {
    	try
    	{
    		int i=Integer.parseInt(s);
    		//System.out.println(i+"  @@@@@@@@@@@@");
	    	Statement statement = con.createStatement();
	        statement.execute("delete from produce where produceId='" + i + "'");
    	}
		catch(Exception e)
		{
			e.printStackTrace();
		}
    }
}