e09421c6e386001c1fda98d7453fa61c

来自「一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现」· 代码 · 共 36 行

TXT
36
字号
 <%@ 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" />

<%
  ResultSet rs=null;

  int quantity1=stock.getQuantity();
  String pro_name1=stock.getPro_name();
  String type1=stock.getType();
  int pro_mer1=stock.getPro_mer();
  //java.sql.Date manu_date1=stock.getManu_date();
  //java.sql.Date avail_date1=stock.getAvail_date();
  float sto_price1=stock.getSto_price();
  float price1=stock.getPrice();

  Connection con=Dbcon.getConn();
  String sql="insert into tpb.product values (seq1.nextval,pro_name1,type1,null,null,sto_price1,price1,quantity1,pro_mer1)";
  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 + =
减小字号Ctrl + -
显示快捷键?