bookcatalog.java

用java+Ajax做的图书商城

package shoppcart;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.util.ArrayList;
import java.util.List;

public class BookCatalog {
    private String type;
    private String name;
    public void setType(String type){
        this.type=type;
    }
    public void setName(String name){
        this.name=name;
    }
    public String getType(){
        return this.type;
    }
    public String getName(){
        return this.name;
    }
    private BookCatalog(){ }
    public static List<BookCatalog> getCatalogList(){
        Connection con=null;
        ConnectManager manager=null;
        Statement st=null;
        ResultSet rs=null;
        BookCatalog catalog=null;
        try{
            manager=new ConnectManager();
            con=manager.getConnection();
            st=con.createStatement();
            rs=st.executeQuery("select * from produceType");
            ArrayList<BookCatalog> BookList=new ArrayList<BookCatalog>();
            while(rs.next()){
                catalog=new BookCatalog();
                catalog.type=rs.getString("typeID");
                catalog.name=rs.getString("typeName");
                BookList.add(catalog);
            }
            return BookList;
        }
        catch(SQLException e){
            e.printStackTrace();
            return null;
        }
        finally{
            if(st!=null){
                try{
                    st.close();
                }
                catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(con!=null){
                try{
                    con.close();
                }
                catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(manager!=null){
                manager.close();
            }
        }
    }
    public static BookCatalog getBookCatalog(String type) {
        Connection con=null;
        ConnectManager manager=null;
        PreparedStatement st=null;
        ResultSet rs=null;
        BookCatalog catalog=null;
        try{
            manager=new ConnectManager();
            con=manager.getConnection();
            st=con.prepareStatement("select * from produceType where typeID=?");
            st.setString(1,type);
            rs=st.executeQuery();
            while(rs.next()){
                catalog=new BookCatalog();
                catalog.type=rs.getString("typeID");
                catalog.name=rs.getString("typeName");
            }
            return catalog;
        }
        catch(SQLException e){
            e.printStackTrace();
            return null;
        }
        finally{
            if(st!=null){
                try{
                    st.close();
                }
                catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(con!=null){
                try{
                    con.close();
                }
                catch(SQLException e){
                    e.printStackTrace();
                }
            }
            if(manager!=null){
                manager.close();
            }
        }
    }
}