`
yourgame
  • 浏览: 356849 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
社区版块
存档分类
最新评论

ExtJS 2.2,图书管理系统 共享全部源码下载

配置管理项目管理MySQLGoEXT 
阅读更多
系统架构:struts2(json-plugin) + spring2 + ibatis2 + extjs2.2 + sqlserver2000
最后附件中有Mysql版本下载
希望能和大家一起讨论学习。
自我感觉代码布局不够严谨，还有待进一步提高和练习。
文章原址：http://yourgame.iteye.com/blog/252853

注意：工程采用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.如果还有问题，
w_e_ibo:
http://t.cn/zjqEaRh  
http://weibo.com/liao27
系统截图











有同学要数据库脚本，特此奉上！ 
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
  • bmsh.rar (10 MB)
  • 描述: 项目源代码、数据库
  • 下载次数: 21030
分享到：
| Sturts2提交表单后,执行2次Action的离奇 ...
评论
84 楼 hc1031473635 2016-05-16  
非常感谢楼主哈，调试了一些bug，正常运行了，初入java 学习学习
83 楼 kfcman 2014-11-11  
.大牛。多谢分享。
82 楼 永战天 2014-05-06  
非常感谢，学习一下
81 楼 plmk521 2013-06-04  
mysql版本少包，少页面哦。运行不了。能不能传我一个，学习下。282962927 谢谢。
80 楼 jayghost 2013-05-08  
horusa 写道
楼主，您好
我下载了mysql版本的源码，在myeclipse里编译时com.lhq.prj.bms.action类JpcapTest.java
import jpcap.packet.*;  需要增加什么jar包吗？

这个类是测试类，没用的，可以删了
79 楼 rancedxk 2013-03-08  
最近正在学习EXTJS中，正苦于没人指引，见到楼主帖子甚是喜欢！
78 楼 zhangfan1098730630 2012-12-20  
楼主 很给力 谢谢了 正在学习 ExtJs!
77 楼 QQ1067184821 2012-12-06  
请问一下，mysql版的怎添加数据都说数据已存在呢？
76 楼 chenxiangde 2012-11-28  
不错的系统
75 楼 gzxxx 2012-11-08  
谢谢作者的共享精神。
74 楼 tcw290 2012-11-01  
搂住，发布完查询不了，插入可以，没找到原因QQ=421373847
73 楼 tod17031 2012-09-15  
找的就是这，非常感谢 
72 楼 Eli_Chou 2012-09-13  
先谢谢了。先下下来，看看。多多了解别人的项目。
71 楼 li51850000 2012-09-03  
谢谢分享，学习中
70 楼 121488158 2012-08-29  
感谢楼主的开源精神啊，好东西收下啦
69 楼 zhangyouming1220 2012-08-22  
.................
68 楼 user_free 2012-08-12  
不知道有没有我想要参考的功能，等下再看，先谢啦。
67 楼 anpeng22 2012-07-18  
恩  正准备 练手  谢谢了
66 楼 yeahwell 2012-06-08  
正在做学生管理系统，也要用到Extjs，借鉴啦
65 楼 jianxia801 2012-06-07  
哥们就是牛逼 为你的开源精神赞一个！
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics