jq mysql二级联动,jquery ajax select 二级联动

产品分类需要做二级分类

代码清单1：

package com.servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.List;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;

import com.bean.SecondType;

import com.factory.DAOFactory;

public class QuerySecondTypeByMainTypeIdServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

@Override

protected void doPost(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

int main_type_id=Integer.parseInt(req.getParameter("main_type"));

List listST= DAOFactory.getTypeDAOInstance().getSecondTypeByMainTypeId(main_type_id);

JSONArray object = JSONArray.fromObject(listST);

System.out.println(object.toString());

sendMsg(object.toString(), resp);

}

@Override

protected void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

doPost(req, resp);

}

public void sendMsg(String content,HttpServletResponse response)throws IOException{

response.setCharacterEncoding("utf-8");

PrintWriter out =response.getWriter();

out.write(content);

out.flush();

out.close();

}

}

代码清单2：

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

My JSP 'addSecondType.jsp' starting page

$(document).ready(function(){

$("#main_type").change(function(){

// alert($(this).val());

$_mainTypeId=$(this).val();

$.getJSON("./querySecondTypeByMainTypeId.do?main_type="+$_mainTypeId,"",function(response){

$("#second_type").show();

$("#second_type option").remove();

$.each(response,function(i){

//console.dir(response[i]);

$("#second_type").append(""+response[i].second_type_name+"");

});

});

});

})

List listMT= DAOFactory.getTypeDAOInstance().queryAllMainType();

%>

类别：

for(int i=0;i

MainType mainType= (MainType)listMT.get(i);

int main_type_id= mainType.getMain_type_id();

String main_type_name= mainType.getMain_type_name();

%>

}

%>

效果截图

代码很恶心,大家凑合看吧。

知识点总结:

1.JSONArray封装数据

2.jquery 对select 操作

3.复习jquery ajax操作