Spring + Struts + hibernate + Ajax Forum, blog, online mall system source code for free download

Complete e-commerce project source code

Http: // 58.16.209.155: 9080/htmis/public/bookstoressh.rar

SSH electronic Mall (Electric Appliance sales project)

Http: // 58.16.209.155: 9080/htmis/public/BBS/market.rar

SSH framework student management system source code

Http: // 58.16.209.155: 9080/htmis/public/studentmanager.rar

Forum source code

Http: // 58.16.209.155: 9080/htmis/public/bbs.rar

Blog system

Http: // 58.16.209.155: 9080/htmis/public/pbenblog.rar

# SQL Manager 2005 Lite for MySQL 3.6.5.8
#---------------------------------------
# HOST: localhost
# Port: 3306
# Database: blognew

Set foreign_key_checks = 0;

Create Database 'blognew'
Character Set 'gb2312'
Collate 'gb2312 _ chinese_ci ';

#
# Structure for the 'bl _ article' table:
#

Create Table 'bl _ article '(
'Id' bigint (20) not null auto_increment,
'Blogid' bigint (20) default null,
'Blogname' varchar (50) default null,
'Title' varchar (100) not null default '',
'Content' text,
'Userid' bigint (20) not null default '0 ',
'Username' varchar (200) not null default '',
'Trackback' varchar (255) default null,
'Trackbacknum' int (11) default null,
'Face' int (11) default null,
'Faceplace' int (11) default null,
'Faceid' int (11) default null,
'Opencomment' int (11) default null,
'Commentnum' int (11) default null,
'Usesign' int (11) default null,
'Sign' text,
'Contentsize' int (11) default null,
'Sortid' bigint (20) default null,
'Sortname' varchar (20) default null,
'Blogsortid' int (11) default null,
'Artkey' varchar (255) default null,
'Postmonth' int (11) default null,
'Postdate' varchar (20) default null,
'Posttime' datetime default null,
'Ishide 'int (11) default null,
Primary Key ('id ')
) Engine = InnoDB default charset = GBK;

#
# Structure for the 'bl _ blog' table:
#

Create Table 'bl _ blog '(
'Id' bigint (20) not null auto_increment,
'Username' varchar (20) not null default '',
'Blogname' varchar (50) not null default '',
'Des. C. R. I. P. tion 'text not null,
'Canonical' int (11) default null,
'Sort 'int (11) default null,
'Skin' int (11) default null,
'Multiuser' int (11) default null,
'Perartnum' int (11) default null,
'Newlyartnum' int (11) default null,
'Newlycomnum' int (11) default null,
'Letterbookmark' int (11) default null,
'Picbookmark' int (11) default null,
'Arttotal' int (11) default null,
'Notetotal' int (11) default null,
'Regtime' datetime default null,
'Pro' int (11) default null,
'Hits 'int (11) default null,
'Calendarstyle' int (11) default null,
'Logurl' varchar (255) default null,
'Logsize' varchar (20) default null,
'Counterstyle' int (11) default null,
Primary Key ('id ')
) Engine = InnoDB default charset = GBK;

#
# Structure for the 'bl _ links 'table:
#

Create Table 'bl _ links '(
'Id' bigint (20) not null auto_increment,
'Blogid' bigint (20) not null default '0 ',
'Linktype' int (11) not null default '0 ',
'Linkurl' varchar (255) not null default '',
'Linktext' varchar (255) default null,
'Linkimgsrc' varchar (255) default null,
Primary Key ('id ')
) Engine = InnoDB default charset = GBK;

#
# Structure for the 'bl _ note' table:
#

Create Table 'bl _ note '(
'Id' bigint (13) not null auto_increment,
'Blogid' bigint (13) not null default '0 ',
'Artid' bigint (13) not null default '0 ',
'Name' varchar (20) not null default '',
'Homepage' varchar (255) default null,
'Email 'varchar (255) default null,
'Face' tinyint (2) default '0 ',
'Content' text,
'IP' varchar (20) default null,
'Createtime' datetime not null default '2017-00-00 00:00:00 ',
Primary Key ('id '),
Unique key 'id' ('id '),
Key 'blogid' ('blogid '),
Key 'artid' ('artid ')
) Engine = InnoDB default charset = GBK;

