这个和上一篇文章是异曲同工之处,不过这个是基于javaWeb的servlet和轻量级jdbcTemplate对数据库的操作
数据库中的表:
结构目录:
1.Entit层
Province
public class Province {
public Integer pid;
public String pname;
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
public String getPname() {
return pname;
}
public void setPname(String pname) {
this.pname = pname;
}
}
City
public class City {
public Integer cid;
public String cname;
public Integer getCid() {
return cid;
}
public void setCid(Integer cid) {
this.cid = cid;
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
}
District层
public class District {
public Integer dis;
public String dname;
public Integer getDis() {
return dis;
}
public void setDis(Integer dis) {
this.dis = dis;
}
public String getDname() {
return dname;
}
public void setDname(String dname) {
this.dname = dname;
}
}
2.Dao.Iconnectionloading
public interface Iconnectionloading {
public List<Province> selectAll();
public List<City> selectByPid(Integer pid);
public List<District> selectByCid(Integer cid);
}
3.Dao.Impl.conectionloadingImpl
public