介绍:
1.综述Struts2框架对当今社会的发展作用;
2.了解火车票网上注册、登录、查询、订购流程;
3.熟悉Struts2框架结构;
4.设计基于JAVA、Struts2的火车票订购系统;
5. 深入分析系统开发的设计流程;
6.熟练掌握基于JAVA、Struts2火车票订购系统的代码编写;
7.设计与实现基于Struts2框架的火车票订购系统的程序。
截图:
数据库表:
CREATE TABLE t_admin
(
userId
int(11) NOT NULL,
userName
varchar(66) default NULL,
userPw
longtext,
PRIMARY KEY (userId
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Table structure for t_checi
CREATE TABLE t_checi
(
id
int(11) NOT NULL,
shifazhan
varchar(66) default NULL,
daodazhan
varchar(50) default NULL,
piaoshijian
varchar(50) default NULL,
startshijian
varchar(50) default NULL,
endshijian
varchar(50) default NULL,
piaojia
int(11) default NULL,
piaoshu
int(11) default NULL,
del
longtext,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Table structure for t_gonggao
CREATE TABLE t_gonggao
(
gonggao_id
int(11) NOT NULL,
gonggao_title
varchar(66) default NULL,
gonggao_content
longtext,
gonggao_data
varchar(50) default NULL,
gonggao_fabuzhe
tinytext,
gonggao_del
varchar(50) default NULL,
gonggao_one1
varchar(50) default NULL,
gonggao_one2
varchar(50) default NULL,
gonggao_one3
longtext,
gonggao_one4
varchar(50) default NULL,
gonggao_one5
datetime default NULL,
gonggao_one6
datetime default NULL,
gonggao_one7
int(11) default NULL,
gonggao_one8
int(11) default NULL,
PRIMARY KEY (gonggao_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Table structure for t_liuyan
CREATE TABLE t_liuyan
(
liuyan_id
int(11) NOT NULL,
liuyan_title
varchar(66) default NULL,
liuyan_content
longtext,
liuyan_date
varchar(50) default NULL,
liuyan_user
longtext,
PRIMARY KEY (liuyan_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Table structure for t_user
CREATE TABLE t_user
(
user_id
int(11) NOT NULL,
user_name
varchar(66) default NULL,
user_pw
longtext,
user_type
int(11) default NULL,
user_realname
varchar(50) default NULL,
user_address
varchar(50) default NULL,
user_sex
varchar(50) default NULL,
user_tel
varchar(50) default NULL,
user_email
varchar(50) default NULL,
user_qq
varchar(50) default NULL,
user_man
varchar(50) default NULL,
user_age
varchar(50) default NULL,
user_birthday
varchar(50) default NULL,
user_xueli
varchar(50) default NULL,
user_one1
varchar(50) default NULL,
user_one2
varchar(50) default NULL,
user_one3
varchar(50) default NULL,
user_one4
varchar(50) default NULL,
user_one5
varchar(50) default NULL,
user_one6
int(11) default NULL,
user_one7
int(11) default NULL,
user_one8
int(11) default NULL,
user_one9
datetime default NULL,
user_one10
datetime default NULL,
user_one11
decimal(19,0) default NULL,
user_one12
decimal(19,0) default NULL,
PRIMARY KEY (user_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Table structure for t_yuding
CREATE TABLE t_yuding
(
yuding_id
int(11) NOT NULL,
user_id
int(11) default NULL,
checi_id
int(11) default NULL,
yuding_shumu
int(11) default NULL,
yuding_jine
varchar(66) default NULL,
zhifufangshi
varchar(50) default NULL,
yuding_shijian
longtext,
yuding_zhuantai
int(11) default NULL,
PRIMARY KEY (yuding_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;