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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Windows编程 > 数据库编程 > 查看源码
op_bookclass.java~6~
资源名称：bookshop.zip　[点击查看]
上传用户：sxlinghang
上传日期：2022-07-20
资源大小：1405k
文件大小：4k
源码类别：

数据库编程

开发平台：

Java

op_bookclass.java~6~：源码内容
  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.util.*;
  12. import bookshop.util.*;
  13. import bookshop.book.*;
  14. import java.sql.*;
  15. import java.lang.String;
  16. import javax.servlet.http.HttpServletRequest;
  18. public class op_bookclass extends DataBase{
  19.   public op_bookclass() {
  20.   }
  21.   private bookclass bookclass = new bookclass(); //新的图书分类
  22.   private javax.servlet.http.HttpServletRequest request; //建立页面请求
  23.   private Vector classlist; //图书类别向量数组
  24.   public Vector getClasslist() {
  25.         return classlist;
  26.           }
  28.   public String getBookClassSql() {
  29.                   sqlStr = "select id,classname from bookclass order by id";
  30.                   return sqlStr;
  31.           }
  33.   public boolean seachBookClass() throws Exception {
  34.                   int id = 0;
  35.                   String classname = "";
  36.                   int rscount = 0;
  37.                   try {
  38.                     DataBase db = new DataBase();
  39.                    db.connect();
  40.                    stmt = db.conn.createStatement ();
  42.                           rs = stmt.executeQuery(getBookClassSql());
  43.                           rscount = stmt.getMaxRows();
  44.                           classlist = new Vector(rscount+1);
  45.                           classlist.clear();
  46.                           while (rs.next()){
  47.                                   id = rs.getInt("id");
  48.                                   classname = rs.getString("classname");
  49.                                   bookclass bc = new bookclass(id,classname);
  50.                                   classlist.addElement(bc);
  51.                           }
  52.                           rs.close();
  53.                           return true;
  54.                   }
  55.                   catch (SQLException sqle){
  56.                           System.out.println(sqle);
  57.               return false;
  58.                   }
  59.           }
  60.           public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
  61.                          boolean flag = false;
  62.                         try{
  63.                                  request = newrequest;
  64.                                  String bookclassname = request.getParameter("bookclassname");
  65.                                  if (bookclassname==null || bookclassname.equals(""))
  66.                                  {
  67.                                          bookclassname = "";
  68.                                          flag = false;
  69.                                  }
  70.                                  bookclass.setClassName(bookclassname);
  71.                                 return true;
  72.                         }catch (Exception e){
  73.                           return false;
  74.                         }
  76.                  }
  77.                  public boolean insert() throws Exception {
  78.                       sqlStr = "insert into bookclass (classname) values ('";
  79.                       sqlStr = sqlStr + dataFormat.toSql(bookclass.getClassName()) + "')";
  81.                       try
  82.                       {      System.out.print(sqlStr);
  83.                         DataBase db = new DataBase();
  84.                               db.connect();
  85.                               stmt =db.conn.createStatement ();
  86.                               stmt.execute(sqlStr);
  88.                               return true;
  89.                       }
  90.                       catch (SQLException sqle)
  91.                       {        System.out.print(sqle.getMessage());
  92.                               return false;
  93.                       }
  94.               }
  95.               public boolean delete( int aid ) throws Exception {
  97.                sqlStr = "delete from bookclass where id = "  + aid ;
  98.                try
  99.                {         DataBase db = new DataBase();
  100.                           db.connect();
  101.                           stmt =db.conn.createStatement ();
  103.                        stmt.execute(sqlStr);
  104.                        return true;
  105.                }
  106.                catch (SQLException e)
  107.                {
  108.                        System.out.println(e);
  109.                        return false;
  110.                }
  111.        }
  115.   };