📄 add.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<jsp:useBean id="conn" scope="page" class="myshop.conn"/>
<%!
String id = "";
String as = "";
String ad = "";
String af = "";
String sg = "";
String hg = "";
String hj = "";
int currid = 1;
String sql = "";
ResultSet rsTmp = null;
%>
<link rel="stylesheet" type="text/css" href="news.css">
<%
rsTmp = conn.executeQuery( "select max(id) as maxid from goods" );
if(rsTmp.next()) currid = rsTmp.getInt("maxid") + 1;
rsTmp.close();
request.setCharacterEncoding("GBK");
if(request.getParameter("shopname")!=null) as = request.getParameter("shopname");
if(request.getParameter("shopcontent")!=null) ad = request.getParameter("shopcontent");
if(request.getParameter("price")!=null) af = request.getParameter("price");
if(request.getParameter("factory")!=null) sg = request.getParameter("factory");
if(request.getParameter("times")!=null) hg = request.getParameter("times");
if(request.getParameter("number")!=null) hj = request.getParameter("number");
// 如果title不为空，则添加记录
if(request.getParameter("shopname")!=null) {
// 执行插入操作
sql = "insert into goods values (" + currid ;
sql += ",'" + as + "','" + ad + "',";
sql += "'" + af + "','" + sg + "','"+ hg +"','" + hj + "')";
conn.executeUpdate( sql );
out.println("<hr>");
out.println("<h2>商品添加成功！</h2>");
out.println("<hr>");
}else {
out.println("<hr>");
out.println("<h2>请输入正确的信息后再进行录入！</h2>");
out.println("<hr>");
}
%><body background="image/5.jpg">
<form name=form1 method="post" action="add.jsp">
<P align="center">商品名称：<INPUT size=95 name=shopname value=""></P>
<P align="center">商品简介：<TEXTAREA cols=93 name=shopcontent rows=15></TEXTAREA></P>
<P align="center">价格：<INPUT size=17 name=price value="">
生产厂家：
<INPUT size=25 name=factory value="">
<p align="center">生产日期：<INPUT size=17 name=times value="">
数量: <INPUT size=17 name=number value="">
<p align="center">
<INPUT class=buttonface type=submit value=" 确 定 ">
<INPUT class=buttonface type=reset value=" 清 除 "></p>
</form>
<P align="center"><a href="manage.jsp">编辑商品</a> <a href="index.jsp">查看商品</a>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -