在本章节中,我们将会使用下述数据表来用于演示,具体表数据如下:
-
交易信息表 transactions
其中 trans_id,acc_num,trans_time,trans_type,stock_id 均为 string 类型,price 和 amount 均为 double 类型。
trans_id acc_num trans_time trans_type stock_id price amount 943197522
6513065
20140105100520
b
AA7105670
12.13
200
929634984
3912384
20140205140521
b
UA1467891
11.11
300
499506900
6513065
20140506133109
s
CA2789982
6.12
100
209441379
3912384
20140430111523
s
CX5397790
4.50
1000
648230055
0700735
20140315111111
s
DT7966575
22.66
200
719753265
3912384
20140328102400
b
BY8490909
68.43
100
975639131
0700735
20140611102830
s
AT6934136
5.30
200
991691937
2755506
20140702113025
s
VR2575735
7.52
1300
289018112
6513065
20140916105811
b
UT7592045
9.81
500
162742112
2394923
20141031135018
s
UC1610649
12.21
500
597565609
3912384
20140214141519
s
IU1775004
4.16
600
459590958
0700735
20140430143020
b
XJ9717497
5.25
1000
594819547
5224133
20140801110003
b
GL2547626
6.36
800
895916502
6513065
20141225133500
s
KC9102028
7.49
1100
900192386
6670192
20141130113905
s
XC1915304
8.64
900
952639648
6670192
20140314145958
s
CP7629713
10.31
400
404905188
6513065
20140628133001
b
SH6277444
7.02
100
952110653
6600641
20140228140005
s
GH6828501
9.16
100
817414815
5224133
20140331115900
s
ZX5373511
10.03
800
213859826
6513065
20140508094805
b
CL2121979
18.38
700
-
用户信息表 user_info
name acc_num password citizen_id bank_acc reg_date acc_level 马**
6513065
115591
14**7
960*41
20110101
A
祝**
6670192
205239
23**8
737*71
20100101
C
华*
5224133
531547
42**1
326*07
20080214
B
魏**
3912384
841242
52**4
685*48
20091202
A
宁**
4580952
986634
42**7
977*76
20081031
D
邱*
0700735
737297
34**8
143*18
20121024
A
李*
8725869
600709
46**3
430*84
20130702
E
潘**
6600641
990590
51**5
484*08
20110430
C
李**
2755506
015859
31**9
424*37
20110916
D
管**
2394923
783438
33**4
999*74
20141003
C