📄 add_class_2.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="DBConn" class="jspeshop.DBConn" scope="page"/>
<%
String sql=null;
int count=0;
if(session.getAttribute("name")==null){
response.sendRedirect("index.jsp");
}else{
try{
Connection con =DBConn.GetConn();
Statement st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="select * from Class2";
ResultSet rs2=st.executeQuery(sql);
%><head>
<style type="text/css">
<!--
.style1 {
color: #00FFFF;
font-weight: bold;
}
-->
</style>
</head>
<SCRIPT language=javascript id=clientEventHandlersJS>
//函数名：chksafe
//功能介绍：检查是否含有"'",'\\',"/"
//参数说明：要检查的字符串
//返回值：0：是 1：不是
function chksafe(a)
{
fibdn = new Array ("'" ,"\\", "、", ",", ";", "/");
i=fibdn.length;
j=a.length;
for (ii=0;ii<i;ii++)
{ for (jj=0;jj<j;jj++)
{ temp1=a.charAt(jj);
temp2=fibdn[ii];
if (temp1==temp2)
{ return 0; }
}
}
return 1;
}
//函数名：chkspc
//功能介绍：检查是否含有空格
//参数说明：要检查的字符串
//返回值：0：是 1：不是
function chkspc(a)
{
var i=a.length;
var j = 0;
var k = 0;
while (k<i)
{
if (a.charAt(k) != " ")
j = j+1;
k = k+1;
}
if (j==0)
{
return 0;
}
if (i!=j)
{ return 0; }
else
{
return 1;
}
}
//函数名：fucCheckLength
//功能介绍：检查字符串的长度
//参数说明：要检查的字符串
//返回值：长度值
function fucCheckLength(strTemp)
{
var i,sum;
sum=0;
for(i=0;i<strTemp.length;i++)
{
if ((strTemp.charCodeAt(i)>=0) && (strTemp.charCodeAt(i)<=255))
sum=sum+1;
else
sum=sum+2;
}
return sum;
}
function chkitem(str)
{
var strSource ="0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_";
var ch;
var i;
var temp;
for (i=0;i<=(str.length-1);i++)
{
ch = str.charAt(i);
temp = strSource.indexOf(ch);
if (temp==-1)
{
return 0;
}
}
if (strSource.indexOf(ch)==-1)
{
return 0;
}
else
{
return 1;
}
}
</SCRIPT>
<SCRIPT language=javascript>
//正常字符
function B1_onsubmit(){
if((document.myform.reTitle.value=='')||chkspc(document.myform.reTitle.value)==0)
{
alert("不能包含空格。");
document.myform.reTitle.focus();
return false;
}
if (chksafe(document.myform.reTitle.value)==0){
alert("不能含有特殊的字符。");
document.myform.reTitle.focus();
return false;
}
document.myform.options.value='rename'
}
function B3_onsubmit(){
if((document.myform.newTitle.value=='')||chkspc(document.myform.newTitle.value)==0)
{
alert("不能包含空格。");
document.myform.newTitle.focus();
return false;
}
if (chksafe(document.myform.newTitle.value)==0){
alert("不能含有特殊的字符。");
document.myform.newTitle.focus();
return false;
}
document.myform.options.value='new'
}
</SCRIPT>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
while(rs2.next())
{
%>
subcat[<%=count%>] = new Array("<%=rs2.getString("CL2_NAME")%>","<%=rs2.getString("CL1_NAME")%>");
<%
count = count + 1;
}
rs2.close();
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.myform.CL2_NAME.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.CL2_NAME.options[document.myform.CL2_NAME.length] = new Option(subcat[i][0], subcat[i][0]);
}
}
}
</script>
<link rel="stylesheet" type="text/css" href="../style.css">
<body>
<p>
</p>
<p> </p>
<p> </p>
<table width="771" border="0" cellspacing="0" cellpadding="0" height="279">
<tr>
<td width="771" height="279">
<form action="addcl2.jsp" method="POST" name="myform" id="myform">
<input type="hidden" name="options" >
<table width="67%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td align="center" bgcolor="#336699"><hr>
<span class="style1">商品小类管理</span></td>
</tr>
<tr align="center">
<td bgcolor="#EBEEF3"><p> </p>
<p>大类
<select name="CL1_NAME" id="CL1_NAME" onChange="changelocation(document.myform.CL1_NAME.value)" size="1">
<%String name1=null;
sql="select * from Class1";
ResultSet rs = st.executeQuery(sql);
if(!rs.next()){
out.print("<option value=>请增加类别");
}else{
rs.absolute(1);
String CL1_NAME=null;
name1=rs.getString("CL1_NAME");
out.print("<option value=" +name1+">" +name1+ "</option>");
while(rs.next()){
CL1_NAME=rs.getString("CL1_NAME");
out.print("<option value=" +CL1_NAME+">" +CL1_NAME+ "</option>");
}
}
%>
</select>
<br>
</p></td>
</tr>
<tr>
<td bgcolor="#EBEEF3"><div align="center"><center>
<p align="left"><b> 小类</b>
<select name="CL2_NAME" size="1" id="CL2_NAME" style="font-size: 9pt">
<%
sql="select * from Class2 where CL1_NAME='"+name1+"'";
rs=st.executeQuery(sql);
System.out.println(sql);
if(rs.next())
{
rs.absolute(1);
%>
<option value="<%=rs.getString("CL2_NAME")%>"><%=rs.getString("CL2_NAME")%></option>
<%
while(rs.next())
{%>
<option value="<%=rs.getString("CL2_NAME")%>"><%=rs.getString("CL2_NAME")%></option>
<%
}
}
%>
</select>
<input type="submit" value="删除" name="B2" onclick="form.options.value='del'"></td>
</tr>
<tr align="center">
<td bgcolor="#EBEEF3"><br>
</td>
</tr>
<tr align="center">
<td bgcolor="#EBEEF3"><p>修改：
<input type="text" name="reTitle" size="20" class=smallinput>
<input type="submit" value="改名" name="B1" onclick="return B1_onsubmit()"><br>
</td>
</tr>
<tr align="center">
<td bgcolor="#EBEEF3"><br>
</td>
</tr>
<tr align="center">
<td bgcolor="#EBEEF3"><p>新增：
<input type="text" name="newTitle" size="20" class=smallinput>
<input type="submit" value="新增" name="B3" onclick="return B3_onsubmit()"></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
rs.close();
st.close();
}catch(Exception e){
//错误处理
throw (e);
}
%>
</body>
</html>
<%
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -