op_cdclass.java

java+javabean开发的一套网上购物系统.

package cdshop.run;
/**
 * <p>Title: </p>
 */
import java.util.*;
import cdshop.util.*;
import cdshop.cd.*;
import java.sql.*;
import java.lang.String;
import javax.servlet.http.HttpServletRequest;

public class op_cdclass extends DataBase{
  public op_cdclass() {
  }
  private cdclass cdclass = new cdclass(); //新的CD分类
  private javax.servlet.http.HttpServletRequest request; //建立页面请求
  private Vector classlist;		//CD类别向量数组
  public Vector getClasslist() {
        return classlist;
          }
  public String getcdClassSql() {
                  sqlStr = "select id,classname from cdclass order by id";
                  return sqlStr;
          }
          //查询CD分类
  public boolean seachcdClass() throws Exception {
                  int id = 0;
                  String classname = "";
                  int rscount = 0;
                  try {
                  DataBase db = new DataBase();
                  db.connect();
                  stmt = db.conn.createStatement ();
                  rs = stmt.executeQuery(getcdClassSql());
                  rscount = stmt.getMaxRows();
                  classlist = new Vector(rscount+1);
                  classlist.clear();
                  while (rs.next()){
                                  id = rs.getInt("id");
                                  classname = rs.getString("classname");
                                  cdclass bc = new cdclass(id,classname);
                                  classlist.addElement(bc);
                          }
                          close();
                          return true;
                  }
                  catch (SQLException sqle){
                          System.out.println(sqle);
              return false;
                  }
          }
          //添加新CD分类时获得页面转递的分类名称
public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
     boolean flag = false;
     try{
         request = newrequest;
         String cdclassname = request.getParameter("cdclassname");
          if (cdclassname==null || cdclassname.equals("")){
              cdclassname = "";
              flag = false;
              }
              cdclass.setClassName(cdclassname);
              return true;
          }catch (Exception e){
            return false;
            }
    }
    //添加新的CD分类
        public boolean insert() throws Exception {
           sqlStr = "insert into cdclass (classname) values ('";
           sqlStr = sqlStr + dataFormat.toGb(cdclass.getClassName()) + "')";
                      try
                      {      System.out.print(sqlStr);
                        DataBase db = new DataBase();
                              db.connect();
                              stmt =db.conn.createStatement ();
                              stmt.execute(sqlStr);
                              return true;
                      }
                      catch (SQLException sqle)
                      {        System.out.print(sqle.getMessage());
                              return false;
                      }
              }
          //删除CD分类
          public boolean delete( int aid ) throws Exception {
               sqlStr = "delete from cdclass 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;
               }
       }
  };