系统架构:struts2(json-plugin) + spring2 + ibatis2 + extjs2.2 + sqlserver2000
[size=large][color=red]最后附件中有Mysql版本下载[/color][/size]
希望能和大家一起讨论学习。
自我感觉代码布局不够严谨,还有待进一步提高和练习。
文章原址:http://yourgame.iteye.com/blog/252853
[color=red]注意:工程采用MyEclipse5.1+tomcat5.5 。
1.您的MSSQL2000没有打sp4补丁,会提示拒绝链接(refuse connction)
2.tomcat版本没有关系,5和6都可以,但是最好选择解压缩版本
3.如果您不是采用MyEclipse5.1开发,可能无法部署项目,或者提示什么一个文件上锁什么的,请不要使用导入项目,您可以自己建立一个web工程,名字叫做bmsh(一定要bmsh,因为我页面中的图片和js引用的时候写了绝对路径),然后把源码,和页面、js、jar包等拷贝到相对地方重新发布就可以了。
4.记住要修改ApplicationContext-common.xml中的数据库用户名和密码:)
5.如果还有问题,[/color]
w_e_ibo:
[url]http://t.cn/zjqEaRh[/url]
[url]http://weibo.com/liao27[/url]
系统截图
[img]http://yourgame.iteye.com/upload/picture/pic/24911/c20c8bf2-3306-3e6a-bc8a-f799892fea5d.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24909/32cca3c9-dccf-379c-a853-a228c107bf38.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24907/b275addf-f213-3873-a321-0861340cb735.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/23347/7ca90e15-60a0-3dca-8b17-441ac9460431.png[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24905/cffe0feb-c173-3273-ab30-86700492d4f1.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24903/8e708217-f432-3c95-9a77-f4dd51de823d.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24917/45f18835-0c02-3f2a-9aaa-e5709b1b9d7f.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24915/e5b39eff-a713-3617-83e2-1e5d8603a36b.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24913/0d742ba9-cca8-39d6-a06f-0d4a4c9c8784.jpg[/img]
有同学要数据库脚本,特此奉上!
[size=large][color=red]最后附件中有Mysql版本下载[/color][/size]
希望能和大家一起讨论学习。
自我感觉代码布局不够严谨,还有待进一步提高和练习。
文章原址:http://yourgame.iteye.com/blog/252853
[color=red]注意:工程采用MyEclipse5.1+tomcat5.5 。
1.您的MSSQL2000没有打sp4补丁,会提示拒绝链接(refuse connction)
2.tomcat版本没有关系,5和6都可以,但是最好选择解压缩版本
3.如果您不是采用MyEclipse5.1开发,可能无法部署项目,或者提示什么一个文件上锁什么的,请不要使用导入项目,您可以自己建立一个web工程,名字叫做bmsh(一定要bmsh,因为我页面中的图片和js引用的时候写了绝对路径),然后把源码,和页面、js、jar包等拷贝到相对地方重新发布就可以了。
4.记住要修改ApplicationContext-common.xml中的数据库用户名和密码:)
5.如果还有问题,[/color]
w_e_ibo:
[url]http://t.cn/zjqEaRh[/url]
[url]http://weibo.com/liao27[/url]
系统截图
[img]http://yourgame.iteye.com/upload/picture/pic/24911/c20c8bf2-3306-3e6a-bc8a-f799892fea5d.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24909/32cca3c9-dccf-379c-a853-a228c107bf38.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24907/b275addf-f213-3873-a321-0861340cb735.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/23347/7ca90e15-60a0-3dca-8b17-441ac9460431.png[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24905/cffe0feb-c173-3273-ab30-86700492d4f1.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24903/8e708217-f432-3c95-9a77-f4dd51de823d.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24917/45f18835-0c02-3f2a-9aaa-e5709b1b9d7f.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24915/e5b39eff-a713-3617-83e2-1e5d8603a36b.jpg[/img]
[img]http://yourgame.iteye.com/upload/picture/pic/24913/0d742ba9-cca8-39d6-a06f-0d4a4c9c8784.jpg[/img]
有同学要数据库脚本,特此奉上!
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_book]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_book]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_category]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_company]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_company]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_dept]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_duty]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_duty]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_loanlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_loanlog]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_subject]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_subject]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_user]
GO
CREATE TABLE [dbo].[t_book] (
[bookId] [int] IDENTITY (1, 1) NOT NULL ,
[bookName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[author] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[press] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[publicationDate] [datetime] NULL ,
[price] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[editionNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isbn] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[categoryId] [int] NULL ,
[categoryName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[wordCount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[pageCount] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[bookSize] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[paper] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[pack] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[imageUrl] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[editorRecommend] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[description] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[authorDesc] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[state] [int] NOT NULL ,
[currentReaderId] [int] NULL ,
[currentReader] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[logId] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_category] (
[categoryId] [int] IDENTITY (1, 1) NOT NULL ,
[categoryName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[subjectId] [int] NULL ,
[subjectName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_company] (
[companyId] [int] IDENTITY (1, 1) NOT NULL ,
[companyName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[address] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[tellPhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[leader] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[mobilePhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[remark] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_dept] (
[deptId] [int] IDENTITY (1, 1) NOT NULL ,
[deptName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[companyId] [int] NULL ,
[companyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[address] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[tellPhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[leader] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mobilePhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[remark] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_duty] (
[dutyId] [int] IDENTITY (1, 1) NOT NULL ,
[dutyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_loanlog] (
[logId] [int] IDENTITY (1, 1) NOT NULL ,
[bookId] [int] NOT NULL ,
[bookName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[loanTime] [datetime] NULL ,
[loanDays] [int] NULL ,
[preReturnTime] [datetime] NULL ,
[returnTime] [datetime] NULL ,
[readerId] [int] NOT NULL ,
[reader] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[loannerId] [int] NOT NULL ,
[loanner] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_subject] (
[subjectId] [int] IDENTITY (1, 1) NOT NULL ,
[subjectName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[t_user] (
[userId] [int] IDENTITY (1, 1) NOT NULL ,
[emplName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[emplNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mobilePhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[age] [int] NULL ,
[userName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[companyId] [int] NULL ,
[companyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[deptId] [int] NULL ,
[deptName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[dutyId] [int] NULL ,
[dutyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[manager] [bit] NULL ,
[remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_book] ADD
CONSTRAINT [PK_t_book] PRIMARY KEY CLUSTERED
(
[bookId]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_category] ADD
CONSTRAINT [PK_t_category] PRIMARY KEY CLUSTERED
(
[categoryId]
) ON [PRIMARY] ,
CONSTRAINT [IX_t_category] UNIQUE NONCLUSTERED
(
[categoryName],
[subjectId]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_company] ADD
CONSTRAINT [PK_t_company] PRIMARY KEY CLUSTERED
(
[companyId]
) ON [PRIMARY] ,
CONSTRAINT [IX_t_company] UNIQUE NONCLUSTERED
(
[companyName]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_dept] ADD
CONSTRAINT [PK_t_dept] PRIMARY KEY CLUSTERED
(
[deptId]
) ON [PRIMARY] ,
CONSTRAINT [IX_t_dept] UNIQUE NONCLUSTERED
(
[deptName],
[companyId]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_duty] ADD
CONSTRAINT [PK_t_duty] PRIMARY KEY CLUSTERED
(
[dutyId]
) ON [PRIMARY] ,
CONSTRAINT [IX_t_duty] UNIQUE NONCLUSTERED
(
[dutyName]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_loanlog] ADD
CONSTRAINT [PK_t_loanlog] PRIMARY KEY CLUSTERED
(
[logId]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_subject] ADD
CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED
(
[subjectId]
) ON [PRIMARY] ,
CONSTRAINT [IX_Table1] UNIQUE NONCLUSTERED
(
[subjectName]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_user] ADD
CONSTRAINT [PK_t_user] PRIMARY KEY CLUSTERED
(
[userId]
) ON [PRIMARY] ,
CONSTRAINT [IX_t_user] UNIQUE NONCLUSTERED
(
[userName]
) ON [PRIMARY]
GO