Jsp小项目(收银系统代码).doc

发布时间：2022-06-15 发布人：admin 分类：说明书资料大小：0.34M 资料格式：doc 举报版权申诉

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第1页.png

第1页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第2页.png

第2页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第3页.png

第3页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第4页.png

第4页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第5页.png

第5页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第6页.png

第6页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第7页.png

第7页 / 共53页

8e46bcb8-cdab-4d34-ad3d-faae22660d17.doc.pdf-第8页.png

第8页 / 共53页

文本预览

超市收银系统代码数据库代码 create database supermarketSys; use supermarketSys; create table userInfo( gongHao varchar(10) not null, password varchar(20) not null, role varchar(20) not null); insert into userInfo values('001','123','admin'); create table cashierInfo( gongHao varchar(8) not null, name varchar(20) not null, sex varchar(8), birthday varchar(20), guiTaiNum varchar(10) not null, constraint primary key (gongHao)); insert into cashierInfo(gongHao,name,sex,birthday,guiTaiNum) values('001',' 小红','女','1996/11/25','1001'); insert into cashierInfo(gongHao,name,sex,birthday,guiTaiNum) values('002',' 小明','男','1995/04/14','1002'); create table goodsInfo( ID varchar(20) primary key, name varchar(20) not null, price float not null, inprice float not null,

inNum int not null, date varchar(20) not null, outNum int not null, kuCun int not null, tuiHuoNum int not null); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1001','笔记本电脑','5000','2000','30','2016/06/02','0','30','0'); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1002','海尔空调','8000','3500','20','2016/06/02','0','20','0'); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1003','洗衣机','7000','4500','20','2016/06/02','0','20','0'); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1004','电视机','4500','2500','35','2016/06/02','0','35','0'); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1005','冰箱','6600','4500','25','2016/06/02','0','25','0'); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1006','风扇','350','80','100','2016/06/02','0','100','0'); insert into goodsInfo(ID,name,price,inNum,inPrice,date,outNum,kuCun,tuihuoNum) values('1007','吸尘器','500','95','200','2016/06/02','0','200','0'); Jsp 代码放 WebContent 中

addCashier.jsp <%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ page import="bean.UpdateInfo" %> Insert title here <% request.setCharacterEncoding("gb2312"); String text2=request.getParameter("text2"); String text3=request.getParameter("text3"); String text4=request.getParameter("text4"); String text5=request.getParameter("text5"); String text6=request.getParameter("text6"); String sql="insert into cashierInfo values('"+text2+"','"+text3+"','" +text4+"','"+text5+"','"+text6+"');"; UpdateInfo uui=new UpdateInfo(); uui.setSql(sql); uui.updateInfo(); %> <%@ include file="../head.jsp" %>

<%=text2%>的记录以添加

返回

<%@ include file="../end.jsp" %> addGoods.jsp <%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ page import="bean.UpdateInfo" %> Insert title here <% request.setCharacterEncoding("gb2312"); String text2=request.getParameter("text2"); String text3=request.getParameter("text3"); String text4=request.getParameter("text4"); String text5=request.getParameter("text5"); String text6=request.getParameter("text6"); String text7=request.getParameter("text7");

String text8=request.getParameter("text8"); String text9=request.getParameter("text9"); String text0=request.getParameter("text0"); Float f4=Float.parseFloat(text4); Float f6=Float.parseFloat(text6); int i5=Integer.parseInt(text5); int i8=Integer.parseInt(text8); int i9=Integer.parseInt(text9); int i0=Integer.parseInt(text0); String sql="insert into goodsInfo values('"+text2+"','"+text3+"','"+f4+"','"+i5+"','" +f6+"','"+text7+"','"+i8+"','"+i9+"','"+i0+"');"; UpdateInfo uui=new UpdateInfo(); uui.setSql(sql); uui.updateInfo(); %> <%@ include file="../head.jsp" %>

<%=text2%>号商品 <%=text3%>的记录已添加

返回

<%@ include file="../end.jsp" %>

addUser.jsp <%@ page language="java" contentType="text/html; charset=gb2312"%> <%@ page import="bean.UpdateInfo" %> Insert title here <% request.setCharacterEncoding("gb2312"); String text=request.getParameter("text2"); String pw=request.getParameter("pw"); String sql="insert into userInfo values('"+text+"','"+pw+"','admin');"; UpdateInfo uui=new UpdateInfo(); uui.setSql(sql); uui.updateInfo(); %> <%@ include file="../head.jsp" %>

<%=text%>的记录以添加

返回

<%@ include file="../end.jsp" %> Admin.jsp <%@ page language="java" contentType="text/html; charset=gb2312"%> Insert title here <%@ include file="head.jsp" %> <%@ include file="end.jsp" %> delCashier.jsp <%@ page language="java" contentType="text/html;

charset=gb2312"%> <%@ page import="bean.UpdateInfo" %> Insert title here <% request.setCharacterEncoding("gb2312"); String text=request.getParameter("text1"); String sql="delete from cashierInfo where gongHao like '"+text+"';"; UpdateInfo uui=new UpdateInfo(); uui.setSql(sql); uui.updateInfo(); %> <%@ include file="../head.jsp" %>

<%=text%>的记录已删除！

返回

<%@ include file="../end.jsp" %>

分享到：

赞收藏

资料库

Jsp小项目(收银系统代码).doc

相关推荐

后端

热门标签

最新资料