📄 add_pro.jsp
字号:
<%@page contentType="text/html; charset=gb2312"%>
<jsp:useBean id="DBConn" scope="page" class="jspeshop.DBConn"/>
<%@page import="java.sql.*"%>
<%
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);
%>
<html>
<head>
<SCRIPT language=javascript >
//函数名：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;
}
}
//函数名：fucCheckNUM
//功能介绍：检查是否为数字
//参数说明：要检查的数字
//返回值：1为是数字，0为不是数字
function fucCheckNUM(NUM)
{
var i,j,strTemp;
strTemp="0123456789.";
if ( NUM.length== 0)
return 0
for (i=0;i<NUM.length;i++)
{
j=strTemp.indexOf(NUM.charAt(i));
if (j==-1)
{
//说明有字符不是数字
return 0;
}
}
//说明是数字
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">
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.form1.CL2_NAME.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.CL2_NAME.options[document.form1.CL2_NAME.length] = new Option(subcat[i][0], subcat[i][0]);
}
}
}
</script>
<script language="javascript">
//正常字符
function form1_onsubmit(){
if((document.form1.PRO_ID.value=='')||(chkspc(document.form1.PRO_ID.value)==0))
{
alert("产品编号不能包含空格。");
document.form1.PRO_ID.focus();
return false;
}
if (fucCheckNUM(document.form1.PRO_ID.value)==0)
{
alert("产品不能含有非数字的字符。");
document.form1.PRO_ID.focus();
return false;
}
if((document.form1.PRO_NAME.value=='')||(chkspc(document.form1.PRO_NAME.value)==0))
{
alert("名字不能包含空格。");
document.form1.PRO_NAME.focus();
return false;
}
if(chksafe(document.form1.PRO_NAME.value)==0) {
alert("名字请输入合法的字符。");
document.form1.PRO_NAME.focus();
return false;
}
if(document.form1.PRO_INTRO.value=='') {
alert("简介不能为空。");
document.form1.PRO_INTRO.focus();
return false;
}
if((document.form1.PRO_PRI.value=='')||(chkspc(document.form1.PRO_PRI.value)==0))
{
alert("价格不能包含空格。");
document.form1.PRO_PRI.focus();
return false;
}
if((fucCheckNUM(document.form1.PRO_PRI.value)==0))
{
alert("价格不能包含非数字。");
document.form1.PRO_PRI.focus();
return false;
}
if((document.form1.PRO_VIP_PRI.value=='')||(chkspc(document.form1.PRO_VIP_PRI.value)==0))
{
alert("价格不能包含空格。");
document.form1.PRO_VIP_PRI.focus();
return false;
}
if((fucCheckNUM(document.form1.PRO_VIP_PRI.value)==0))
{
alert("价格不能包含非数字。");
document.form1.PRO_PVI_PRI.focus();
return false;
}
}
</SCRIPT><meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../style.css">
<title>无标题文档</title>
<style type="text/css">
<!--
.style2 {color: #FF0000}
-->
</style>
</head>
<body>
<div align="center">
<p>所有的选项都要求填写</p>
<p> </p>
<form action="add_pro2.jsp" method="post" enctype="multipart/form-data" name="form1" onsubmit="return form1_onsubmit()">
<table width="536" height="421" border="0" cellspacing="1" bgcolor="#000000">
<caption align="bottom"> </caption>
<tr bgcolor="#EBEEF3">
<td> 所属大类
<select name="CL1_NAME" size="1" id="CL1_NAME" onChange="changelocation(document.form1.CL1_NAME.value)">
<%
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>
</td>
<td> 所属小类
<select id="CL2_NAME" name="CL2_NAME" size="1">
<%
sql = "select * from Class2 where CL1_NAME='" + name1 + "'";
rs = st.executeQuery(sql);
//System.out.println("小类查询完毕");
System.out.println(sql);
if (rs.next()) {
//System.out.println("小类存在");
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>
</td>
</tr>
<tr bgcolor="#EBEEF3">
<td> 产品编号
<input name="PRO_ID" type="text" id="PRO_ID">
<span class="style2">数字</span>
</td>
<td> 产品名称
<input name="PRO_NAME" type="text" id="PRO_NAME">
</td>
</tr>
<tr align="center" valign="middle" bgcolor="#EBEEF3">
<td height="86" colspan="2">
<p align="left">产品介绍</p>
<p>
<textarea name="PRO_INTRO" cols="50" rows="6" id="PRO_INTRO"> </textarea>
</p>
</td>
</tr>
<tr bgcolor="#EBEEF3">
<td> 普通价
<input name="PRO_PRI" type="text" id="PRO_PRI" size="12">
元
</td>
<td> 会员价
<input name="PRO_VIP_PRI" type="text" id="PRO_VIP_PRI" size="12">
元
</td>
</tr>
<tr bgcolor="#EBEEF3">
<td colspan="2"> 产品图片
<input name="PRO_PIC" type="file" id="PRO_PIC" size="50">
</td>
</tr>
<tr bgcolor="#EBEEF3">
<td>
<div align="right">
<input type="submit" name="Submit" value="提交">
</div>
</td>
<td>
<input name="reset" type="reset" id="reset" value="重置">
</td>
</tr>
</table>
</form>
<p> </p>
</div>
<%
rs.close();
st.close();
} catch (Exception e) {
//错误处理
throw (e);
}
%>
</body>
</html>
<%
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -