?? op_book.java~23~
字號:
package bookshop.run;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2004</p> * <p>Company: </p> * @author not attributable * @version 1.0 */import java.sql.*;import java.util.Vector;import bookshop.util.*;import bookshop.book.*;import javax.servlet.http.HttpServletRequest;public class op_book extends DataBase{ private book abooks = new book(); //新的圖書類 private javax.servlet.http.HttpServletRequest request; //建立頁面請求 private boolean sqlflag = true ; //對接收到的數據是否正確 private Vector booklist; //顯示圖書列表向量數組 private int page = 1; //顯示的頁碼 private int pageSize=10; //每頁顯示的圖書數 private int pageCount =0; //頁面總數 private long recordCount =0; //查詢的記錄總數 public String sqlStr=""; 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 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; } String author = request.getParameter("author"); if (author==null || author.equals("")) { author = ""; sqlflag = false; } abooks.setAuthor(to_String(author)); String publish = request.getParameter("publish");; if (publish==null) { publish = ""; } abooks.setPublish(to_String(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(to_String(bookno)); String picture = request.getParameter("picture"); if (picture == null) { picture = "images/01.gif"; } abooks.setPicture(to_String(picture)); float price; try { price =new Float(request.getParameter("price")).floatValue(); } catch (Exception e) { price = 0; sqlflag = false; } abooks.setPrince(price); int amount; try { amount = new Integer(request.getParameter("amount")).intValue(); } catch (Exception e) { sqlflag = false; amount = 0; } abooks.setAmount(amount); String content = request.getParameter("content"); if (content == null) { content = ""; } abooks.setContent(to_String(content)); if (sqlflag) { flag = true; } return flag; } catch (Exception e) { return flag; } } public String getSql() { sqlStr = "select id,classname from book order by id"; return sqlStr; } public boolean book_search(HttpServletRequest res) throws Exception { DataBase db = new DataBase(); db.connect(); stmt = db.conn.createStatement (); // System.out.println("aaaaaaaa"); request = res; String PAGE = request.getParameter("page"); //頁碼 String classid = request.getParameter("classid"); //分類ID號 String keyword = request.getParameter("keyword"); //查詢關鍵詞 if (classid==null) classid=""; if (keyword==null) keyword = ""; keyword = to_String(keyword).toUpperCase(); try { page = Integer.parseInt(PAGE); } catch (NumberFormatException e) { page = 1; } //取出記錄數 if (!classid.equals("") && keyword.equals("") ) { sqlStr = "select count(*) from book where bookclass='" + classid + "'"; } else if (!keyword.equals("")) { if (classid.equals("")) { sqlStr = "select count(*) from book where upper(bookname) like '%" +keyword+ "%' or upper(content) like '%" + keyword + "%'"; } else { sqlStr = "select count(*) from book where bookclass='" + classid + "' and (upper(bookname) like '%" +keyword+ "%' or upper(content) like '%" + keyword + "%')"; } } else { sqlStr = "select count(*) from book"; } int rscount = pageSize; try { ResultSet rs1 = stmt.executeQuery(sqlStr); if (rs1.next()) recordCount = rs1.getInt(1); rs1.close(); } catch (SQLException e) { System.out.println(e.getMessage()); return false; } //設定有多少pageCount System.out.println("kkkkk"+recordCount); if (recordCount < 1) pageCount = 0; else pageCount = (int)(recordCount - 1) / pageSize + 1; //檢查查看的頁面數是否在范圍內 if (page < 1) page = 1; else if (page > pageCount) page = pageCount; //System.out.println("bbbbbbbbbbbbb"); rscount = (int) recordCount % pageSize; // 最后一頁記錄數 //System.out.println("ccccccccccc"); //sql為倒序取值 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 "; // System.out.print("ccc"+sqlStr); if (!classid.equals("") && keyword.equals("") ){ //如果類別不為空，非查詢 if (page == 1) { sqlStr = sqlStr + " and a.bookclass='" + classid + "' order by a.Id desc"; } else { sqlStr = sqlStr + " and a.bookclass='" + classid + "limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1)); } } else if (!keyword.equals("")) { //如果是查詢資料?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -