📄 tpch2.java
字号:
System.out.println("---------------");
System.out.println("this query used " + interval + " miniseconds");
//System.out.println(set);
//System.out.println(set.size());
} catch (Exception ex) {
ex.printStackTrace();
}
}
//this function is never used,it is just a template function for copy!
private void displayResultSet(ResultSet rs)throws SQLException {
// 取得结果集元数据
ResultSetMetaData rsmd = rs.getMetaData();
// 取得结果集所包含的列数
int numCols = rsmd.getColumnCount();
// 显示列标头
for (int i = 1; i <= numCols; i++) {
if (i > 1)
System.out.print(",");
System.out.print(rsmd.getColumnLabel(i));
}
System.out.println("");
while (rs.next()) {
for (int i = 1; i <= numCols; i++) {
if (i > 1)
System.out.print(",");
System.out.print(rs.getString(i));
}
System.out.println("");
}
}
//this function use to get indent
private int getIndent(HashMap map, int no, Date o) {
for (int i = 0; i < map.size(); i++) {
if (((PairRange)map.get(i + 1)).contains(no, o)) {
return i + 1;
}
}
return 0;
}
private int getIndent2(HashMap map, int no, BigDecimal bg) {
for (int i = 0; i < map.size(); i++) {
if (((PairRange)map.get(i + 1)).contains(no, bg)) {
//System.out.println("here");
return i + 1;
}
}
return 0;
}
private int getIndent3(HashMap map, int no, Integer value) {
for (int i = 0; i < map.size(); i++) {
if (((PairRange)map.get(i + 1)).contains(no, value)) {
//System.out.println("here");
return i + 1;
}
}
return 0;
}
private int _getIndent(HashMap map, Date date) {
for (int i = 0; i < map.size(); i++) {
if (((PairRange)map.get(i + 1)).contains(date)) {
return i + 1;
}
}
return 0;
}
private int getIndent_(HashMap map, Date date) {
for (int i = map.size(); i > 0; i--) {
if (((PairRange)map.get(i)).contains(date)) {
return i;
}
}
return 0;
}
private int _getIndent2(HashMap map, BigDecimal bg) {
for (int i = 0; i < map.size(); i++) {
if (((PairRange)map.get(i + 1)).contains(bg)) {
return i + 1;
}
}
return 0;
}
private int getIndent2_(HashMap map, BigDecimal bg) {
for (int i = map.size(); i > 0; i--) {
if (((PairRange)map.get(i)).contains(bg)) {
return i;
}
}
return 0;
}
private int _getIndent3(HashMap map, Integer value) {
for (int i = 0; i < map.size(); i++) {
if (((PairRange)map.get(i + 1)).contains(value)) {
return i + 1;
}
}
return 0;
}
private int getIndent3_(HashMap map, Integer value) {
for (int i = map.size(); i > 0; i--) {
if (((PairRange)map.get(i)).contains(value)) {
return i;
}
}
return 0;
}
private int getIndent4(int xx) {
for (int i = 0; i < map4.size(); i++) {
if (((IntRange)map4.get(i + 1)).contains(xx)) {
return i + 1;
}
}
return 0;
}
private long getInterval(long xx, long yy) {
long t = (yy - xx);
return t;
}
//test whether the Range class works!
public void test() {
for (int i = 0; i < map1.size(); i++) {
((PairRange)map1.get(i + 1)).print();
}
for (int i = 0; i < map2.size(); i++) {
((PairRange)map2.get(i + 1)).print();
}
for (int i = 0; i < map3.size(); i++) {
((PairRange)map3.get(i + 1)).print();
}
for (int i = 0; i < map7.size(); i++) {
((PairRange)map7.get(i + 1)).print();
}
/*for (int i = 0; i < map4.size(); i++) {
((PairRangeRange)map4.get(i + 1)).print();
}*/
}
public static void usage() {
System.out.println("usage: you can type those options below");
System.out.println("[options]: createEncItem:encrypt the lineitem");
System.out.println(" createEncCust:encrypt the customer");
System.out.println(" createEncOrders:encrypt the orders");
System.out.println(" doQuery1:execute the tpch query1");
System.out.println(" doQuery2:execute the tpch query2");
System.out.println("----------------------------------------------");
}
/*public class VectorSort implements Comparator {
public int compare(Object a, Object b) {
int i, j, k;
String aStr, bStr;
aStr = (String)a;
bStr = (String)b;
// find index of beginning of last name
i = aStr.indexOf('|');
j = bStr.indexOf('|');
k = aStr.substring(i).compareTo(bStr.substring(j));
if (k == 0) // last names match, check entire name
return aStr.compareTo(bStr);
else
return k;
}
public static void main(String[] args) {
TreeSet tm = new TreeSet(new TreeSetSort());
tm.add("1|1984-01-23");
tm.add("2|1983-01-23");
tm.add("9|1984-08-15");
tm.add("3|1988-09-8");
tm.add("4|1997-04-27");
tm.add("7|1984-08-15");
System.out.println(tm.toString());
}
}*/
public static void main(String args[]) {
/* try {
if (args.length != 1) {
TPCH2.usage();
} else {
TPCH2 tpch2 = new TPCH2();
if (args[0].equals("-createEncItem")) {
tpch2.createEncItem();
} else if (args[0].equals("-createEncCust")) {
tpch2.createEncCust();
} else if (args[0].equals("-createEncOrders")) {
tpch2.createEncOrders();
} else if (args[0].equals("-doQuery1")) {
tpch2.doQuery1();
} else if (args[0].equals("-doQuery2")) {
tpch2.doQuery2();
} else if (args[0].equals("-test")) {
tpch2.test();
} else {
TPCH2.usage();
}
tpch2.disConnect();
}
} catch (Exception ex) {
ex.printStackTrace();
}*/
try {
TPCH2 tpch2 = new TPCH2();
TPCH2.usage();
String cmd;
BufferedReader in = new BufferedReader(new InputStreamReader(System.in));
while (!(cmd = in.readLine()).equals("exit")) {
if (cmd.equals("createEncItem")) {
tpch2.createEncItem();
System.out.println("done!");
System.out.println("***********");
} else if (cmd.equals("createEncCust")) {
tpch2.createEncCust();
System.out.println("done!");
System.out.println("***********");
} else if (cmd.equals("createEncOrders")) {
tpch2.createEncOrders();
System.out.println("done!");
System.out.println("***********");
} else if (cmd.equals("doQuery1")) {
tpch2.doQuery1();
} else if (cmd.equals("doQuery2")) {
tpch2.doQuery2();
} /*else if (cmd.equals("insertCust")) {
//String sql = "insert into customer values(1511, 'Customer#000001501', '4zaoUzuXYTNFiNPbmu42', 6, '16-225-722-4890', 2576.62, 'MACHINERY', 'insert test')";
tpch2.insertCust();
} else if (cmd.equals("delFromCust")) {
tpch2.delFromCust();
} else if (cmd.equals("updateCust")) {
tpch2.updateCust();
}*/ else {
TPCH2.usage();
}
}
tpch2.disConnect();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -