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

server/2024/10/19 2:17:26/

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

java 进销存管理系统


二、功能介绍

(1)用户管理：对用户信息进行添加、删除、修改和查看
(2)材料管理：对材料信息进行添加、删除、修改和查看
(3)采购申请管理：对采购申请信息进行添加、删除、修改和查看
(4)入库申请管理：对入库申请信息进行添加、删除、修改和查看
(5)材料入库管理：对材料入库信息进行添加、删除、修改和查看
(6)材料领用申请管理：对材料领用申请信息进行添加、删除、修改和查看
(7)材料出库管理：对材料出库信息进行添加、删除、修改和查看
(8)采购退货管理：对采购退货信息进行添加、删除、修改和查看
(9)产品管理：对产品信息进行添加、删除、修改和查看
(10)销售订单管理：对销售订单信息进行添加、删除、修改和查看
(11)销售退货管理：对销售退货信息进行添加、删除、修改和查看

数据库设计

BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[qx] [VARCHAR](40),
[lxdh] [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'lxdh'
BEGIN
CREATE TABLE [dbo].[cailiao]([clid] [int] IDENTITY(1,1) NOT NULL,
[clmc] [VARCHAR](40),
[js] [VARCHAR](40),
[cd] [VARCHAR](40),
[yt] [VARCHAR](40),
[sl] [VARCHAR](40),
[jg] [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'cailiao', @level2type=N'COLUMN', @level2name=N'clmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cailiao', @level2type=N'COLUMN', @level2name=N'js'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产地' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cailiao', @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'cailiao', @level2type=N'COLUMN', @level2name=N'yt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cailiao', @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'cailiao', @level2type=N'COLUMN', @level2name=N'jg'
BEGIN
CREATE TABLE [dbo].[cgsq]([cgsqid] [int] IDENTITY(1,1) NOT NULL,
[cgls] [VARCHAR](40),
[bt] [VARCHAR](40),
[nr] [VARCHAR](40),
[gys] [VARCHAR](40),
[cl] [VARCHAR](40),
[sl] [VARCHAR](40),
[yh] [VARCHAR](40),
[sqsj] [VARCHAR](40),
[zt] [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'cgsq', @level2type=N'COLUMN', @level2name=N'cgls'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgsq', @level2type=N'COLUMN', @level2name=N'bt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgsq', @level2type=N'COLUMN', @level2name=N'nr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'供应商' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgsq', @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'cgsq', @level2type=N'COLUMN', @level2name=N'cl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgsq', @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'cgsq', @level2type=N'COLUMN', @level2name=N'yh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgsq', @level2type=N'COLUMN', @level2name=N'sqsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgsq', @level2type=N'COLUMN', @level2name=N'zt'
BEGIN
CREATE TABLE [dbo].[rksq]([rksqid] [int] IDENTITY(1,1) NOT NULL,
[sqbt] [VARCHAR](40),
[sqnr] [VARCHAR](40),
[cl] [VARCHAR](40),
[sl] [VARCHAR](40),
[sqr] [VARCHAR](40),
[sqsj] [VARCHAR](40),
[zt] [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'rksq', @level2type=N'COLUMN', @level2name=N'sqbt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'rksq', @level2type=N'COLUMN', @level2name=N'sqnr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'材料' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'rksq', @level2type=N'COLUMN', @level2name=N'cl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'rksq', @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'rksq', @level2type=N'COLUMN', @level2name=N'sqr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'rksq', @level2type=N'COLUMN', @level2name=N'sqsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'rksq', @level2type=N'COLUMN', @level2name=N'zt'
BEGIN
CREATE TABLE [dbo].[clrk]([clrkid] [int] IDENTITY(1,1) NOT NULL,
[rkls] [VARCHAR](40),
[cl] [VARCHAR](40),
[rksl] [VARCHAR](40),
[czr] [VARCHAR](40),
[czsj] [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'clrk', @level2type=N'COLUMN', @level2name=N'rkls'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'材料' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clrk', @level2type=N'COLUMN', @level2name=N'cl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clrk', @level2type=N'COLUMN', @level2name=N'rksl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clrk', @level2type=N'COLUMN', @level2name=N'czr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clrk', @level2type=N'COLUMN', @level2name=N'czsj'
BEGIN
CREATE TABLE [dbo].[cllysq]([cllysqid] [int] IDENTITY(1,1) NOT NULL,
[bt] [VARCHAR](40),
[cl] [VARCHAR](40),
[sqnr] [VARCHAR](40),
[sqsj] [VARCHAR](40),
[sqr] [VARCHAR](40),
[zt] [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'cllysq', @level2type=N'COLUMN', @level2name=N'bt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'材料' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cllysq', @level2type=N'COLUMN', @level2name=N'cl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cllysq', @level2type=N'COLUMN', @level2name=N'sqnr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cllysq', @level2type=N'COLUMN', @level2name=N'sqsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cllysq', @level2type=N'COLUMN', @level2name=N'sqr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cllysq', @level2type=N'COLUMN', @level2name=N'zt'
BEGIN
CREATE TABLE [dbo].[clck]([clckid] [int] IDENTITY(1,1) NOT NULL,
[ckls] [VARCHAR](40),
[cksj] [VARCHAR](40),
[cl] [VARCHAR](40),
[cksl] [VARCHAR](40),
[ckr] [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'clck', @level2type=N'COLUMN', @level2name=N'ckls'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clck', @level2type=N'COLUMN', @level2name=N'cksj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'材料' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clck', @level2type=N'COLUMN', @level2name=N'cl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clck', @level2type=N'COLUMN', @level2name=N'cksl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'clck', @level2type=N'COLUMN', @level2name=N'ckr'
BEGIN
CREATE TABLE [dbo].[cgth]([cgthid] [int] IDENTITY(1,1) NOT NULL,
[sq] [VARCHAR](40),
[cl] [VARCHAR](40),
[thsl] [VARCHAR](40),
[thyy] [VARCHAR](40),
[sm] [VARCHAR](40),
[thsj] [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'cgth', @level2type=N'COLUMN', @level2name=N'sq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'材料' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgth', @level2type=N'COLUMN', @level2name=N'cl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退货数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgth', @level2type=N'COLUMN', @level2name=N'thsl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退货原因' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgth', @level2type=N'COLUMN', @level2name=N'thyy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgth', @level2type=N'COLUMN', @level2name=N'sm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退货时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'cgth', @level2type=N'COLUMN', @level2name=N'thsj'
BEGIN
CREATE TABLE [dbo].[chanpin]([cpid] [int] IDENTITY(1,1) NOT NULL,
[cpmc] [VARCHAR](40),
[js] [VARCHAR](40),
[gg] [VARCHAR](40),
[yt] [VARCHAR](40),
[sl] [VARCHAR](40),
[jg] [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'chanpin', @level2type=N'COLUMN', @level2name=N'cpmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chanpin', @level2type=N'COLUMN', @level2name=N'js'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'规格' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chanpin', @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'chanpin', @level2type=N'COLUMN', @level2name=N'yt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'chanpin', @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'chanpin', @level2type=N'COLUMN', @level2name=N'jg'
BEGIN
CREATE TABLE [dbo].[xsdd]([xsddid] [int] IDENTITY(1,1) NOT NULL,
[ddls] [VARCHAR](40),
[cp] [VARCHAR](40),
[sl] [VARCHAR](40),
[xssj] [VARCHAR](40),
[sm] [VARCHAR](40),
[kh] [VARCHAR](40),
[lxdh] [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'xsdd', @level2type=N'COLUMN', @level2name=N'ddls'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsdd', @level2type=N'COLUMN', @level2name=N'cp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsdd', @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'xsdd', @level2type=N'COLUMN', @level2name=N'xssj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsdd', @level2type=N'COLUMN', @level2name=N'sm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsdd', @level2type=N'COLUMN', @level2name=N'kh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsdd', @level2type=N'COLUMN', @level2name=N'lxdh'
BEGIN
CREATE TABLE [dbo].[xsth]([xsthid] [int] IDENTITY(1,1) NOT NULL,
[dd] [VARCHAR](40),
[cp] [VARCHAR](40),
[thsl] [VARCHAR](40),
[thsj] [VARCHAR](40),
[sm] [VARCHAR](40),
[djr] [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'xsth', @level2type=N'COLUMN', @level2name=N'dd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsth', @level2type=N'COLUMN', @level2name=N'cp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退货数量' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsth', @level2type=N'COLUMN', @level2name=N'thsl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退货时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsth', @level2type=N'COLUMN', @level2name=N'thsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsth', @level2type=N'COLUMN', @level2name=N'sm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登记人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xsth', @level2type=N'COLUMN', @level2name=N'djr'

代码设计

esultSet rs=null;//声明结果集String keyid =(String)request.getParameter("keyid");
String cpmc=(String)request.getParameter("cpmc");//变量:产品名称
String js=(String)request.getParameter("js");//变量:介绍
String gg=(String)request.getParameter("gg");//变量:规格
String yt=(String)request.getParameter("yt");//变量:用途
String sl=(String)request.getParameter("sl");//变量:数量
String jg=(String)request.getParameter("jg");//变量:价格String sql="";//声明sqlsql="insert into chanpin(cpmc,js,gg,yt,sl,jg) values('"+cpmc+"','"+js+"','"+gg+"','"+yt+"','"+sl+"','"+jg+"')";
;//产品SQL 语句
int row=1;///定义执行结果try{//int row =0;row=db.update(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){

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

四 系统实现

代码下载

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

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


http://www.ppmy.cn/server/28166.html

相关文章

在 PHP中使用 Redis 缓存的方法有哪些

在 PHP中使用 Redis 缓存的方法有哪些

在 PHP 中使用 Redis 作为缓存的方法非常多样化，因为 Redis 提供了丰富的数据结构和命令集。以下是一些常见的 PHP 中使用 Redis 缓存的方法： 字符串缓存 Redis 最基本的数据结构是字符串（string），你可以用它来缓存简…
阅读更多...
第十一章 Spring Boot 整合 WebSocket

第十一章 Spring Boot 整合 WebSocket

第十一章 Spring Boot 整合 WebSocket 1. 为什么需要 WebSocket2. WebSocket 简介3. Spring Boot 整合 WebSocket3.1 实现消息群发1. 依赖2. 配置 WebSocket ************************************************************ 1. 为什么需要 WebSocket 2. WebSocket 简介 3. Spri…
阅读更多...
基于FPGA的数字信号处理（5）--Signed的本质和作用

基于FPGA的数字信号处理（5）--Signed的本质和作用

前言 Verilog中的signed是一个很多人用不好，或者说不太愿意用的一个语法。因为不熟悉它的机制，所以经常会导致运算结果莫名奇妙地出错。其实了解了signed以后，很多时候用起来还是挺方便的。 signed的使用方法主要有两种，其中一种…
阅读更多...
Systemback Ubuntu14.04 制作自定义系统ISO镜像

Systemback Ubuntu14.04 制作自定义系统ISO镜像

工作需要，要基于ubuntu自定义一些编译环境并将自己配置好的ubuntu做成镜像。 硬件准备 ​ 为保证能够顺利完成系统iso镜像的制作与系统还原，推荐准备一个较大容量的U盘或者移动固态硬盘，同时确保自己的Ubuntu系统还有比较大的可用空间。 1 S…
阅读更多...
PCL 点云中的平面点云提取

PCL 点云中的平面点云提取

平面点云提取 一. 索引提取1.1 算法概念1.2 算法流程1.3 主要函数二.代码示例三.结果示例一. 索引提取 1.1 算法概念 平面点云提取：是指从点云数据中提取出属于平面的点的过程。 1.2 算法流程 使用pcl::SACSegmentation类进行点云分割的基本步骤如下： 创建一个pcl::SACSegm…
阅读更多...
selenium之document.querySelector()方法

selenium之document.querySelector()方法

document.querySelector()方法 1. 常用的三种获取元素的js方式 document.getElementById("");document.getElementsByClassName();document.getElementsByTagName(); var docdocument;var boxdoc.getElementById("box");var libox.getElementsByTagName(…
阅读更多...
Web3应用:DeFi是什么？有什么用？

Web3应用:DeFi是什么？有什么用？

Web3，也被称为第三代互联网，是基于区块链技术的去中心化网络。它旨在创建一个不依赖于中心化服务提供商的互联网，赋予用户更大的数据所有权和控制权。而DeFi，即去中心化金融（Decentralized Finance）&#x…
阅读更多...
【webrtc】MessageHandler 7： 基于线程的消息处理：切换main线程向observer发出通知

【webrtc】MessageHandler 7： 基于线程的消息处理：切换main线程向observer发出通知

以当前线程作为main线程 RemoteAudioSource 作为一个handler 仅实现一个退出清理的功能 首先on message的处理会切换到main 线程 ：main_thread_其次，这里在main 线程对sink_ 做清理再次，在main 线程做出状态改变，并能通知给所有的observer 做出on changed 行为。对接mediac…
阅读更多...
最新文章

Copyright @ 2022~2023