bookdao.java

jsp做的购物车 对刚学习jsp的 有很大帮助

package test2.dao;

public class BookDAO {
    public BookDAO() {
    }

    public static void main(String[] args) {
        BookDAO bookdao = new BookDAO();
    }

    public static java.sql.Connection getCon()throws Exception{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        java.sql.Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:mySource");
        return con;
    }

    public static java.util.ArrayList getAll()throws Exception{
        java.sql.Connection con=getCon();
        java.sql.Statement stm=con.createStatement();
        java.sql.ResultSet rs=stm.executeQuery("select * from books");
        java.util.ArrayList list=new java.util.ArrayList();
        while(rs.next()){
            test2.Book b=new test2.Book();
            b.setId(rs.getString(1));
            b.setName(rs.getString(2));
            b.setAuthor(rs.getString(3));
            b.setPrice(rs.getFloat(4));
            list.add(b);
        }
        rs.close();
        stm.close();
        con.close();
        return list;
    }
}