tegory_name from category "); sGetCategorySQL.append("order by category_cd"); rs = stmt.executeQuery( sGetCategorySQL.toString() ); StringBuffer sCategoryBuffer = new StringBuffer(); if ( rs.next() ) { sCategoryBuffer = sCategoryBuffer.append("'" + rs.getString(1) ); sCategoryBuffer = sCategoryBuffer.append("','" + rs.getString(2) +"'"); while( rs.next() ) { sCategoryBuffer = sCategoryBuffer.append(",'" + rs.getString(1) ); sCategoryBuffer = sCategoryBuffer.append("','" + rs.getString(2) +"'"); } } sCategorys = sCategoryBuffer.toString(); //
查询小分类 sGetCategorySQL = new StringBuffer(); sGetCategorySQL.append("select category_cd, sub_category_cd, sub_category_name "); sGetCategorySQL.append("from sub_category order by category_cd, sub_category_cd"); rs = stmt.executeQuery( sGetCategorySQL.toString() ); StringBuffer sSubCategoryBuffer = new StringBuffer(); if ( rs.next() ) { sSubCategoryBuffer = sSubCategoryBuffer.append("'" + rs.getString(1) ); sSubCategoryBuffer = sSubCategoryBuffer.append("','" + rs.getString(2) ); sSubCategoryBuffer = sSubCategoryBuffer.append("','" + rs.getString(3) +"'"); while( rs.next() ) { sSubCategoryBuffer = sSubCategoryBuffer.append(",'" + rs.getString(1) ); sSubCategoryBuffer = sSubCategoryBuffer.append("','" + rs.getString(2) ); sSubCategoryBuffer = sSubCategoryBuffer.append("','" + rs.getString(3) +"'"); } } sSubCategorys = sSubCategoryBuffer.toString(); rs.close(); stmt.close(); %>
输入界面: 输入界面:addNew.js
window.onload = windowLoad; //--------------------------------4
//页面载入时调用 function windowLoad() { //设置大分类下拉框 var selCat = form_main.categoryCd; selCat.length = categoryArray.length/2; for ( var i=0; i
tegoryArray.length/3; i++) { if ( subCategoryArray[i*3] == selectedCat ) { bFindCategory = true; if ( subCategoryArray[i*3] == selectedCategoryCd &;&; subCategoryArray[i*3+1] == selectedSubCategoryCd ) { selSubCat.options[j] = new Option( subCategoryArray[i*3+2],subCategoryArray[i*3+1],true,true); } else { selSubCat.options[j] = new Option( subCategoryArray[i*3+2],subCategoryArray[i*3+1]); }
5
j++; } else { if ( bFindCategory ) { break; } } } selSubCat.length = j; } //表单 reset 的时候,需要做的特殊处理 function resetForm() { window.setTimeout("changeCategory()",100,"JavaScript"); } //登录前的检查 function checkInput() { //检查标题 if ( form_main.tipTitle.value.length < 1 ) { form_main.tipTitle.focus(); form_main.tipTitle.select(); alert("知识点标题不能为空!"); return false; } if ( hasSpecialChar(form_main.tipTitle.value,"\"") ) { form_main.tipTitle.focus(); form_main.tipTitle.select(); alert("知识点标题不能包含以下特殊字符:\r\n\""); return false; } if ( getLength(form_main.tipTitle.value)>90 ) { for