?? op_bookclass.java
字號:
package bookshop.run;/** * <p>Title: </p> */import java.util.*;import bookshop.util.*;import bookshop.book.*;import java.sql.*;import java.lang.String;import javax.servlet.http.HttpServletRequest;public class op_bookclass extends DataBase{ public op_bookclass() { } private bookclass bookclass = new bookclass(); //新的圖書分類 private javax.servlet.http.HttpServletRequest request; //建立頁面請求 private Vector classlist; //圖書類別向量數組 public Vector getClasslist() { return classlist; } public String getBookClassSql() { sqlStr = "select id,classname from bookclass order by id"; return sqlStr; } //查詢圖書分類 public boolean seachBookClass() throws Exception { int id = 0; String classname = ""; int rscount = 0; try { DataBase db = new DataBase(); db.connect(); stmt = db.conn.createStatement (); rs = stmt.executeQuery(getBookClassSql()); rscount = stmt.getMaxRows(); classlist = new Vector(rscount+1); classlist.clear(); while (rs.next()){ id = rs.getInt("id"); classname = rs.getString("classname"); bookclass bc = new bookclass(id,classname); classlist.addElement(bc); } rs.close(); return true; } catch (SQLException sqle){ System.out.println(sqle); return false; } } //添加新圖書分類時獲得頁面轉遞的分類名稱public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) { boolean flag = false; try{ request = newrequest; String bookclassname = request.getParameter("bookclassname"); if (bookclassname==null || bookclassname.equals("")){ bookclassname = ""; flag = false; } bookclass.setClassName(bookclassname); return true; }catch (Exception e){ return false; } } //添加新的圖書分類 public boolean insert() throws Exception { sqlStr = "insert into bookclass (classname) values ('"; sqlStr = sqlStr + dataFormat.toSql(bookclass.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; } } //添加新的圖書分類 public boolean delete( int aid ) throws Exception { sqlStr = "delete from bookclass 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; } } };
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -