📄 pro_edit.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" errorPage="" %>
<jsp:useBean id="DBConn" scope="page" class="jspeshop.DBConn"/>
<%@ page import="java.sql.*" %>
<%
String sql=null;
String clname=null;
int count=0;
if(session.getAttribute("name")==null){
response.sendRedirect("index.jsp");
}
else{
String proid=request.getParameter("proid");
Connection con;
Statement st;
con = DBConn.GetConn();
st= con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql ="select * from Product where PRO_ID='"+proid+"'";
ResultSet rs1=st.executeQuery(sql);
if (rs1.next()){
String pro_name=rs1.getString("PRO_NAME");
String cl1=rs1.getString("CL1_NAME");
String cl2=rs1.getString("CL2_NAME");
String intro=rs1.getString("PRO_INTRO");
String pri=rs1.getString("PRO_PRI");
String vip_pri=rs1.getString("PRO_VIP_PRI");
String pic=rs1.getString("PRO_PIC");
sql="select * from Class2";
System.out.println("111111"+sql);
ResultSet rs2=st.executeQuery(sql);
%>
<html>
<head>
<link rel="stylesheet" type="text/css" href="../style.css">
<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();
<%
System.out .println("rs2.next()") ;
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("产品不能含有非数字的字符。");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -