📄 typeinfo.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*,java.lang.Double.*"%>
<%@include file="comm.jsp"%>
<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");
action=request.getParameter("action");
if(SysuserType.compareTo("商品管理员")!=0)
{
%>
<jsp:forward page="SysuserLogin.htm"/>
<%
}
if(action.compareTo("type_update")==0)
{
String goodsID=request.getParameter("GoodsTypeID");
}
if(action.compareTo("type_insert")==0)
{
String TypeName=request.getParameter("GoodsTypeName");
strSql="{call dbo.sp_InsertGoodsType(?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setString(1,TypeName);
cstmt.executeUpdate();
}
if(action.compareTo("type_del")==0)
{
String TypeID=request.getParameter("GoodsTypeID");
strSql="{call dbo.sp_DelGoodsType(?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setString(1,TypeID);
cstmt.executeUpdate();
action="type_list";
}
%>
<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=159>更新时间</td>
<td width=50></td>
</tr>
<%
strSql="{call dbo.sp_GetGoodsType(?,?)}";
cstmt=conn.prepareCall(strSql);
cstmt.setInt(1,0);
cstmt.setInt(2,1); //获取所有列表
rs=cstmt.executeQuery();
while(rs.next())
{ %>
<tr bgcolor="#EAFfFff">
<td><a href="TypeDetail.jsp?action=type_view&GoodsTypeID=<%=rs.getString(1)%>"><%=rs.getInt(1)%></a></td>
<td><%=new String(rs.getString(2).getBytes("8859_1"),"gb2312")%></td>
<td><%=rs.getDate(3)%></td>
<td><a href=TypeInfo.jsp?action=type_del&GoodsTypeID=<%=rs.getString(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 + -