java + ajax(三级联动)　myself

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    String contextPath = request.getContextPath();

if (request.getProtocol().compareTo("HTTP/1.0") == 0) {
        response.setHeader("Pragma","no-cache");
    } else {
        response.setHeader("Cache-Control","no-cache");
    }

    response.setDateHeader("Expires", 0);
%>

function init() {
var categoryId = "1";
getSubCategory(categoryId);
}

function showRoles(obj) {
document.getElementById(obj).parentNode.style.display = "";
document.getElementById(obj).innerHTML = "正在读取数据........";
testPos=obj;
send_request('sample_10.jsp');
}

function getSubCategory(subCategoryObj) {
send_request("getDropDownList.jsp?flag=subCategory&categoryid="+subCategoryObj);
}

function getProduct(productObj) {
send_request("getDropDownList.jsp?flag=product&subid="+productObj);
}

function setSelectObj(obj) {
    var arr1 = new Array();
    var arr2 = new Array();
    var arr3= new Array();
    var str = "";

function trimString(sStr) {
//by xmzh
if (sStr == null) return "";
return sStr.replace(/(^\s*)|(\s*$)/ig,"");
}
</script>

getDropDownList.jsp

<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="UTF-8"%>
<%
Connection conn = null;
ResultSet rs = null;
PreparedStatement ps = null;
String sub_id = "";
String sub_name = "";
String p_id = "";
String p_name = "";
String categoryid = request.getParameter("categoryid");
String subid = request.getParameter("subid");
String flag = request.getParameter("flag");

String str1= "";
String str2= "";

StringBuffer sb = new StringBuffer("");
StringBuffer sb1 = new StringBuffer("");
StringBuffer sb2 = new StringBuffer("");
StringBuffer sb3 = new StringBuffer("");

try {
  String drivername="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=webportalTest";

  try {
   Class.forName(drivername);
   conn=DriverManager.getConnection(url,"sa","206073");
  }catch(SQLException e){
  System.out.println(e.getMessage());
  }



  if (categoryid != null && ("subCategory".equals(flag) || "subCategory" == flag)) {
   ps = conn.prepareStatement("select * from T_SubCategory where categoryId='"+ categoryid + "'");
   rs = ps.executeQuery();

   while (rs.next()) {
    sub_id = rs.getString("id");
    sub_name = rs.getString("name");
    sb.append( sub_id + ",");
    sb1.append(sub_name+",");
   }

   if (!sb.toString().equals("") && !sb1.toString().equals("")) {
    str1= sb.substring(0,sb.length()-1);
    str2= sb1.substring(0,sb1.length()-1);
    out.print(str1+"@"+str2+"@subCategory");
   }
  } else if (subid != null && ("product".equals(flag) || "product" == flag)) {
   ps = conn.prepareStatement("select * from T_Product where subCategoryId='"+ subid + "'");
   rs = ps.executeQuery();

   while (rs.next()) {
    p_id = rs.getString("id");
    p_name = rs.getString("name");
    sb2.append(p_id + ",");
    sb3.append(p_name + ",");
   }

   if (!sb2.toString().equals("") && !sb3.toString().equals("")) {
    String str3 = sb2.substring(0,sb2.length()-1);
    String str4 = sb3.substring(0,sb3.length()-1);
    out.print(str3 + "@" + str4 + "@product");
   }
  }
} catch (Exception ex) {
  ex.printStackTrace();
  out.println("异常:" + ex.getMessage());
} finally {
  try {
   rs.close();
   ps.close();

   if (conn != null) {
    conn.close();
   }
  } catch (Exception e) {
   rs = null;
   ps = null;
   conn = null;
   e.printStackTrace();
  }
}
%>

posted @ 2008-04-21 15:21 南守拥阅读(1153) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

我思考..我存在..

好好学习..天天向上.. 159753258 楼上我老婆，楼下是我！呼叫中心、小型信息管理系统，电话：13516218837

java + ajax(三级联动)　myself

公告

我思考..我存在..

好好学习..天天向上.. 159753258 楼上我老婆，楼下是我！ 呼叫中心、小型信息管理系统，电话：13516218837

java + ajax(三级联动) myself

公告

好好学习..天天向上.. 159753258 楼上我老婆，楼下是我！呼叫中心、小型信息管理系统，电话：13516218837

java + ajax(三级联动)　myself