daobook.java

网上购书系统

package datamanage.dao;

import java.util.*;

import java.sql.*;
import datamanage.ConnectDatebase.*;
import datamanage.po.PoBook;
import datamanage.ConnectDatebase;


public class DaoBook {
    public DaoBook() {

    }

    public List getCurrentPageData(int pagesize, int currentpage) {
        List list = new ArrayList();
        String sql = "select top " + pagesize +
                     " * from t_book where bookid not in " +
                     "( " +
                     "select top " + (currentpage - 1) * pagesize +
                     " bookid from t_book " +
                     ")";
        try {
            ConnectDatebase db = new ConnectDatebase();
            ResultSet rs = db.query(sql);
            while (rs.next()) {
                PoBook book = new PoBook();
                book.setBookId(rs.getInt("bookId"));
                book.setBookName(rs.getString("bookName"));
                book.setBookAuthor(rs.getString("bookAuthor"));
                book.setBookPublish(rs.getString("bookPublish"));
                book.setBookPubDate(rs.getString("bookPubDate"));
                book.setBookPrice(rs.getInt("bookPrice"));
                book.setBookNum(rs.getInt("bookNum"));
                book.setBookPath(rs.getString("bookPath"));
                list.add(book);
            }

        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return list;

    }

    public int getTotalpage(int pagesize) {
        String sql = "select count(*) from t_book";
        try {
            int size = 0;
            ConnectDatebase db = new ConnectDatebase();
            ResultSet rs = db.query(sql);
            if (rs.next()) {
                size = rs.getInt(1);
            }
            if (size / pagesize==0) {
                return size / pagesize;
            }else{
                return (size / pagesize+1);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return 1;
    }

    public boolean addBook(PoBook book) {
        ConnectDatebase cdb = new ConnectDatebase();
        String strsql = "insert into T_book values('" + book.getBookName() +
                        "','" + book.getBookAuthor() + "','" +
                        book.getBookPublish() + "','" + book.getBookPubDate() +
                        "'," + book.getBookPrice() + "," + book.getBookNum() +
                        ","+book.getBookPath()+")";
        if (cdb.add(strsql)) {
            return true;
        } else {
            return false;
        }
    }
}