开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
op_book.java~17~
资源名称：bookshop(jsp+mysql).rar　[点击查看]
上传用户：tanyanyong
上传日期：2013-06-23
资源大小：1355k
文件大小：18k
源码类别：

电子政务应用

开发平台：

MultiPlatform

op_book.java~17~：源码内容
  1. package bookshop.run;
  3. /**
  4.  * <p>Title: </p>
  5.  * <p>Description: </p>
  6.  * <p>Copyright: Copyright (c) 2004</p>
  7.  * <p>Company: </p>
  8.  * @author not attributable
  9.  * @version 1.0
  10.  */
  11. import java.sql.*;
  12. import java.util.Vector;
  13. import bookshop.util.*;
  14. import bookshop.book.*;
  15. import javax.servlet.http.HttpServletRequest;
  17. public class op_book extends DataBase{
  18.   private book abooks = new book();                        //新的图书类
  19.         private javax.servlet.http.HttpServletRequest request; //建立页面请求
  20.         private boolean sqlflag = true ;        //对接收到的数据是否正确
  21.         private Vector booklist;        //显示图书列表向量数组
  22.         private int page = 1;        //显示的页码
  23.         private int pageSize=10; //每页显示的图书数
  24.         private int pageCount =0; //页面总数
  25.         private long recordCount =0;         //查询的记录总数
  26.         public String sqlStr="";
  29.         public Vector getBooklist() {
  30.                 return booklist;
  31.         }
  33.         public boolean getSqlflag() {
  34.                 return sqlflag;
  35.         }
  37.         public String to_String( String str) {
  38.                 try
  39.                 {
  40.                         return new String(str.getBytes("ISO8859-1"));
  41.                 }
  42.                 catch (Exception e)
  43.                 {
  44.                         return str;
  45.                 }
  46.         }
  48.         //将页面表单传来的资料分解
  49.         public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
  50.                 boolean flag = false;
  51.                 try
  52.                 {
  53.                         request = newrequest;
  54.                         String ID = request.getParameter("id");
  55.                         long bookid = 0;
  56.                         try
  57.                         {
  58.                                 bookid = Long.parseLong(ID);
  59.                         }
  60.                         catch (Exception e)
  61.                         {
  62.                         }
  63.                         abooks.setId(bookid);
  64.                         String bookname = request.getParameter("bookname");
  65.                         if (bookname==null || bookname.equals(""))
  66.                         {
  67.                                 bookname = "";
  68.                                 sqlflag = false;
  69.                         }
  70.                         abooks.setBookName(to_String(bookname));
  71.                         String author = request.getParameter("author");
  72.                         if (author==null || author.equals(""))
  73.                         {
  74.                                 author = "";
  75.                                 sqlflag = false;
  76.                         }
  77.                         abooks.setAuthor(to_String(author));
  78.                         String publish = request.getParameter("publish");;
  79.                         if (publish==null)
  80.                         {
  81.                                 publish = "";
  82.                         }
  83.                         abooks.setPublish(to_String(publish));
  84.                         String bookclass = request.getParameter("bookclass");
  85.                         int bc = Integer.parseInt(bookclass);
  86.                         abooks.setBookClass(bc);
  87.                         String bookno = request.getParameter("bookno");
  88.                         if (bookno == null)
  89.                         {
  90.                                 bookno = "";
  91.                         }
  92.                         abooks.setBookNo(to_String(bookno));
  93.                         String picture = request.getParameter("picture");
  94.                         if (picture == null)
  95.                         {
  96.                                 picture = "";
  97.                         }
  98.                         abooks.setPicture(to_String(picture));
  100.                         float price;
  101.                         try {
  102.                                 price =new Float(request.getParameter("price")).floatValue();
  103.                         }
  104.                         catch (Exception e)
  105.                         {
  106.                                 price = 0;
  107.                                 sqlflag = false;
  108.                         }
  109.                         abooks.setPrince(price);
  110.                         int amount;
  111.                         try
  112.                         {
  113.                                 amount = new Integer(request.getParameter("amount")).intValue();
  114.                         }
  115.                         catch (Exception e)
  116.                         {
  117.                                 sqlflag = false;
  118.                                 amount = 0;
  119.                         }
  120.                         abooks.setAmount(amount);
  121.                         String content = request.getParameter("content");
  122.                         if (content == null)
  123.                         {
  124.                                 content = "";
  125.                         }
  126.                         abooks.setContent(to_String(content));
  127.                         if (sqlflag)
  128.                         {
  129.                                 flag = true;
  130.                         }
  131.                         return flag;
  132.                 }
  133.                 catch (Exception e)
  134.                 {
  135.                         return flag;
  136.                 }
  137.         }
  139.         public String getSql() {
  140.                 sqlStr = "select id,classname from book order by id";
  141.                 return sqlStr;
  142.         }
  145.         public boolean book_search(HttpServletRequest res) throws Exception {
  146.           DataBase db = new DataBase();
  147.                    db.connect();
  148.                    stmt = db.conn.createStatement ();
  149.                 // System.out.println("aaaaaaaa");
  150.                 request = res;
  151.                 String PAGE = request.getParameter("page");   //页码
  152.                 String classid = request.getParameter("classid"); //分类ID号
  153.                 String keyword = request.getParameter("keyword"); //查询关键词
  154.                 if (classid==null) classid="";
  155.                 if (keyword==null) keyword = "";
  156.                 keyword = to_String(keyword).toUpperCase();
  157.                 try
  158.                 {
  159.                         page = Integer.parseInt(PAGE);
  160.                 }
  161.                 catch (NumberFormatException e)
  162.                 {
  163.                         page = 1;
  164.                 }
  166.                 //取出记录数
  167.                 if (!classid.equals("") && keyword.equals("") ) {
  168.                         sqlStr = "select count(*) from book where bookclass='" + classid + "'";
  169.                 } else if (!keyword.equals("")) {
  170.                         if (classid.equals(""))
  171.                         {
  172.                                 sqlStr = "select count(*) from book where upper(bookname) like '%" +keyword+ "%' or upper(content) like '%" + keyword + "%'";
  173.                         } else {
  174.                                 sqlStr = "select count(*) from book where bookclass='" + classid + "' and  (upper(bookname) like '%" +keyword+ "%' or upper(content) like '%" + keyword + "%')";
  175.                         }
  176.                 } else {
  177.                         sqlStr = "select count(*) from book";
  178.                 }
  180.                 int rscount = pageSize;
  181.                 try
  182.                 {
  183.                         ResultSet rs1 = stmt.executeQuery(sqlStr);
  184.                         if (rs1.next()) recordCount = rs1.getInt(1);
  185.                         rs1.close();
  186.                 }
  187.                 catch (SQLException e)
  188.                 {        System.out.println(e.getMessage());
  189.                         return false;
  190.                 }
  191.                 //设定有多少pageCount
  192.                 System.out.println("kkkkk"+recordCount);
  193.                 if (recordCount < 1)
  194.             pageCount = 0;
  195.         else
  196.             pageCount = (int)(recordCount - 1) / pageSize + 1;
  197.                 //检查查看的页面数是否在范围内
  198.                 if (page < 1)
  199.             page = 1;
  200.         else if (page > pageCount)
  201.             page = pageCount;
  202.  //System.out.println("bbbbbbbbbbbbb");
  203.                 rscount = (int) recordCount % pageSize;  // 最后一页记录数
  204.  //System.out.println("ccccccccccc");
  205.                 //sql为倒序取值
  206.                 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 ";
  207.                 // System.out.print("ccc"+sqlStr);
  208.                 if (!classid.equals("") && keyword.equals("") ){  //如果类别不为空，非查询
  209.                         if (page == 1)
  210.                         {
  211.                                 sqlStr = sqlStr + " and a.bookclass='" + classid + "' order by a.Id desc";
  212.                         } else {
  213.                                 sqlStr = sqlStr + " and a.bookclass='" + classid + "limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1));
  214.                         }
  215.                 } else if (!keyword.equals("")) {  //如果是查询资料
  216.                         if (page == 1)
  217.                         {
  218.                                 if (!classid.equals(""))  //查询某一类
  219.                                 {
  220.                                         sqlStr = sqlStr + "and a.Bookclass='" + classid + "' and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%')  order by a.Id desc";
  221.                                 } else { //查询所有类
  222.                                         sqlStr = sqlStr + " and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%') order by a.Id desc";
  223.                                 }
  224.                         } else {
  225.                                 if (!classid.equals(""))
  226.                                 {
  227.                                         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));
  228.                                 } else {
  229.                                         sqlStr = sqlStr + " and (upper(a.bookname) like '%" +keyword+ "%' or upper(a.content) like '%" + keyword + "%') limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1));
  230.                                 }
  231.                         }
  233.                 } else { //非查询，也非分类浏览
  234.                         if (page == 1)
  235.                         {
  236.                                 sqlStr = sqlStr + "  order by a.Id desc limit 0,"+pageSize;
  237.                         } else {
  238.                                 sqlStr = sqlStr + "limit "+(recordCount-pageSize * page)+","+(recordCount-pageSize * (page-1));
  239.                         }
  240.                 }
  242.                 try
  243.                 {       //System.out.println(sqlStr);
  245.                        rs = stmt.executeQuery(sqlStr);
  246.                         booklist = new Vector(rscount);
  247.                         while (rs.next())
  248.                         {
  249.                                 book book = new book();
  250.                                 book.setId(rs.getLong("id"));
  251.                                 book.setBookName(rs.getString("bookname"));
  252.                                 book.setBookClass(rs.getInt("bookclass"));
  253.                                 book.setClassname(rs.getString("classname"));
  254.                                 book.setAuthor(rs.getString("author"));
  255.                                 book.setPublish(rs.getString("publish"));
  256.                                 book.setBookNo(rs.getString("Bookno"));
  257.                                 book.setContent(rs.getString("content"));
  258.                                 book.setPrince(rs.getFloat("prince"));
  259.                                 book.setAmount(rs.getInt("amount"));
  260.                                 book.setLeav_number(rs.getInt("leav_number"));
  261.                                 book.setRegTime(rs.getString("regtime"));
  262.                                 book.setPicture(rs.getString("picture"));
  263.                                 booklist.addElement(book);
  264.                         }
  265.                         rs.close();
  266.                         return true;
  267.                 }
  268.                 catch (Exception e)
  269.                 {
  271.                         System.out.println(e.getMessage());
  272.                         return false;
  273.                 }
  276.         }
  278.         public boolean insert() throws Exception {
  279.                 sqlStr = "insert into book (Bookname,Bookclass,Author,Publish,Bookno,Content,Prince,Amount,Leav_number,Regtime,picture) values ('";
  280.                 sqlStr = sqlStr + dataFormat.toSql(abooks.getBookName()) + "','";
  281.                 sqlStr = sqlStr + abooks.getBookClass() + "','";
  282.                 sqlStr = sqlStr + dataFormat.toSql(abooks.getAuthor()) + "','";
  283.                 sqlStr = sqlStr + dataFormat.toSql(abooks.getPublish()) + "','";
  284.                 sqlStr = sqlStr + dataFormat.toSql(abooks.getBookNo()) + "','";
  285.                 sqlStr = sqlStr + dataFormat.toSql(abooks.getContent()) + "','";
  286.                 sqlStr = sqlStr + abooks.getPrince() + "','";
  287.                 sqlStr = sqlStr + abooks.getAmount() + "','";
  288.                 sqlStr = sqlStr + abooks.getLeav_number() + "',";
  289.                 sqlStr = sqlStr + "now()"+ "'";
  290.                 sqlStr = sqlStr + abooks.getPicture()+"'";
  291.                 try
  292.                 {       DataBase db = new DataBase();
  293.                         db.connect();
  294.                         stmt =db.conn.createStatement ();
  295.                         stmt.execute(sqlStr);
  296.                         return true;
  297.                 }
  298.                 catch (SQLException sqle)
  299.                 {
  300.                         return false;
  301.                 }
  302.         }
  304.         public boolean update() throws Exception {
  305.                 sqlStr = "update book set ";
  306.                 sqlStr = sqlStr + "bookname = '" + dataFormat.toSql(abooks.getBookName()) + "',";
  307.                 sqlStr = sqlStr + "bookclass = '" + abooks.getBookClass() + "',";
  308.                 sqlStr = sqlStr + "Author = '" + dataFormat.toSql(abooks.getAuthor()) + "',";
  309.                 sqlStr = sqlStr + "publish = '" + dataFormat.toSql(abooks.getPublish()) + "',";
  310.                 sqlStr = sqlStr + "bookno = '" + dataFormat.toSql(abooks.getBookNo()) + "',";
  311.                 sqlStr = sqlStr + "content = '" + dataFormat.toSql(abooks.getContent()) + "',";
  312.                 sqlStr = sqlStr + "prince = '" + abooks.getPrince() + "',";
  313.                 sqlStr = sqlStr + "Amount = '" + abooks.getAmount() + "',";
  314.                 sqlStr = sqlStr + "leav_number = '" + abooks.getLeav_number()+ "' ";
  315.                 sqlStr = sqlStr + "picture = '" + abooks.getPicture() + "' ";
  316.                 sqlStr = sqlStr + "where id = '" + abooks.getId() + "'";
  317.                 System.out.println(sqlStr);
  318.                 try
  319.                 {
  320.                         DataBase db = new DataBase();
  321.                         db.connect();
  322.                         stmt =db.conn.createStatement ();
  323.                         stmt.execute(sqlStr);
  324.                         return true;
  325.                 }
  326.                 catch (SQLException e)
  327.                 {        System.out.print(e.getMessage());
  328.                         return false;
  329.                 }
  331.         }
  333.         public boolean delete( int aid ) throws Exception {
  335.                 sqlStr = "delete from book where id = "  + aid ;
  336.                 try
  337.                 {         DataBase db = new DataBase();
  338.                            db.connect();
  339.                            stmt =db.conn.createStatement ();
  341.                         stmt.execute(sqlStr);
  342.                         return true;
  343.                 }
  344.                 catch (SQLException e)
  345.                 {
  346.                         System.out.println(e);
  347.                         return false;
  348.                 }
  349.         }
  351.         public boolean getOnebook(int newid ) throws Exception {
  352.           DataBase db = new DataBase();
  353.                            db.connect();
  354.                            stmt =db.conn.createStatement ();
  356.                 try
  357.                 {
  358.                         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 ;
  360.                         rs = stmt.executeQuery(sqlStr);
  362.                         if (rs.next())
  363.                         { booklist = new Vector(1);
  364.                                 book book = new book();
  365.                                 book.setId(rs.getLong("id"));
  366.                                 book.setBookName(rs.getString("bookname"));
  367.                                 book.setBookClass(rs.getInt("bookclass"));
  368.                                 book.setClassname(rs.getString("classname"));
  369.                                 book.setAuthor(rs.getString("author"));
  370.                                 book.setPublish(rs.getString("publish"));
  371.                                 book.setBookNo(rs.getString("Bookno"));
  372.                                 book.setContent(rs.getString("content"));
  373.                                 book.setPrince(rs.getFloat("prince"));
  374.                                 book.setAmount(rs.getInt("amount"));
  375.                                 book.setLeav_number(rs.getInt("leav_number"));
  376.                                 book.setRegTime(rs.getString("regtime"));
  377.                                 book.setPicture(rs.getString("picture"));
  378.                                 booklist.addElement(book);
  379.                         } else {
  380.                                 rs.close();
  381.                                 return false;
  382.                         }
  383.                         rs.close();
  384.                         return true;
  385.                 }
  386.                 catch (SQLException e)
  387.                 {
  388.                         return false;
  389.                 }
  391.         }
  393.         public int getPage() { //显示的页码
  394.                 return page;
  395.         }
  396.         public void setPage(int newpage) {
  397.                 page = newpage;
  398.         }
  400.         public int getPageSize(){ //每页显示的图书数
  401.                 return pageSize;
  402.         }
  403.         public void setPageSize(int newpsize) {
  404.                 pageSize = newpsize;
  405.         }
  407.         public int getPageCount() { //页面总数
  408.                 return pageCount;
  409.         }
  410.         public void setPageCount(int newpcount) {
  411.                 pageCount = newpcount;
  412.         }
  414.         public long getRecordCount() {
  415.                 return recordCount;
  416.         }
  417.         public void setRecordCount(long newrcount) {
  418.                 recordCount= newrcount;
  419.         }
  425.   public op_book() {
  426.   }
  429. }