📄 mgrcategory.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="my.shop.db.*" %>
<%@ include file="sessionfilter.jsp" %>
<%
List msg = new ArrayList() ;
String action = request.getParameter("action") ;
if("add".equals(action)){
String categoryname = request.getParameter("categoryname") ;
//中文乱码处理
categoryname = new String(categoryname.getBytes("ISO8859_1"),"GBK") ;
if("".equals(categoryname) || null == categoryname){
msg.add("类别名称不能为空，请认真填写") ;
}else{
Connection conn = DBConnection.getInstance().getConnection() ;
String sql = "insert into category(name) values(?)" ;
PreparedStatement pstmt = conn.prepareStatement(sql) ;
pstmt.setString(1,categoryname) ;
pstmt.executeUpdate() ;
pstmt.close() ;
conn.close() ;
out.println("<div align='center'><font color=blue>新类别添加成功！</font></div><br><a href='mgrcategory.jsp'>返回</a>") ;
return ;
}
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>后台类别管理</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 24px;
font-weight: bold;
}
-->
</style>
</head>
<body>
<jsp:include page="top.html"></jsp:include>
<form action="mgrcategory.jsp" method="post">
<input type="hidden" name="action" value="add">
<table width="302" height="81" border="0" align="center">
<tr>
<td height="26" colspan="5" bgcolor="#3366CC"><div align="center"><span class="STYLE1">添加类别</span></div></td>
</tr>
<tr>
<td height="24" bgcolor="#899BE4">产品类别名称：</td>
<td colspan="2" bgcolor="#899BE4"><input type="text" name="categoryname"/></td>
</tr>
<tr>
<td height="23" bgcolor="#899BE4">
<div align="right">
<input type="button" value="管理首页" onClick="javascript:location.href='admin.jsp'">
</div></td>
<td bgcolor="#899BE4"><input type="submit" value="添加类别" /></td>
</tr>
</table>
</form>
<%
if(null != msg && msg.size() > 0){
for(Iterator it = msg.iterator();it.hasNext();){
String m = (String)it.next() ;
%>
<div align="center"><font color=red ><%= m %></font></div><br>
<%
}
}
%>
<hr>
<div align="center"><h3>所有类别</h3></div>
<table width="449" height="41" border="0" align="center">
<tr>
<td colspan="2" bgcolor="#3366CC">ID</td>
<td width="209" height="15" bgcolor="#3366CC">产品类别名称</td>
<td width="70" bgcolor="#3366CC">添加产品</td>
<td width="43" colspan="2" bgcolor="#3366CC">删除</td>
</tr>
<%
//从数据库中取出类别信息
String sql = "select * from category" ;
Connection conn = DBConnection.getInstance().getConnection() ;
PreparedStatement pstmt = conn.prepareStatement(sql) ;
ResultSet rs = pstmt.executeQuery() ;
while(rs.next()){
String id = rs.getString(1) ;
%>
<tr>
<td colspan="2" bgcolor="#899BE4"><%=id %></td>
<td height="20" bgcolor="#899BE4"><%=rs.getString(2) %></td>
<td height="20" bgcolor="#899BE4"><a href="addProduct.jsp?cateid=<%=id %>">添加产品</a></td>
<td colspan="2" bgcolor="#899BE4"><a href="delcategory.jsp?id=<%=id %>">删除</a></td>
</tr>
<%} %>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -