Java中省市区三级联动,附前后台及数据库

实体pojo
@Entity
@Table(name = "province_city_district")
@Data
public class PCD {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;
private int pid;
private String name;
@Override
public String toString() {
return "PCD [id=" + id + ", pid=" + pid + ", name=" + name + "]";
}
}
后台代码controller
@Controller
@RequestMapping("/login")
public class testController {
@Autowired
private testservice testService;
@RequestMapping("test")
public String demo() {
return "externalMessFilling/index11";
}
@RequestMapping("get")
@ResponseBody
public void getPCD(HttpServletRequest request,HttpServletResponse response) throws IOException {
response.setContentType("text/xml;Charset=UTF-8");
int pid = Integer.parseInt(request.getParameter("pid"));
List<PCD> pcdList = testService.findPCDByPid(pid);
String json = JSON.toJSONString(pcdList);
response.getWriter().write(json);
}
}
后台代码service
public interface testservice {
public List<PCD> findPCDByPid(int pid);
}
@Override
public List<PCD> findPCDByPid(int pid) {
return testDao.findPCDByPid