2.Benchmark SQL 数据库测试工具代码——关于表类
欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/50357456
关于表的关系,可以参考之前的一篇文章,连接如下:
http://blog.csdn.net/notbaron/article/details/50287473
1. CUSTOMER
import java.io.Serializable;
publicclass Customerimplements Serializable{
publicint c_id;
publicint c_d_id;
publicint c_w_id;
publicint c_payment_cnt;
publicint c_delivery_cnt;
publiclong c_since;
publicfloat c_discount;
publicfloat c_credit_lim;
publicfloat c_balance;
publicfloat c_ytd_payment;
public Stringc_credit;
public Stringc_last;
public Stringc_first;
public Stringc_street_1;
public Stringc_street_2;
public Stringc_city;
public Stringc_state;
public Stringc_zip;
public Stringc_phone;
public Stringc_middle;
public Stringc_data;
public String toString()
{
java.sql.Timestamp since = new java.sql.Timestamp(c_since);
return (
"\n***************** Customer ********************" +
"\n* c_id = " + c_id +
"\n* c_d_id = " + c_d_id +
"\n* c_w_id = " + c_w_id +
"\n* c_discount = " + c_discount +
"\n* c_credit = " + c_credit +
"\n* c_last = " + c_last +
"\n* c_first = " + c_first +
"\n* c_credit_lim = " + c_credit_lim +
"\n* c_balance = " + c_balance +
"\n* c_ytd_payment = " + c_ytd_payment +
"\n* c_payment_cnt = " + c_payment_cnt +
"\n* c_delivery_cnt = " + c_delivery_cnt +
"\n* c_street_1 = " + c_street_1 +
"\n* c_street_2 = " + c_street_2 +
"\n* c_city = " + c_city +
"\n* c_state = " + c_state +
"\n* c_zip = " + c_zip +
"\n* c_phone = " + c_phone +
"\n* c_since = " + since +
"\n* c_middle = " + c_middle +
"\n* c_data = " + c_data +
"\n**********************************************"
);
}
} // end Customer
2. DISTRICT
importjava.io.Serializable;
publicclass DistrictimplementsSerializable {
publicint d_id;
publicint d_w_id;
publicint d_next_o_id;
publicfloat d_ytd;
publicfloat d_tax;
public Stringd_name;
public Stringd_street_1;
public Stringd_street_2;
public Stringd_city;
public Stringd_state;
public Stringd_zip;
public String toString()
{
return (
"\n***************** District ********************" +
"\n* d_id = " + d_id +
"\n* d_w_id = " + d_w_id +
"\n* d_ytd = " + d_ytd +
"\n* d_tax = " + d_tax +
"\n* d_next_o_id = " + d_next_o_id +
"\n* d_name = " + d_name +
"\n* d_street_1 = " + d_street_1 +
"\n* d_street_2 = " + d_street_2 +
"\n* d_city = " + d_city +
"\n* d_state = " + d_state +
"\n* d_zip = " + d_zip+
"\n**********************************************"
);
}
} // end District
3. WAREHOUSE
importjava.io.Serializable;
publicclass Warehouseimplements Serializable{
publicint w_id; // PRIMARY KEY
publicfloat w_ytd;
publicfloat w_tax;
public Stringw_name;
public Stringw_street_1;
public Stringw_street_2;
public Stringw_city;
public Stringw_state;
public Stringw_zip;
public String toString()
{
return (
"\n***************** Warehouse ********************" +
"\n* w_id = " + w_id +
"\n* w_ytd = " + w_ytd +
"\n* w_tax = " + w_tax +
"\n* w_name = " + w_name +
"\n* w_street_1 = " + w_street_1 +
"\n* w_street_2 = " + w_street_2 +
"\n* w_city = " + w_city +
"\n* w_state = " + w_state +
"\n* w_zip = " + w_zip +
"\n**********************************************"
);
}
} // end Warehouse
4. HISTORY
importjava.io.Serializable;
publicclass HistoryimplementsSerializable {
publicint hist_id;
publicint h_c_id;
publicint h_c_d_id;
publicint h_c_w_id;
publicint h_d_id;
publicint h_w_id;
publiclong h_date;
publicfloat h_amount;
public Stringh_data;
public String toString()
{
return (
"\n***************** History ********************" +
"\n* h_c_id = " + hist_id +
"\n* h_c_id = " + h_c_id +
"\n* h_c_d_id = " + h_c_d_id +
"\n* h_c_w_id = " + h_c_w_id +
"\n* h_d_id = " + h_d_id +
"\n* h_w_id = " + h_w_id +
"\n* h_date = " + h_date +
"\n* h_amount = " + h_amount +
"\n* h_data = " + h_data +
"\n**********************************************"
);
}
} // end History
5. OORDER
importjava.io.Serializable;
publicclass OorderimplementsSerializable {
publicint o_id;
publicint o_w_id;
publicint o_d_id;
publicint o_c_id;
publicint o_carrier_id;
publicint o_ol_cnt;
publicint o_all_local;
publiclong o_entry_d;
public String toString()
{
java.sql.Timestamp entry_d = new java.sql.Timestamp(o_entry_d);
return (
"\n***************** Oorder ********************" +
"\n* o_id = " + o_id +
"\n* o_w_id = " + o_w_id +
"\n* o_d_id = " + o_d_id +
"\n* o_c_id = " + o_c_id +
"\n* o_carrier_id = " + o_carrier_id +
"\n* o_ol_cnt = " + o_ol_cnt +
"\n* o_all_local = " + o_all_local +
"\n* o_entry_d = " + entry_d +
"\n**********************************************"
);
}
} // end Oorder
6. NEW_ORDER
importjava.io.Serializable;
publicclass NewOrderimplements Serializable{
publicint no_w_id;
publicint no_d_id;
publicint no_o_id;
public String toString()
{
return (
"\n***************** NewOrder ********************" +
"\n* no_w_id = " + no_w_id +
"\n* no_d_id = " + no_d_id +
"\n* no_o_id = " + no_o_id +
"\n**********************************************"
);
}
} // end NewOrder
7. ORDER_LINE
importjava.io.Serializable;
publicclass OrderLineimplementsSerializable {
publicint ol_w_id;
publicint ol_d_id;
publicint ol_o_id;
publicint ol_number;
publicint ol_i_id;
publicint ol_supply_w_id;
publicint ol_quantity;
publiclong ol_delivery_d;
publicfloat ol_amount;
public Stringol_dist_info;
public String toString()
{
return (
"\n***************** OrderLine ********************" +
"\n* ol_w_id = " + ol_w_id +
"\n* ol_d_id = " + ol_d_id +
"\n* ol_o_id = " + ol_o_id +
"\n* ol_number = " + ol_number +
"\n* ol_i_id = " + ol_i_id +
"\n* ol_delivery_d = " + ol_delivery_d +
"\n* ol_amount = " + ol_amount +
"\n* ol_supply_w_id = " + ol_supply_w_id +
"\n* ol_quantity = " + ol_quantity +
"\n* ol_dist_info = " + ol_dist_info +
"\n**********************************************"
);
}
} // end OrderLine
8. STOCK
importjava.io.Serializable;
publicclass StockimplementsSerializable {
publicint s_i_id; //PRIMARY KEY 2
publicint s_w_id; //PRIMARY KEY 1
publicint s_order_cnt;
publicint s_remote_cnt;
publicint s_quantity;
publicfloat s_ytd;
public Strings_data;
public Strings_dist_01;
public Strings_dist_02;
public Strings_dist_03;
public Strings_dist_04;
public Strings_dist_05;
public Strings_dist_06;
public Strings_dist_07;
public Strings_dist_08;
public Strings_dist_09;
public Strings_dist_10;
public String toString()
{
return (
"\n***************** Stock ********************" +
"\n* s_i_id = " + s_i_id +
"\n* s_w_id = " + s_w_id +
"\n* s_quantity = " + s_quantity +
"\n* s_ytd = " + s_ytd +
"\n* s_order_cnt = " + s_order_cnt +
"\n* s_remote_cnt = " + s_remote_cnt +
"\n* s_data = " + s_data +
"\n* s_dist_01 = " + s_dist_01 +
"\n* s_dist_02 = " + s_dist_02 +
"\n* s_dist_03 = " + s_dist_03 +
"\n* s_dist_04 = " + s_dist_04 +
"\n* s_dist_05 = " + s_dist_05 +
"\n* s_dist_06 = " + s_dist_06 +
"\n* s_dist_07 = " + s_dist_07 +
"\n* s_dist_08 = " + s_dist_08 +
"\n* s_dist_09 = " + s_dist_09 +
"\n* s_dist_10 = " + s_dist_10 +
"\n**********************************************"
);
}
} // end Stock
9. ITEM
importjava.io.Serializable;
publicclass ItemimplementsSerializable {
publicint i_id; // PRIMARY KEY
publicint i_im_id;
publicfloat i_price;
public Stringi_name;
public Stringi_data;
public String toString()
{
return (
"\n***************** Item ********************" +
"\n* i_id = " + i_id +
"\n* i_name = " + i_name +
"\n* i_price = " + i_price +
"\n* i_data = " + i_data +
"\n* i_im_id = " + i_im_id +
"\n**********************************************"
);
}
} // end Item