java ajax 联动菜单_ajax + java + jsp 做的二级菜单联动（全）

----------------------index.jsp----------------------

String path = request.getContextPath();

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

%>

ajax + java + jsp 做的二级菜单联动

This is my JSP page. kao

选择一级分类

ConnDB cdb = new ConnDB();

Connection con = cdb.getCon();

Statement stmt = null;

String sql = "select * from category where level=0";

//String parentid = "2";

//String sql = "select * from category where parentid="+parentid;

ResultSet rs = null;

try {

stmt = con.createStatement();

rs = stmt.executeQuery(sql);

while(rs.next()){

System.out.println(rs.getInt(4));

rs.getInt(4);

%>

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

rs.close();

stmt.close();

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

%>

请选择。。。

------------------------ajax.jsp---  连接数据库取相对应的值 ----------

String path = request.getContextPath();

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

%>

My JSP 'ajax.jsp' starting page

This is my JSP page.

String parentid = request.getParameter("id");

//String parentid="2";

//int id = Integer.parseInt(parentid);

System.out.println(parentid+"");

ConnDB cdb = new ConnDB();

Connection con = cdb.getCon();

Statement stmt = null;

String sql = "select * from category where parentid="+parentid;

ResultSet rs = null;

try {

stmt = con.createStatement();

rs = stmt.executeQuery(sql);

System.out.println("----");

int j = 0;

while(rs.next()){

j++;

System.out.println(rs.getString(2));

response.getWriter().print(rs.getString(2));

response.getWriter().print(',');

//response.getWriter().print(',');

}

response.getWriter().print(',');

} catch (SQLException e) {

System.out.println("-------AAAAAAAAAA------");

e.printStackTrace();

}finally{

// response.getWriter().print("work");

try {

rs.close();

stmt.close();

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

%>