?? 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 classname = request.getParameter("bookclassname");
String bookclassname = new String(classname.getBytes("ISO8859-1"));
if (bookclassname==null || bookclassname.equals("")){
bookclassname = "";
flag = false;
}
bookclass.setClassName(bookclassname);
String bookclassid = request.getParameter("bookclassid");
if (bookclassid==null || bookclassid.equals("")){
bookclassid = "";
flag = false;
}
bookclass.setId(Integer.parseInt(bookclassid));
System.out.println("bookclassname="+bookclassname);
return true;
}catch (Exception e){
return false;
}
}
//添加新的圖書分類
public boolean insert() throws Exception {
sqlStr = "insert into bookclass ( Id,ClassName) values ('";
sqlStr = sqlStr + bookclass.getId() + "','";
sqlStr = sqlStr + dataFormat.toSql(bookclass.getClassName()) + "')";
try
{ System.out.print("book class sqlStr="+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 + -