📄 a0ab82bae986001c1fda98d7453fa61c

📁 一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现

💻

字号:

 <%@ page language="java" contentType="text/html; charset=gb2312"    pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>物品信息数据处理</title></head><body><jsp:useBean id="Dbcon" scope="page" class="bb.Dbcon" />
<jsp:useBean id="login" scope="session" class="bb.login" />
<%if(login.loginsuccess==false)
  {
%>
<jsp:forward page="index.jsp"/>
<% 
  }
%>
<%
  ResultSet rs=null;

  String quantity=request.getParameter("quantity");
  String pro_name=request.getParameter("pro_name");
  String type=request.getParameter("type");
  String pro_mer=request.getParameter("pro_mer");
  //java.sql.Date manu_date1=stock.getManu_date();
  //java.sql.Date avail_date1=stock.getAvail_date();
  String year=request.getParameter("year");
  String month=request.getParameter("month");
  String day=request.getParameter("day");
  String year1=request.getParameter("year1");
  String month1=request.getParameter("month1");
  String day1=request.getParameter("day1");
  String sto_price=request.getParameter("sto_price");
  String price=request.getParameter("price");
  String manu_date=year+"-"+month+"-"+day;
  String avail_date=year1+"-"+month1+"-"+day1;

  Connection con=Dbcon.getConn();
  String sql="insert into tpb.product values (seq1.nextval,'"+pro_name+"','"+type+"','"+manu_date+"','"+manu_date+"',"+sto_price+","+price+","+quantity+","+pro_mer+")";
  Statement stmt=con.createStatement();
  rs=stmt.executeQuery(sql);
  rs.close();
  stmt.close();
  Dbcon.Close();
%>
<h1 align="center">添加物品成功</h1>
<a href="stock.jsp">返回</a></body></html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -