op_book.java~99~

基于JSP的网上书店.功能较为全面 开发环境:sql server2000+tomcat+jdk

package bookshop.run;
/**
* <p>管理图书的类，包括图书的修改、查询，删除，添加 </p>
*/
import java.sql.*;
import java.util.Vector;
import bookshop.util.*;
import bookshop.book.*;
import bookshop.run.*;
import javax.servlet.http.*;

public class op_book //extends DataBase{
{
    private javax.servlet.http.HttpServletRequest request;		//建立页面请求
    private book abooks = new book();			//新的图书类
    private boolean sqlflag = true ;			//对接收到的数据是否正确
    private Vector booklist;					//显示图书列表向量数组
    private int page = 1;						//显示的页码
    private int pageSize=3;						//每页显示的图书数
    private int pageCount =0;					//页面总数
    private long recordCount =0;				//查询的记录总数

    public String sqlStr="";
    private ResultSet rs;

    public Vector getBooklist()
    {
        return booklist;
    }
    public boolean getSqlflag()
    {
        return sqlflag;
    }
    public String to_String( String str)
    {
        try
        {
            return new String(str.getBytes("ISO8859-1"));
        }
        catch (Exception e)
        {
            return str;
        }
    }
    public void finalize()
    {
        //super.finalize();
    }

    /**
    * 将页面表单传来的资料分解
    */
    public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest)
    {
        boolean flag = false;
        try
        {
            request = newrequest;
            String ID = request.getParameter("id");
            long bookid = 0;
            try
            {
                bookid = Long.parseLong(ID);
            }
            catch (Exception e)
            {
            }
            abooks.setId(bookid);
            String bookname = request.getParameter("bookname");
            if (bookname==null || bookname.equals(""))
            {
                bookname = "";
                sqlflag = false;
            }
            abooks.setBookName((bookname));
            String author = request.getParameter("author");
            if (author==null || author.equals(""))
            {
                author = "";
                sqlflag = false;
            }
            abooks.setAuthor((author));
            String publish = request.getParameter("publish");;
            if (publish==null)
            {
                publish = "";
            }
            abooks.setPublish((publish));
            String bookclass = request.getParameter("bookclass");
            int bc = Integer.parseInt(bookclass);
            abooks.setBookClass(bc);
            String bookno = request.getParameter("bookno");
            if (bookno == null)
            {
                bookno = "";
            }
            abooks.setBookNo((bookno));
            String picture = request.getParameter("picture");
            if (picture == null)
            {
                picture = "images/01.gif";
            }
            abooks.setPicture((picture));
            float price;
            try
            {
                price =new Float(request.getParameter("price")).floatValue();
            } catch (Exception e)
            {
                price = 0;
                sqlflag = false;
            }
            abooks.setPrice(price);
            int amount;
            try
            {
                amount = new Integer(request.getParameter("amount")).intValue();
            }
            catch (Exception e)
            {
                sqlflag = false;
                amount = 0;
            }
            abooks.setAmount(amount);

            //int amount;
            try
            {
                amount = new Integer(request.getParameter("leavenum")).intValue();
            }
            catch (Exception e)
            {
                //sqlflag = false;
                amount = 0;
            }
            abooks.setLeav_number(amount);

            String content = request.getParameter("content");
            if (content == null)
            {
                content = "";
            }
            abooks.setContent((content));
            if (sqlflag)
            {
                flag = true;
            }
            return flag;
        }
        catch (Exception e)
        {
            return flag;
        }
    }
    /**
    * 获得查询图书类别的sql语句
    * @return
    */
    public String getSql()
    {
        sqlStr = "select id,classname from book order by id";
        return sqlStr;
    }
    /**
    * 完成图书查询，包括分类，分页查询
    * @param res
    * @return
    * @throws java.lang.Exception
    */
    public boolean book_search(HttpServletRequest res) throws Exception
    {
        DataBase db = new DataBase();
        //db.connect();
        //stmt = db.conn.createStatement ();
        request = res;
        String PAGE = request.getParameter("page");         //页码
        String classid = request.getParameter("classid");	//分类ID号
        String keyword = request.getParameter("keyword");	//查询关键词
        float   fRate = 1;

        HttpSession session = res.getSession(false);
        if (session == null)
        {
            return false;
        }

        String szUserId = (String) session.getAttribute("userid"); //取得用户ID号
        op_user opUser = new op_user();
        fRate = opUser.getUserRate(szUserId);

        keyword = dataFormat.toSql(keyword);

        if (classid==null) classid="";
        if (keyword==null) keyword = "";
        keyword = (keyword).toUpperCase();
        try
        {
            page = Integer.parseInt(PAGE);
        }
        catch (NumberFormatException e)
        {
            page = 1;
        }
        //取出记录数
        sqlStr = "SELECT COUNT(*) FROM book WHERE 1=1 "; // 注意这里1=1的妙用
        if( !classid.equals("") )
        {
            sqlStr = sqlStr + " AND bookclass='"+classid + "'";
        }
        if (!keyword.equals(""))
        {
            sqlStr = sqlStr + " AND  (UPPER(bookname) LIKE '%" +keyword+ "%' OR "+
                "UPPER(content) LIKE '%" + keyword + "%')";
        }

        int rscount = pageSize;
        try
        {
            ResultSet rs1 = db.stmt.executeQuery(sqlStr);
            if (rs1.next()) recordCount = rs1.getInt(1);
            rs1.close();
        }
        catch (SQLException e)
        {
            System.out.println(e.getMessage());
            return false;
        }
        //设定有多少pageCount
        if (recordCount < 1)
        {
            pageCount = 0;
        }
        else
        {
            pageCount = (int) (recordCount - 1) / pageSize + 1;
        }
        //检查查看的页面数是否在范围内
        if (page < 1)
        {
            page = 1;
        }
        else if (page > pageCount)
        {
            page = pageCount;
        }