?? promotionlistmanager.java
字號:
package proxy;
import java.sql.*;
public class PromotionListManager {
private static ExecutorProxy e = new ExecutorProxy();
public static int[] insertPromotionLists(Statement stmt)
throws SQLException, BatchUpdateException {
/* for (int i = 0; i < 20; i++) {
insert("Pn"+i%5, "BID"+i);
} */
insert("Pno001","BID00001");
insert("Pno004","BID00001");
insert("Pno003","BID00003");
insert("Pno005","BID00004");
insert("Pno002","BID00009");
insert("Pno006","BID00012");
return null;
}
public static int insert(String[] args) {
if (args.length != 2) {
System.err.print("PromotionListManeger arguments input error.");
return -1;
}
String query = "insert into PromotionList values(";
return e.execute(Checker.argsInsert(query, args));
}
public static int insert(String Pno, String BID) {
String query = "insert into PromotionList values("
+ Checker.checkNull(Pno) + "," + Checker.checkNull(BID) + ");";
return e.execute(query);
}
public static int deleteByBID(String BID) {
String query = "delete from PromotionList where BID ="
+ Checker.checkNull(BID) + ";";
return e.execute(query);
}
public static int deleteByPno(String Pno) {
String query = "delete from PromotionList where Pno ="
+ Checker.checkNull(Pno) + ";";
return e.execute(query);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -