javaweb开发训练项目Word文档格式.docx
《javaweb开发训练项目Word文档格式.docx》由会员分享,可在线阅读,更多相关《javaweb开发训练项目Word文档格式.docx(12页珍藏版)》请在冰点文库上搜索。
*@return添加后账务账号,包含账号账号ID
Accountsave(Accountaccount)throwsSQLException;
*修改某个账务账号的信息
*@paramaccount要修改的账务账号
*@return返回修改后的账务账号
Accountmodify(Accountaccount)throwsSQLException;
*修改某个账务账号的状态
*@paramaccount要修改状态的账务账号
*@return返回修改状态后的账务账号
AccountmodifyStatus(Accountaccount)throwsSQLException;
}
以上五个方法的作用,请参考注释部分。
5.AccountDAOImpl.java该类实现了AccountDAO接口,将该接口中的方法做出实现。
6.TestAccountDAO.java该类用于测试AccountDAOImpl所实现的方法的正确性。
1.3步骤
实现此案例需要按照如下步骤进行。
步骤一:
准备环境
首先,创建名为project的工程;
然后,在该工程下创建lib目录,存储实现该工程的功能所需的jar包;
最后,将所需的jar导入到该工程环境中。
步骤二:
创建序列、表以及向表中插入数据
首先,创建名为Account的表并向该表中插入测试数据,SQL语句如下所示:
1.createtableaccount(
2.account_idintprimarykeyauto_increment,
3.recommender_idint,
4.login_namevarchar(30)notnullunique,
5.login_passwdvarchar(30)notnull,
6.statuschar
(1)check(statusin(0,1,2))notnull,
7.create_datedatedefaultnow(),
8.pause_datedate,
9.close_datedate,
10.real_namevarchar(20)notnull,
11.idcard_nochar(18)notnullunique,
12.birthdatedate,
13.genderchar
(1)check(genderin(0,1))notnull,
14.
occupation
varchar(50),
15.
telephone
varchar(15)notnull,
16.
email
17.
mailaddress
varchar(200),
18.
zipcode
char(6),
19.
qq
varchar(15),
20.
last_login_time
date,
21.
last_login_ip
varchar(15)
22.);
INSERTINTOACCOUNT(ACCOUNT_ID,RECOMMENDER_ID,LOGIN_NAME,LOGIN_PASSWD,STATUS,CREATE_DATE,PAUSE_DATE,CLOSE_DATE,REAL_NAME,IDCARD_NO,BIRTHDATE,GENDER,OCCUPATION,TELEPHONE,EMAIL,MAILADDRESS,ZIPCODE,QQ,LAST_LOGIN_TIME,LAST_LOGIN_IP)VALUES(null,null,'
a'
'
123'
0'
now(),NULL,NULL,'
zhangsan'
1234'
‘1998-1-312:
34:
45’,'
job'
'
'
a@b.c'
testavenue'
1223'
now(),'
192'
)
步骤三:
创建据库中的Account表和Java对象的映射类Account
代码如下所示:
1.packagecom.itqf.oa.entity;
2.
3.importjava.util.Date;
4.
5.publicclassAccount{
6.
privateintid;
7.
privateintrecommenderId;
8.
privateStringloginName;
9.
privateStringloginPasswd;
10.
privateStringstatus;
11.
privateDatecreateDate;
12.
privateDatepauseDate;
13.
privateDatecloseDate;
privateStringrealName;
privateStringidcardNo;
privateDatebirthdate;
privateStringgender;
privateStringoccupation;
privateStringtelephone;
privateStringemail;
privateStringmailaddress;
22.
privateStringzipcode;
23.
privateStringqq;
24.
privateDatelastLoginTime;
25.
privateStringlastLoginIp;
26.
27.
publicAccount(){
28.
super();
29.
30.
31.
publicAccount(intid,intrecommenderId,StringloginName,
32.
StringloginPasswd,Stringstatus,DatecreateDate,DatepauseDate,
33.
DatecloseDate,StringrealName,StringidcardNo,Datebirthdate,
34.
Stringgender,Stringoccupation,Stringtelephone,Stringemail,
35.
Stringmailaddress,Stringzipcode,Stringqq,DatelastLoginTime,
36.
StringlastLoginIp){
37.
38.
this.id=id;
39.
this.recommenderId=recommenderId;
40.
this.loginName=loginName;
41.
this.loginPasswd=loginPasswd;
42.
this.status=status;
43.
this.createDate=createDate;
44.
this.pauseDate=pauseDate;
45.
this.closeDate=closeDate;
46.
this.realName=realName;
47.
this.idcardNo=idcardNo;
48.
this.birthdate=birthdate;
49.
this.gender=gender;
50.
this.occupation=occupation;
51.
this.telephone=telephone;
52.
this.email=email;
53.
this.mailaddress=mailaddress;
54.
this.zipcode=zipcode;
55.
this.qq=qq;
56.
this.lastLoginTime=lastLoginTime;
57.
this.lastLoginIp=lastLoginIp;
58.
59.
publicintgetId(){
60.
returnid;
61.
62.
publicvoidsetId(intid){
63.
64.
65.
publicintgetRecommenderId(){
66.
returnrecommenderId;
67.
68.
publicvoidsetRecommenderId(intrecommenderId){
69.
70.
71.
publicStringgetLoginName(){
72.
returnloginName;
73.
74.
publicvoidsetLoginName(StringloginName){
75.
76.
77.
publicStringgetLoginPasswd(){
78.
returnloginPasswd;
79.
80.
publicvoidsetLoginPasswd(StringloginPasswd){
81.
82.
83.
publicStringgetStatus(){
84.
returnstatus;
85.
86.
publicvoidsetStatus(Stringstatus){
87.
88.
89.
publicDategetCreateDate(){
90.
returncreateDate;
91.
92.
publicvoidsetCreateDate(DatecreateDate){
93.
94.
95.
publicDategetPauseDate(){
96.
returnpauseDate;
97.
98.
publicvoidsetPauseDate(DatepauseDate){
99.
100.
101.
publicDategetCloseDate(){
102.
returncloseDate;
103.
104.
publicvoidsetCloseDate(DatecloseDate){
105.
106.
107.
publicStringgetRealName(){
108.
returnrealName;
109.
110.
publicvoidsetRealName(StringrealName){
111.
112.
113.
publicStringgetIdcardNo(){
114.
returnidcardNo;
115.
116.
publicvoidsetIdcardNo(StringidcardNo){
117.
118.
119.
publicDategetBirthdate(){
120.
returnbirthdate;
121.
122.
publicvoidsetBirthdate(Datebirthdate){
123.
124.
125.
publicStringgetGender(){
126.
returngender;
127.
128.
publicvoidsetGender(Stringgender){
129.
130.
131.
publicStringgetOccupation(){
132.
returnoccupation;
133.
134.
publicvoidsetOccupation(Stringoccupation){
135.
136.
137.
publicStringgetTelephone(){
138.
returntelephone;
139.
140.
publicvoidsetTelephone(Stringtelephone){
141.
142.
143.
publicStringgetEmail(){
144.
returnemail;
145.
146.
publicvoidsetEmail(Stringemail){
147.
148.
149.
publicStringgetMailaddress(){
150.
returnmailaddress;
151.
152.
publicvoidsetMailaddress(Stringmailaddress){
153.
154.
155.
publicStringgetZipcode(){
156.
returnzipcode;
157.
158.
publicvoidsetZipcode(Stringzipcode){
159.
160.
161.
publicStringgetQq(){
162.
returnqq;
163.
164.
publicvoidsetQq(Stringqq){
165.
166.
167.
publicDategetLastLoginTime(){
168.
returnlastLoginTime;
169.
170.
publicvoidsetLastLoginTime(DatelastLoginTime){
171.
172.
173.
publicStringgetLastLoginIp(){
174.
returnlastLoginIp;
175.
176.
publicvoidsetLastLoginIp(StringlastLoginIp){
177.
178.
179.
publicStringtoString(){
180.
System.out.println("
id="
+id);
181.
recommenderId="
+recommenderId);
182.
loginName="
+loginName);
183.
loginPasswd="
+loginPasswd);
184.
status="
+status);
185.
createDate="
+createDate);
186.
pauseDate="
+pauseDate);
187.
closeDate="
+closeDate);
188.
realName="
+realName);
189.
idcardNo="
+idcardNo);
190.
birthdate="
+birthdate);
191.
gender="
+gender);
192.
occupation="
+occupation);
193.
telephone="
+telephone);
194.
email="
+email);
195.
mailaddress="
+mailaddress);
196.