1701java药品进销存管理系统Myeclipse开发sqlserver数据库web结构java编程计算机网页项目

一、源码特点
     java web药品进销存管理系统是一套完善的java web信息管理系统，对理解JSP java编程开发语言有帮助，系统具有完整的源代码和数据库，系统主要采用B/S模式开发。开发环境
为 TOMCAT7.0,Myeclipse8.5开发，数据库为sqlserver2008，使用java语言开发。

二、功能介绍

(1)权限管理：对权限信息进行添加、删除、修改和查看
(2)用户管理：对用户信息进行添加、删除、修改和查看
(3)仓库管理：对仓库信息进行添加、删除、修改和查看
(4)商品管理：对商品信息进行添加、删除、修改和查看
(5)入库管理：对入库信息进行添加、删除、修改和查看
(6)出库管理：对出库信息进行添加、删除、修改和查看
(7)调库管理：对调库信息进行添加、删除、修改和查看
(8)库存管理：对库存信息进行添加、删除、修改和查看
(9)供应商管理：对供应商信息进行添加、删除、修改和查看
(10)销售管理：对销售信息进行添加、删除、修改和查看
(11)个人信息修改

数据库设计

BEGIN
CREATE TABLE [dbo].[quanxian]([qxid] [int] IDENTITY(1,1) NOT NULL,
[qx] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'quanxian', @level2type=N'COLUMN', @level2name=N'qx'
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[qx] [VARCHAR](40),
[dh] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'qx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'dh'
BEGIN
CREATE TABLE [dbo].[cangku]([ckid] [int] IDENTITY(1,1) NOT NULL,
[ck] [VARCHAR](40),
[fzr] [VARCHAR](40),
[wz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cangku', @level2type=N'COLUMN', @level2name=N'ck'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cangku', @level2type=N'COLUMN', @level2name=N'fzr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'位置' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cangku', @level2type=N'COLUMN', @level2name=N'wz'
BEGIN
CREATE TABLE [dbo].[shangpin]([spid] [int] IDENTITY(1,1) NOT NULL,
[sp] [VARCHAR](40),
[gys] [VARCHAR](40),
[sl] [VARCHAR](40),
[jhrq] [VARCHAR](40),
[cd] [VARCHAR](40),
[gg] [VARCHAR](40),
[je] [VARCHAR](40),
[sx] [VARCHAR](40),
[xx] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'sp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'供应商' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'gys'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'sl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'进货日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'jhrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产地' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'cd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'规格' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'gg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金额' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'je'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'sx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shangpin', @level2type=N'COLUMN', @level2name=N'xx'
BEGIN
CREATE TABLE [dbo].[ruku]([rkid] [int] IDENTITY(1,1) NOT NULL,
[ck] [VARCHAR](40),
[sp] [VARCHAR](40),
[sl] [VARCHAR](40),
[sj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ruku', @level2type=N'COLUMN', @level2name=N'ck'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'商品' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ruku', @level2type=N'COLUMN', @level2name=N'sp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ruku', @level2type=N'COLUMN', @level2name=N'sl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ruku', @level2type=N'COLUMN', @level2name=N'sj'

代码设计

	String keyid =(String)request.getParameter("keyid");
String ck=(String)request.getParameter("ck");// 变量 名 :仓库
String sp=(String)request.getParameter("sp");// 变量 名 :商品
String sl=(String)request.getParameter("sl");// 变量 名 :数量
String sj=(String)request.getParameter("sj");// 变量 名 :时间
String drck=(String)request.getParameter("drck");
String sql="";//声明sql
 
int row=1;///定义执行结果
		int num=0;
try{
 
sql="select count(1) as num from kucun where ck='"+drck+"' and sp='"+sp+"'";
System.out.println(sql);
	rs=db.query(sql);
	if(rs.next()){
	
	num=rs.getInt("num");
	}
	
	if(num>0){
	
	sql="update kucun set sl=sl+"+sl+" where ck='"+drck+"' and sp='"+sp+"'";
	
		db.update(sql);
	}else{
	
 sql="insert into kucun(sp,ck,sl,czr,sj) values('"+sp+"','"+drck+"','"+sl+"','"+session.getAttribute("yhm")+"','"+StaticMethod.getStringDate()+"')";
;//库存SQL 语句	
System.out.println(sql);
	db.update(sql);
	
	}
 
	sql="update kucun set sl=sl-"+sl+" where ck='"+ck+"' and sp='"+sp+"'";
	
	db.update(sql);
 
	
	
	
	 sql="insert into diaoku(ck,sp,sl,sj,drck) values('"+ck+"','"+sp+"','"+sl+"','"+sj+"','"+drck+"')";
;//调库SQL 语句
		//int row =0;
		row=db.update(sql);//执行sql语句
}catch(Exception e){
System.out.println(e.toString());}

三、注意事项
    1、管理员账号：admin密码：admin 数据库配置文件DBO.java
     2、开发环境为TOMCAT7.0,Myeclipse8.5开发，数据库为sqlserver2008，使用java语言开发。
    3、数据库文件名是jspyaopin.mdf，系统名称yaopin
    4、系统首页地址：http://127.0.0.1:8080/yaopin/login.jsp

四 系统实现

下载地址：

https://download.csdn.net/download/qq_41221322/89317482

需要源码 其他的定制服务  下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ 或者私信作者