?? goodsinfo.jsp
字號:
<%@ page contentType="text/html;charset=gb2312"%>
<%@include file="comm.jsp"%>
<%@page import="java.util.*"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*,java.lang.Double.*"%>
<html>
<body >
<div>
<table>
<tr>
<td width="236" align=center valign=top><br>
<p ><font color="#000080"><a href=SysuserInfo.jsp?action=mine>我的資料</a></font></p>
<p>類別信息
<br> <a href="TypeInfo.jsp?action=type_list">類別列表</a>
<br> <a href="TypeInsert.htm">添加類別</a></p>
<p>商品信息
<br> <a href="GoodsInfo.jsp?action=view&type=1">可用商品</a>
<br> <a href="GoodsInfo.jsp?action=view&type=2">過線商品</a>
<br> <a href="GoodsInsert.htm">添加商品</a></p>
<p>訂單管理
<br> <a href="GoodsTrans.jsp?action=view&type=2">已提交</a>
<br> <a href="GoodsTrans.jsp?action=view&type=3">已發貨</a></p>
</td>
<%
String SysuserID=(String)session.getValue("sysuser");
String SysuserType=(String)session.getValue("sysuserType");
String Type=request.getParameter("type");
int iType=Integer.parseInt(Type);
action=request.getParameter("action");
if(SysuserID==null||SysuserType.compareTo("商品管理員")!=0)
{
%>
<jsp:forward page="SysuserLogin.htm"/>
<%
}
if(action.equals("goods_insert"))
{
String GoodsName=request.getParameter("GoodsName");
String GoodsTypeID=request.getParameter("GoodsTypeID");
String Price=request.getParameter("Price");
String NumNow=request.getParameter("NumNow");
String NumHigh=request.getParameter("NumHigh");
String NumLow=request.getParameter("NumLow");
String GoodsDescr=request.getParameter("GoodsDescr");
strSql="{call dbo.sp_InsertGoods(?,?,?,?,?,?,?,?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setString(1,GoodsName);
cstmt.setInt(2,Integer.parseInt(GoodsTypeID));
cstmt.setDouble(3,Double.parseDouble(Price));
cstmt.setInt(4,Integer.parseInt(NumNow));
cstmt.setInt(5,Integer.parseInt(NumHigh));
cstmt.setInt(6,Integer.parseInt(NumLow));
cstmt.setString(7,GoodsDescr);
cstmt.setString(8,SysuserID);
cstmt.executeUpdate();
String tmp=new String(GoodsName.getBytes("8859_1"),"gb2312");
out.print("<p align=center>添加"+ tmp +"成功</p>");
}
if(action.equals("goods_del"))
{
String GoodsID=request.getParameter("GoodsID");
strSql="{call dbo.sp_DelGoods(?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setString(1,GoodsID);
cstmt.executeUpdate();
}
%>
<td align=center valign=top>
<p align=center>歡迎您:<%=SysuserID%>(<%=SysuserType%>)</p>
<table>商品列表
<tr bgcolor=#E9E9D1>
<td width=70>ID</td>
<td width=159>商品名</td>
<td width=129>商品類型</td>
<td width=80>單價</td>
<td width=80>當前數量</td>
<td width=50></td>
</tr>
<%
strSql="{call dbo.sp_GetAllGoods(?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setInt(1,iType); //獲取所有商品信息
rs=cstmt.executeQuery();
while(rs.next())
{ %>
<tr bgcolor="#EAFfFff">
<td><a href=GoodsDetail.jsp?action=goods_view&GoodsID=<%=rs.getString(1)%>>
<%=rs.getInt(1)%></td>
<td><%=new String(rs.getString(2).getBytes("8859_1"),"gb2312")%></td>
<td><%=new String(rs.getString(3).getBytes("8859_1"),"gb2312")%></td>
<td><%=rs.getDouble(4)%></td>
<td><%=rs.getInt(5)%></td>
<td><a href=GoodsInfo.jsp?action=goods_del&GoodsID=<%=rs.getString(1)%>&type=1>刪除</a></td>
</tr>
<%}%>
</table>
</td>
<%
rs.close();
cstmt.close();
conn.close();
%>
</tr>
</table>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -