default.script

《J2EE企业级应用开发》一书的配套源代码

INSERT INTO PROFILEEJB VALUES('v55','01',false,'v55')
INSERT INTO PROFILEEJB VALUES('e1','01',false,'e1')
INSERT INTO PROFILEEJB VALUES('e2','01',false,'e2')
INSERT INTO CREDITCARDEJB VALUES('v','01','2003-04-16 09:41:45.921',NULL)
INSERT INTO CREDITCARDEJB VALUES('v5','01','2003-04-16 09:45:56.656',NULL)
INSERT INTO CREDITCARDEJB VALUES('v5t','01','2003-04-16 09:46:47.203','v55')
INSERT INTO CREDITCARDEJB VALUES('e145645','01','2003-04-16 10:11:37.25','e1')
INSERT INTO CREDITCARDEJB VALUES('e2','01','2001-05-07 13:05:46.654','e2')
INSERT INTO ACCOUNTEJB VALUES('v55','active','v5t','v5t','v55')
INSERT INTO ACCOUNTEJB VALUES('e1','active','e1','e145645','e1')
INSERT INTO ACCOUNTEJB VALUES('e2','active','e2','e2','e2')
INSERT INTO CATEGORYEJB VALUES('category_0','\u53e4\u5178\u97f3\u4e50','\u70ed\u5356\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_1','\u6e2f\u53f0\u6d41\u884c\u6b4c\u66f2','\u6700\u65b0\u7684\u6e2f\u53f0\u6b4c\u66f2')
INSERT INTO CATEGORYEJB VALUES('category_2','\u5185\u5730\u6d41\u884c\u6b4c\u66f2','\u6536\u96c6\u4e86\u51e0\u4e4e\u6240\u6709\u7684\u5185\u5730\u6d41\u884c\u97f3\u4e50')
INSERT INTO CATEGORYEJB VALUES('category_3','\u6447\u6eda\u97f3\u4e50','\u4e00\u8d77\u75af\u72c2\u5427')
INSERT INTO CATEGORYEJB VALUES('category_4','\u56fd\u5916\u7ecf\u5178','\u6536\u96c6\u4e86\u5927\u591a\u6570\u56fd\u5916\u7ecf\u5178\u6b4c\u66f2\uff0c\u6253\u6298\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_5','\u513f\u6b4c','\u6559\u80b2\u6b4c\u66f2')
INSERT INTO CATEGORYEJB VALUES('category_6','\u53e4\u7b5d\u7cbe\u9009','\u5efa\u8bbe\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_7','\u516c\u76ca\u6b4c\u66f2','\u5efa\u8bbe\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_8','\u901a\u4fd7\u97f3\u4e50','\u5efa\u8bbe\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_9','\u7f8e\u56fd\u4e61\u6751\u97f3\u4e50','\u5efa\u8bbe\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_45','\u94a2\u7434\u534f\u594f\u66f2','\u5efa\u8bbe\u4e2d')
INSERT INTO CATEGORYEJB VALUES('category_10','\u8428\u514b\u65af','\u5efa\u8bbe\u4e2d')
INSERT INTO PRODUCTEJB VALUES('product_Demo_10','\u6211\u4e0d\u70e6','\u5f6d\u6d77\u6850\u6700\u65b0\u4e13\u96c6','category_1','item_10')
INSERT INTO PRODUCTEJB VALUES('product_Demo_11','\u4f60\u7d2f\u4e86\u5417\uff1f','\u7eaa\u5982\u666f','category_1','item_11')
INSERT INTO PRODUCTEJB VALUES('product_Demo_12','\u5f53\u6211\u60f3\u5176\u4f60','\u5f20\u5b66\u53cb','category_1','item_12')
INSERT INTO PRODUCTEJB VALUES('product_Demo_13','\u6e29\u54e5\u534e\u60b2\u4f24\u4e00\u53f7','\u4e07\u65b9','category_1','item_13')
INSERT INTO PRODUCTEJB VALUES('product_Demo_14','\u98ce\u96e8\u65e0\u963b','\u5468\u534e\u5065','category_1','item_14')
INSERT INTO PRODUCTEJB VALUES('product_Demo_15','\u4e0a\u5e1d\u4fdd\u4f51','\u7ac7\u7ef4','category_1','item_15')
INSERT INTO PRODUCTEJB VALUES('product_Demo_16','\u5bbd\u5bb9','\u5f20\u4fe1\u54f2','category_1','item_16')
INSERT INTO PRODUCTEJB VALUES('product_Demo_17','\u6070\u4f3c\u4f60\u7684\u6587\u8363','\u8521\u7434','category_1','item_17')
INSERT INTO PRODUCTEJB VALUES('product_Demo_18','\u6e29\u67d4\u610f\u5fd7\u529b','\u9648\u6167\u7433','category_1','item_18')
INSERT INTO PRODUCTEJB VALUES('product_Demo_19','\u5251\u4fa0\u5947\u7f18','\u8c22\u96e8\u6b23','category_1','item_19')
INSERT INTO PRODUCTEJB VALUES('product_Demo_20','\u6211\u4e0d\u70e6','\u5f6d\u6d77\u6850\u6700\u65b0\u4e13\u96c6','category_2','item_20')
INSERT INTO PRODUCTEJB VALUES('product_Demo_21','\u4f60\u7d2f\u4e86\u5417\uff1f','\u7eaa\u5982\u666f','category_2','item_21')
INSERT INTO PRODUCTEJB VALUES('product_Demo_22','\u5f53\u6211\u60f3\u5176\u4f60','\u5f20\u5b66\u53cb','category_2','item_22')
INSERT INTO PRODUCTEJB VALUES('product_Demo_23','\u6e29\u54e5\u534e\u60b2\u4f24\u4e00\u53f7','\u4e07\u65b9','category_2','item_23')
INSERT INTO PRODUCTEJB VALUES('product_Demo_24','\u98ce\u96e8\u65e0\u963b','\u5468\u534e\u5065','category_2','item_24')
INSERT INTO PRODUCTEJB VALUES('product_Demo_25','\u4e0a\u5e1d\u4fdd\u4f51','\u7ac7\u7ef4','category_2','item_25')
INSERT INTO PRODUCTEJB VALUES('product_Demo_26','\u5bbd\u5bb9','\u5f20\u4fe1\u54f2','category_2','item_26')
INSERT INTO PRODUCTEJB VALUES('product_Demo_27','\u6070\u4f3c\u4f60\u7684\u6587\u8363','\u8521\u7434','category_2','item_27')
INSERT INTO PRODUCTEJB VALUES('product_Demo_28','\u6e29\u67d4\u610f\u5fd7\u529b','\u9648\u6167\u7433','category_2','item_28')
INSERT INTO PRODUCTEJB VALUES('product_Demo_29','\u5251\u4fa0\u5947\u7f18','\u8c22\u96e8\u6b23','category_2','item_29')
INSERT INTO PRODUCTEJB VALUES('product_Demo_30','michael jackson','\u5371\u9669\u4e4b\u65c5','category_4','item_30')
INSERT INTO ITEMEJB VALUES('item_11',34.4,NULL,'\images\41-m.gif','attr',NULL,'product_Demo_11')
INSERT INTO ITEMEJB VALUES('item_12',34.4,NULL,'\images\48-m.gif','attr',NULL,'product_Demo_12')
INSERT INTO ITEMEJB VALUES('item_13',34.4,NULL,'\images\62-m.gif','attr',NULL,'product_Demo_13')
INSERT INTO ITEMEJB VALUES('item_14',34.4,NULL,'\images\40-m.gif','attr',NULL,'product_Demo_14')
INSERT INTO ITEMEJB VALUES('item_15',34.4,NULL,'\images\57-m.gif','attr',NULL,'product_Demo_15')
INSERT INTO ITEMEJB VALUES('item_16',34.4,NULL,'\images\30.gif','attr',NULL,'product_Demo_16')
INSERT INTO ITEMEJB VALUES('item_17',34.4,NULL,'\images\30-m.gif','attr',NULL,'product_Demo_17')
INSERT INTO ITEMEJB VALUES('item_18',34.4,NULL,'\images\33-m.gif','attr',NULL,'product_Demo_18')
INSERT INTO ITEMEJB VALUES('item_19',34.4,NULL,'\images\32-m.gif','attr',NULL,'product_Demo_19')
INSERT INTO ITEMEJB VALUES('item_10',34.4,'ffffffeff0','\images\29-m.gif','attr',NULL,'product_Demo_10')
INSERT INTO ITEMEJB VALUES('item_21',34.4,NULL,'\images\41-m.gif','attr',NULL,'product_Demo_21')
INSERT INTO ITEMEJB VALUES('item_22',34.4,NULL,'\images\48-m.gif','attr',NULL,'product_Demo_22')
INSERT INTO ITEMEJB VALUES('item_23',34.4,NULL,'\images\62-m.gif','attr',NULL,'product_Demo_23')
INSERT INTO ITEMEJB VALUES('item_24',34.4,NULL,'\images\40-m.gif','attr',NULL,'product_Demo_24')
INSERT INTO ITEMEJB VALUES('item_25',34.4,NULL,'\images\57-m.gif','attr',NULL,'product_Demo_25')
INSERT INTO ITEMEJB VALUES('item_26',34.4,NULL,'\images\30.gif','attr',NULL,'product_Demo_26')
INSERT INTO ITEMEJB VALUES('item_27',34.4,NULL,'\images\30-m.gif','attr',NULL,'product_Demo_27')
INSERT INTO ITEMEJB VALUES('item_28',34.4,NULL,'\images\33-m.gif','attr',NULL,'product_Demo_28')
INSERT INTO ITEMEJB VALUES('item_29',34.4,NULL,'\images\32-m.gif','attr',NULL,'product_Demo_29')
INSERT INTO ITEMEJB VALUES('item_20',34.4,NULL,'\images\29-m.gif','attr',NULL,'product_Demo_20')
INSERT INTO ITEMEJB VALUES('item_30',34.4,NULL,'\images\54-m.gif','attr',NULL,'product_Demo_30')
INSERT INTO MEDIAEJB VALUES('media_id0','\u632a\u5a01\u7684\u68ee\u6797','2003-04-16 16:57:14.578','\mp3\lwsl.mp3','producer_0',NULL)
INSERT INTO MEDIAEJB VALUES('media_id1','\u632a\u5a01\u7684\u68ee\u6797','2003-04-16 16:57:14.593','\mp3\lwsl.mp3','producer_1',NULL)
INSERT INTO MEDIAEJB VALUES('media_id2','media_description','2003-04-16 16:57:14.609','\mp3\lwsl.mp3','producer_2',NULL)
INSERT INTO MEDIAEJB VALUES('media_id3','media_description','2003-04-16 16:57:14.609','\mp3\lwsl.mp3','producer_3',NULL)
INSERT INTO MEDIAEJB VALUES('media_id4','media_description','2003-04-16 16:57:14.625','\mp3\lwsl.mp3','producer_4',NULL)
INSERT INTO MEDIAEJB VALUES('media_id5','media_description','2003-04-16 16:57:14.64','\mp3\ww.mp3','producer_5',NULL)
INSERT INTO MEDIAEJB VALUES('media_id6','media_description','2003-04-16 16:57:14.656','\mp3\lwsl.mp3','producer_6',NULL)
INSERT INTO MEDIAEJB VALUES('media_id7','media_description','2003-04-16 16:57:14.671','\mp3\ww.mp3','producer_7',NULL)
INSERT INTO MEDIAEJB VALUES('media_id8','media_description','2003-04-16 16:57:14.687','\mp3\lwsl.mp3','producer_8',NULL)
INSERT INTO MEDIAEJB VALUES('media_id9','media_description','2003-04-16 16:57:14.687','\mp3\lwsl.mp3','producer_9',NULL)
INSERT INTO MEDIAEJB VALUES('media_id_0','media_description','2003-04-16 17:26:54.046','\mp3\lwsl.mp3','producer_0','product_Demo_10')
INSERT INTO MEDIAEJB VALUES('media_id_1','media_description','2003-04-16 17:26:54.125','\mp3\lwsl.mp3','producer_1','product_Demo_11')
INSERT INTO MEDIAEJB VALUES('media_id_2','media_description','2003-04-16 17:26:54.14','\mp3\ww.mp3','producer_2','product_Demo_12')
INSERT INTO MEDIAEJB VALUES('media_id_3','media_description','2003-04-16 17:26:54.171','\mp3\lwsl.mp3','producer_3','product_Demo_13')
INSERT INTO MEDIAEJB VALUES('media_id_4','media_description','2003-04-16 17:26:54.187','\mp3\lwsl.mp3','producer_4','product_Demo_14')
INSERT INTO MEDIAEJB VALUES('media_id_5','media_description','2003-04-16 17:26:54.203','\mp3\lwsl.mp3','producer_5','product_Demo_15')
INSERT INTO MEDIAEJB VALUES('media_id_6','media_description','2003-04-16 17:26:54.234','\mp3\ww.mp3','producer_6','product_Demo_16')
INSERT INTO MEDIAEJB VALUES('media_id_7','media_description','2003-04-16 17:26:54.25','\mp3\lwsl.mp3','producer_7','product_Demo_17')
INSERT INTO MEDIAEJB VALUES('media_id_8','media_description','2003-04-16 17:26:54.265','\mp3\lwsl.mp3','producer_8','product_Demo_18')
INSERT INTO MEDIAEJB VALUES('media_id_9','media_description','2003-04-16 17:26:54.312','\mp3\ww.mp3','producer_9','product_Demo_19')
INSERT INTO MEDIAEJB VALUES('media_id_10','media_description','2003-04-16 17:26:54.046','\mp3\lwsl.mp3','producer_0','product_Demo_20')
INSERT INTO MEDIAEJB VALUES('media_id_11','media_description','2003-04-16 17:26:54.125','\mp3\lwsl.mp3','producer_1','product_Demo_21')
INSERT INTO MEDIAEJB VALUES('media_id_12','media_description','2003-04-16 17:26:54.14','\mp3\lwsl.mp3','producer_2','product_Demo_22')
INSERT INTO MEDIAEJB VALUES('media_id_13','media_description','2003-04-16 17:26:54.171','\mp3\lwsl.mp3','producer_3','product_Demo_23')
INSERT INTO MEDIAEJB VALUES('media_id_14','media_description','2003-04-16 17:26:54.187','\mp3\lwsl.mp3','producer_4','product_Demo_24')
INSERT INTO MEDIAEJB VALUES('media_id_15','media_description','2003-04-16 17:26:54.203','\mp3\lwsl.mp3','producer_5','product_Demo_25')
INSERT INTO MEDIAEJB VALUES('media_id_16','media_description','2003-04-16 17:26:54.234','\mp3\lwsl.mp3','producer_6','product_Demo_26')
INSERT INTO MEDIAEJB VALUES('media_id_17','media_description','2003-04-16 17:26:54.25','\mp3\lwsl.mp3','producer_7','product_Demo_27')
INSERT INTO MEDIAEJB VALUES('media_id_18','media_description','2003-04-16 17:26:54.265','\mp3\lwsl.mp3','producer_8','product_Demo_28')
INSERT INTO MEDIAEJB VALUES('media_id_19','media_description','2003-04-16 17:26:54.312','\mp3\lwsl.mp3','producer_9','product_Demo_29')
INSERT INTO MEDIAEJB VALUES('media_id_20','media_description','2003-04-16 17:26:54.312','\mp3\ms.mp3','producer_9','product_Demo_30')
INSERT INTO SUPPLIEREJB VALUES('supplier_0',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_1',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_2',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_3',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_4',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_5',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_6',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_7',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_8',NULL,NULL)
INSERT INTO SUPPLIEREJB VALUES('supplier_9',NULL,NULL)
INSERT INTO USEREJB VALUES('v','v')
INSERT INTO USEREJB VALUES('v5','5')
INSERT INTO USEREJB VALUES('v55','t')
INSERT INTO USEREJB VALUES('e1','e1')
INSERT INTO USEREJB VALUES('e2','e2')
INSERT INTO BANKSERVICEEJB VALUES('e145645',9552.796,'1')