#
# Structure for the 'bl _ sort 'table:
#

Create Table 'bl _ sort '(
'Id' bigint (20) not null auto_increment,
'Sortname' varchar (20) default null,
'Blogid' bigint (20) default null,
Primary Key ('id ')
) Engine = InnoDB default charset = GBK;

#
# Structure for the 'bl _ userinfo 'table:
#

Create Table 'bl _ userinfo '(
'Id' bigint (20) not null auto_increment,
'Username' varchar (20) not null default '',
'Nickname' varchar (40) not null default '',
'Passwd' varchar (25) not null default '',
'Password' varchar (100) not null default '',
'Question 'varchar (255) not null default '',
'Answer' varchar (255) not null default '',
'Email 'varchar (255) not null default '',
'Sex' int (11) not null default '0 ',
'Age' int (11) default null,
'Pro' int (11) default null,
'City' varchar (10) default null,
'Work' int (11) default null,
'Welcome 'int (11) default null,
'Industry 'int (11) default null,
'Edulevel' int (11) default null,
'Mb' varchar (25) default null,
'Address' varchar (255) default null,
'Face' int (11) default null,
'Sign' text,
'Lastlogintime' bigint (20) default null,
'Lastloginip' varchar (20) default null,
'Logintimes 'int (11) default null,
Primary Key ('id ')
) Engine = InnoDB default charset = GBK;

#
# Data for the 'bl _ article' table (Limit 0,500)
#

Insert into 'bl _ article' ('id', 'blogid', 'blogname', 'title', 'content', 'userid', 'username', 'trackback ', 'trackbacknum', 'face', 'faceplace', 'faceid', 'opencomment', 'commentnum', 'usesign', 'sign', 'contentsize', 'sortid ', 'sortname', 'blogsortid', 'artkey', 'postmonth', 'postdate', 'posttime', 'ishide ') Values
(1,1, 'java ?? ', 'Asdf', 'sdfasdfasdfasdfasdf', 2, 'cellen', '', 0, 0, 1,'', 10, 0, '', 0, 'java', 12, '2017-12-10 ', '2017-12-19 17:39:36', 1 );

Commit;

#
# Data for the 'bl _ blog' table (Limit 0,500)
#

Insert into 'bl _ blog' ('id', 'username', 'blogname', 'des. c. r. i. p. tion ', 'canonicals', 'sort', 'skin', 'multiuser', 'perartnum', 'newlyartnum', 'newlycomnum', 'letterbookmark', 'picbookmark ', 'arttotal', 'notetotal', 'regtime', 'pro', 'hits ', 'calendarstyle', 'logurl', 'logsize', 'counterstyle') Values
(1, 'cellen', 'java ?? ', 'Java ?? ', 2006, 0, 0, '2017-12-19 17:37:52', 0, '', '80 * 31', 0 );

Commit;

#
# Data for the 'bl _ userinfo 'table (Limit 0,500)
#

Insert into 'bl _ userinfo' ('id', 'username', 'nickname', 'passwd', 'passswre', 'Question ', 'answer', 'email ', 'sex', 'age', 'pro', 'city', 'work', 'income ', 'industry', 'edulevel', 'mb', 'address ', 'face', 'sign', 'lastlogintime', 'lastloginip', 'logintimes ') Values
(2, 'cellen', 'cellen', '123', 'clerk', 'whenismybirthday', 'birthday', 'qqqdxj @ 163.com ', 12345, 1, 'peking', 1166521072125, 127, '','', 0, '', '192. 0.0.1 ', 0 );

Commit;

Open Source Community: https://sourceforge.net/project/showfiles.php? Group_id = 205136