sortbean.java

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

package com;

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

public class SortBean
{
    private Connection con;
    SortClass sort=new SortClass();

    public SortBean()
    {
        try
        {
            con = DBConnection.getConnection();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }

    public void setSortInfo(SortClass sort)
    {
    	this.sort = sort;
    }


    public Collection getAllCategory()
    {
        SortClass sort;
        ArrayList arraylist = new ArrayList();
        try
        {
                Statement statement = con.createStatement();
                ResultSet resultset = statement.executeQuery("select * from sort");


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

                    sort = new SortClass();
                    sort.setSortId(i);
                    sort.setSortName(s);

                    arraylist.add(sort);
                }

                con.close();
        }

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

        return arraylist;
    }
    public void addSort()throws Exception
    {
        try
        {

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

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


        }
        catch(Exception e)
        {
                e.printStackTrace();
                throw e;
        }
    }
}