op_book.java~18~

基于b/s的网上书店

                        if (page == 1)
                        {
                                if (!classid.equals(""))  //查询某一类
                                {
                                        sqlStr = sqlStr + "and a.Bookclass='" + classid + "' and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%')  order by a.Id desc";
                                } else {		//查询所有类
                                        sqlStr = sqlStr + " and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%') order by a.Id desc";
                                }
                        } else {
                                if (!classid.equals(""))
                                {
                                        sqlStr = sqlStr + " and a.Bookclass='" + classid + "' and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%') limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1));
                                } else {
                                        sqlStr = sqlStr + " and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%') limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1));
                                }
                        }

                } else {		//非查询，也非分类浏览
                        if (page == 1)
                        {
                                sqlStr = sqlStr + "  order by a.Id desc limit 0,"+pageSize;
                        } else {
                                sqlStr = sqlStr + "limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1));
                        }
                }

                try
                {       //System.out.println(sqlStr);

                       rs = stmt.executeQuery(sqlStr);
                        booklist = new Vector(rscount);
                        while (rs.next())
                        {
                                book book = new book();
                                book.setId(rs.getLong("id"));
                                book.setBookName(rs.getString("bookname"));
                                book.setBookClass(rs.getInt("bookclass"));
                                book.setClassname(rs.getString("classname"));
                                book.setAuthor(rs.getString("author"));
                                book.setPublish(rs.getString("publish"));
                                book.setBookNo(rs.getString("Bookno"));
                                book.setContent(rs.getString("content"));
                                book.setPrince(rs.getFloat("prince"));
                                book.setAmount(rs.getInt("amount"));
                                book.setLeav_number(rs.getInt("leav_number"));
                                book.setRegTime(rs.getString("regtime"));
                                book.setPicture(rs.getString("picture"));
                                booklist.addElement(book);
                        }
                        rs.close();
                        return true;
                }
                catch (Exception e)
                {

                        System.out.println(e.getMessage());
                        return false;
                }


        }

        public boolean insert() throws Exception {
                sqlStr = "insert into book (Bookname,Bookclass,Author,Publish,Bookno,Content,Prince,Amount,Leav_number,Regtime,picture) values ('";
                sqlStr = sqlStr + dataFormat.toSql(abooks.getBookName()) + "','";
                sqlStr = sqlStr + abooks.getBookClass() + "','";
                sqlStr = sqlStr + dataFormat.toSql(abooks.getAuthor()) + "','";
                sqlStr = sqlStr + dataFormat.toSql(abooks.getPublish()) + "','";
                sqlStr = sqlStr + dataFormat.toSql(abooks.getBookNo()) + "','";
                sqlStr = sqlStr + dataFormat.toSql(abooks.getContent()) + "','";
                sqlStr = sqlStr + abooks.getPrince() + "','";
                sqlStr = sqlStr + abooks.getAmount() + "','";
                sqlStr = sqlStr + abooks.getLeav_number() + "',";
                sqlStr = sqlStr + "now()"+ "'";
                sqlStr = sqlStr + abooks.getPicture()+"'";
                try
                {       DataBase db = new DataBase();
                        db.connect();
                        stmt =db.conn.createStatement ();
                        stmt.execute(sqlStr);
                        return true;
                }
                catch (SQLException sqle)
                {
                        return false;
                }
        }

        public boolean update() throws Exception {
                sqlStr = "update book set ";
                sqlStr = sqlStr + "bookname = '" + dataFormat.toSql(abooks.getBookName()) + "',";
                sqlStr = sqlStr + "bookclass = '" + abooks.getBookClass() + "',";
                sqlStr = sqlStr + "Author = '" + dataFormat.toSql(abooks.getAuthor()) + "',";
                sqlStr = sqlStr + "publish = '" + dataFormat.toSql(abooks.getPublish()) + "',";
                sqlStr = sqlStr + "bookno = '" + dataFormat.toSql(abooks.getBookNo()) + "',";
                sqlStr = sqlStr + "content = '" + dataFormat.toSql(abooks.getContent()) + "',";
                sqlStr = sqlStr + "prince = '" + abooks.getPrince() + "',";
                sqlStr = sqlStr + "Amount = '" + abooks.getAmount() + "',";
                sqlStr = sqlStr + "leav_number = '" + abooks.getLeav_number()+ "' ";
                sqlStr = sqlStr + "picture = '" + abooks.getPicture() + "' ";
                sqlStr = sqlStr + "where id = '" + abooks.getId() + "'";
                System.out.println(sqlStr);
                try
                {
                        DataBase db = new DataBase();
                        db.connect();
                        stmt =db.conn.createStatement ();
                        stmt.execute(sqlStr);
                        return true;
                }
                catch (SQLException e)
                {        System.out.print(e.getMessage());
                        return false;
                }

        }

        public boolean delete( int aid ) throws Exception {

                sqlStr = "delete from book where id = "  + aid ;
                try
                {         DataBase db = new DataBase();
                           db.connect();
                           stmt =db.conn.createStatement ();

                        stmt.execute(sqlStr);
                        return true;
                }
                catch (SQLException e)
                {
                        System.out.println(e);
                        return false;
                }
        }

        public boolean getOnebook(int newid ) throws Exception {
          DataBase db = new DataBase();
                           db.connect();
                           stmt =db.conn.createStatement ();

                try
                {
                        sqlStr="select  a.id,a.bookname,a.bookclass,b.classname,a.author,a.publish,a.bookno,a.content,a.prince,a.amount,a.Leav_number,a.regtime,a.picture from book a,bookclass b where a.Bookclass=b.Id and a.Id = " + newid ;

                        rs = stmt.executeQuery(sqlStr);

                        if (rs.next())
                        {	booklist = new Vector(1);
                                book book = new book();
                                book.setId(rs.getLong("id"));
                                book.setBookName(rs.getString("bookname"));
                                book.setBookClass(rs.getInt("bookclass"));
                                book.setClassname(rs.getString("classname"));
                                book.setAuthor(rs.getString("author"));
                                book.setPublish(rs.getString("publish"));
                                book.setBookNo(rs.getString("Bookno"));
                                book.setContent(rs.getString("content"));
                                book.setPrince(rs.getFloat("prince"));
                                book.setAmount(rs.getInt("amount"));
                                book.setLeav_number(rs.getInt("leav_number"));
                                book.setRegTime(rs.getString("regtime"));
                                book.setPicture(rs.getString("picture"));
                                booklist.addElement(book);
                        } else {
                                rs.close();
                                return false;
                        }
                        rs.close();
                        return true;
                }
                catch (SQLException e)
                {
                        return false;
                }

        }

        public int getPage() {				//显示的页码
                return page;
        }
        public void setPage(int newpage) {
                page = newpage;
        }

        public int getPageSize(){			//每页显示的图书数
                return pageSize;
        }
        public void setPageSize(int newpsize) {
                pageSize = newpsize;
        }

        public int getPageCount() {				//页面总数
                return pageCount;
        }
        public void setPageCount(int newpcount) {
                pageCount = newpcount;
        }

        public long getRecordCount() {
                return recordCount;
        }
        public void setRecordCount(long newrcount) {
                recordCount= newrcount;
        }





  public op_book() {
  }


}