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;               }       }  };