java ajax三級關聯_ajax實作省市三級關聯效果

本文執行個體為大家分享了ajax實作三級關聯效果的具體代碼，供大家參考，具體内容如下

1、html代碼

Title

.wrap

{

background-color: beige;

width: 400px;

height: 200px;

margin: 0 auto;

text-align: center;

margin-top: 200px;

}

.wrap select

{

width:130px;

height: 30px;

}

function getctiydata() {

$("#city").empty();

var pid = $("#province").val();

$.ajax({

url:"/getCitys?pid="+pid,

dataType:"json"

}).done(function (data) {

for (var i in data)

{

$("#city").append($(""

+ data[i].name +""))

}

})

}

$.ajax({

url: "/getAllProvince",

dataType:"json"

}).done(function (data) {

for (var i in data)

{

$("#province").append($(""

+ data[i].name +""))

}

getctiydata()

});

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

getctiydata()

})

2、javaservlet

package servlet;

import DButil.DataSourceUtil;

import com.alibaba.fastjson.JSON;

import domain.Province;

import org.apache.commons.dbutils.QueryRunner;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import javax.jws.WebService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.sql.SQLException;

import java.util.List;

@WebServlet("/getAllProvince")

public class ProvinceServlet extends HttpServlet

{

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException

{

resp.setContentType("application/json;charset=utf8");

QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());

String sql = "select * from province";

try

{

List provinces = queryRunner.query(sql, new BeanListHandler(Province.class));

Object json = JSON.toJSON(provinces);

resp.getWriter().print(json);

} catch (SQLException e)

{

e.printStackTrace();

}

}

}

package servlet;

import DButil.DataSourceUtil;

import com.alibaba.fastjson.JSON;

import domain.City;

import org.apache.commons.dbutils.QueryRunner;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import javax.jws.WebService;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.sql.SQLException;

import java.util.List;

@WebServlet("/getCitys")

public class CityServlet extends HttpServlet

{

@Override

protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException

{

resp.setContentType("application/json;charset=utf8");

QueryRunner queryRunner = new QueryRunner(DataSourceUtil.getDataSource());

String pid = req.getParameter("pid");

String sql = "select * from City where pid=?";

try

{

List cities = queryRunner.query(sql, new BeanListHandler(City.class), pid);

Object toJSON = JSON.toJSON(cities);

resp.getWriter().print(toJSON);

} catch (SQLException e)

{

e.printStackTrace();

}

}

}

3、資料庫池化

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/text

root

root

以上就是省市關聯的核心代碼。

以上就是本文的全部内容，希望對大家的學習有所幫助，也希望大家多多支援腳本之家。