?? ordersmanager.java
字號:
package proxy;
import java.sql.*;
import connector.Searcher;
public class OrdersManager {
private static Searcher s = new Searcher();
private static ExecutorProxy e = new ExecutorProxy();
public static int[] insertOrders(Statement stmt) throws SQLException,
BatchUpdateException {
/* for(int i=0;i<10;i++){
insert("Ono"+i, "CID"+i%5, "shipment"+i,"2007-6-"+i, "2008-1-"+i) ;
}*/
insert("Ono00001","CID0001","next day delivery","2007-01-15","2007-01-14");
insert("Ono00002","CID0002","regular post","2007-04-10","2007-04-09");
insert("Ono00003","CID0008","regular post","2007-05-09","2007-05-08");
insert("Ono00004","CID0009","regular post","2007-02-22","2007-02-21");
insert("Ono00005","CID0010","next day delivery","2007-03-26","2007-03-24");
insert("Ono00006","CID0016","regular post","2007-04-14","2007-04-12");
insert("Ono00007","CID0017","next day delivery","2007-01-16","2007-01-15");
insert("Ono00008","CID0018","regular post","2007-04-11","2007-04-10");
insert("Ono00009","CID0019","regular post","2007-05-10","2007-05-09");
insert("Ono00010","CID0020","regular post","2007-02-23","2007-02-22");
insert("Ono00011","CID0003","next day delivery","2007-03-27","2007-03-25");
insert("Ono00012","CID0020","regular post","2007-04-15","2007-04-13");
insert("Ono00013","CID0001","next day delivery","2007-01-17","2007-01-16");
insert("Ono00014","CID0004","regular post","2007-04-12","2007-04-11");
insert("Ono00015","CID0005","regular post","2007-05-11","2007-05-10");
insert("Ono00016","CID0006","regular post","2007-02-24","2007-02-23");
insert("Ono00017","CID0007","next day delivery","2007-03-28","2007-03-26");
insert("Ono00018","CID0008","regular post","2007-04-16","2007-04-14");
insert("Ono00019","CID0009","next day delivery","2007-01-18","2007-01-17");
insert("Ono00020","CID0013","regular post","2007-04-13","2007-04-12");
insert("Ono00021","CID0011","regular post","2007-05-12","2007-05-11");
insert("Ono00022","CID0012","regular post","2007-02-25","2007-02-24");
insert("Ono00023","CID0011","next day delivery","2007-03-29","2007-03-27");
insert("Ono00024","CID0014","regular post","2007-04-17","2007-04-15");
insert("Ono00025","CID0015","next day delivery","2007-01-19","2007-01-18");
insert("Ono00026","CID0016","regular post","2007-04-14","2007-04-13");
insert("Ono00027","CID0017","regular post","2007-05-13","2007-05-12");
insert("Ono00028","CID0018","regular post","2007-02-26","2007-02-25");
insert("Ono00029","CID0019","next day delivery","2007-03-30","2007-03-28");
insert("Ono00030","CID0020","regular post","2007-04-18","2007-04-16");
return null;
}
public static int insert(String[] args) {
if (args.length != 5) {
System.err.print("PromotionManeger arguments input error.");
return -1;
}
String query = "insert into Orders values(";
return e.execute(Checker.argsInsert(query, args));
}
public static int insert(String Ono, String CID, String shipment,
String shippingDate, String dateArrived) {
String query = "insert into Orders values(" + Checker.checkNull(Ono) + ","
+ Checker.checkNull(CID) + "," + Checker.checkNull(shipment) + ","
+ Checker.checkNull(shippingDate) + ","
+ Checker.checkNull(dateArrived) + ");";
return e.execute(query);
}
public static int deleteByOno(String Ono) {
String query = "delete from Orders where Ono= " + Checker.checkNull(Ono)
+ ";";
return e.execute(query);
}
public static String getNewOrderID(){
String ID = pre;
String last = s.getLastID(TablesManager.orders);
if(last == null) return "Ono00000";
int num = Integer.parseInt(last.substring(3));
num++;
last = String.valueOf(num);
for(int i = last.length() ;i< 5;i++)
ID = ID.concat("0");
ID = ID.concat(last);
return ID;
}
private static final String pre = "Ono";
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -