?? categorymanager.java
字號(hào):
package proxy;
import java.sql.*;
import connector.Searcher;
public class CategoryManager {
private static Searcher s = new Searcher();
private static ExecutorProxy e = new ExecutorProxy();
public static int[] insertCategories(Statement stmt) throws SQLException,
BatchUpdateException {
/* String insert = "";
for (int i = 0; i < 9; i++, insert = "") {
insert += "insert into category values ('C" + i + "','Cname" + i
+ "'); ";
stmt.addBatch(insert);
}
return stmt.executeBatch();*/
insert("Cno01","Life");
insert("Cno02","Sinence");
insert("Cno03","Children");
insert("Cno04","Literate");
insert("Cno05","Literature");
insert("Cno06","Novel");
return null;
}
public static int insert(String Cno, String Cname) {
String query = "insert into Category values(" + Checker.checkNull(Cno)
+ "," + Checker.checkNull(Cname) + ");";
return e.execute(query);
}
public static int insert(String[] args) {
if (args.length != 2) {
System.err.print("CategoryManeger arguments input error.");
return -1;
}
String query = "insert into Category values(";
return e.execute(Checker.argsInsert(query, args));
}
public static int deleteByCno(String Cno) {
String query = "delete from Category where Cno =" + Checker.checkNull(Cno)
+ ";";
return e.execute(query);
}
public static String getNewCategoryID(){
String ID = pre;
String last = s.getLastID(TablesManager.category);
if(last == null) return "Cno00";
int num = Integer.parseInt(last.substring(3));
num++;
last = String.valueOf(num);
for(int i = last.length() ;i< 2;i++)
ID = ID.concat("0");
ID = ID.concat(last);
return ID;
}
private static final String pre = "Cno";
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -