可配级联无刷新下拉框(原稿)-CSDN博客

此作品实现用ajax开发可配级联地刷新下拉框.

1.开发环境:eclipse+tomcat+mysql

2.工程名:ajax_select

3.主要涉及文件及内容:

-----页面------------

index.jsp

------工程配置------------

web.xml

------类文件------------

AjaxServlet.java

package com.ajax;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

public class AjaxServlet extends HttpServlet{
private static final String CONTENT_TYPE="text/xml; charset=gb2312";
public void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException{
     String myid = request.getParameter("id");
     String sql = "select id,pid,name,mylevel from region where pid = '"+myid+"'";
  Connection conn = null;
  try{
     ArrayList list = new ArrayList();
        Context ctx = new InitialContext();
        if(ctx == null )
            throw new Exception("No Context!");
        DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/ajax_select");
        if (ds != null) {
          conn = ds.getConnection();
          if(conn != null) {
          RegionBean rb = null;
              Statement stmt = conn.createStatement();
              ResultSet rs = stmt.executeQuery(sql);
              StringBuffer sb=new StringBuffer("<regions></regions>");
              while(rs.next()) {
              sb.append("<region></region>");
              sb.append("<id></id>").append(rs.getString(1)).append("");
              sb.append(" <pid></pid> ").append(rs.getString(2)).append("");
              sb.append("<name></name>").append(rs.getString(3)).append("");
              sb.append("<level></level>").append(rs.getString(4)).append("");
              sb.append("");
              }
              sb.append("");
              System.out.println(sb.toString());
              response.setContentType(CONTENT_TYPE);
              PrintWriter out=response.getWriter();
        out.write(sb.toString());
        out.close();
          }
        }
      }catch(Exception e) {
        e.printStackTrace();
      }finally{
      if(conn!=null){
        try {
      conn.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
      }
      }
}

public void doPost(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException{
doGet(request, response);
}
}

AjaxTest.java

package com.ajax;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;
import java.util.ArrayList;

public class AjaxTest {

   public ArrayList init() {
  String id = "";
  String pid = "";
     String name = "";
  ArrayList list = null;
  Connection conn = null;
     try{
       list = new ArrayList();
       Context ctx = new InitialContext();
       if(ctx == null )
           throw new Exception("Boom - No Context");

       DataSource ds =
             (DataSource)ctx.lookup(
                "java:comp/env/jdbc/ajax_select");

       if (ds != null) {
         conn = ds.getConnection();
         if(conn != null) {
         RegionBean rb = null;
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery("select id,pid,name,mylevel from region where pid = ''");

             while(rs.next()) {
             id =rs.getString(1);
             pid =rs.getString(2);
             name =rs.getString(3);
             rb = new RegionBean();
             rb.setId(id);
             rb.setPid(pid);
             rb.setName(name);
             list.add(rb);
             }
         }
       }
     }catch(Exception e) {
       e.printStackTrace();
     }finally{
     if(conn!=null){
       try {
     conn.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
     }
     return list;
     }
}
}

RegionBean.java

package com.ajax;

public class RegionBean {
String id = "";
String pid = "";
String name = "";
int level;

public String getId() { return id; }
public String getPid() { return pid;}
public String getName() { return name;}
public int getLevel(){return level;}

public void setId(String id){
   this.id=id;
}
public void setPid(String pid){
   this.pid=pid;
}
public void setName(String name){
   this.name=name;
}

public void setLevel(int level){
   this.level = level;
}
}

------sql语句

drop table if exists region;

create table region(
id varchar(30) not null,
pid varchar(30) null,
name varchar(50) null,
mylevel int not null,
primary key (id)
)
type = InnoDB;

insert into region(id,pid,name,mylevel) values('a01','','state1',0);
insert into region(id,pid,name,mylevel) values('a02','','state2',0);
insert into region(id,pid,name,mylevel) values('a03','','state3',0);
insert into region(id,pid,name,mylevel) values('a04','','state4',0);
insert into region(id,pid,name,mylevel) values('a05','','state5',0);

insert into region(id,pid,name,mylevel) values('a01b01','a01','province1',1);
insert into region(id,pid,name,mylevel) values('a01b02','a01','province2',1);
insert into region(id,pid,name,mylevel) values('a01b03','a01','province3',1);
insert into region(id,pid,name,mylevel) values('a01b04','a01','province4',1);

insert into region(id,pid,name,mylevel) values('a02b01','a02','province21',1);
insert into region(id,pid,name,mylevel) values('a02b02','a02','province22',1);
insert into region(id,pid,name,mylevel) values('a02b03','a02','province23',1);
insert into region(id,pid,name,mylevel) values('a02b04','a02','province24',1);

insert into region(id,pid,name,mylevel) values('a03b01','a03','province31',1);
insert into region(id,pid,name,mylevel) values('a03b02','a03','province32',1);
insert into region(id,pid,name,mylevel) values('a03b03','a03','province33',1);
insert into region(id,pid,name,mylevel) values('a03b04','a03','province34',1);

insert into region(id,pid,name,mylevel) values('a01b01c01','a01b01','city11',2);
insert into region(id,pid,name,mylevel) values('a01b01c02','a01b01','city12',2);
insert into region(id,pid,name,mylevel) values('a01b01c03','a01b01','city13',2);
insert into region(id,pid,name,mylevel) values('a01b01c04','a01b01','city14',2);

insert into region(id,pid,name,mylevel) values('a03b01c01','a03b01','city31',2);
insert into region(id,pid,name,mylevel) values('a03b01c02','a03b01','city32',2);
insert into region(id,pid,name,mylevel) values('a03b01c03','a03b01','city33',2);
insert into region(id,pid,name,mylevel) values('a03b01c04','a03b01','city34',2);

insert into region(id,pid,name,mylevel) values('a01b01c01d01','a01b01c01','region1',3);
insert into region(id,pid,name,mylevel) values('a01b01c01d02','a01b01c01','region2',3);
insert into region(id,pid,name,mylevel) values('a01b01c01d03','a01b01c01','region3',3);
insert into region(id,pid,name,mylevel) values('a01b01c01d04','a01b01c01','region4',3);

insert into region(id,pid,name,mylevel) values('a03b01c02d01','a03b01c02','region21',3);
insert into region(id,pid,name,mylevel) values('a03b01c02d02','a03b01c02','region22',3);
insert into region(id,pid,name,mylevel) values('a03b01c02d03','a03b01c02','region23',3);
insert into region(id,pid,name,mylevel) values('a03b01c02d04','a03b01c02','region24',3);

insert into region(id,pid,name,mylevel) values('a01b01c03d01','a01b01c03','region31',3);
insert into region(id,pid,name,mylevel) values('a01b01c03d02','a01b01c03','region32',3);
insert into region(id,pid,name,mylevel) values('a01b01c03d03','a01b01c03','region33',3);
insert into region(id,pid,name,mylevel) values('a01b01c03d04','a01b01c03','region34',3);

insert into region(id,pid,name,mylevel) values('a03b01c03d01','a03b01c03','region31',3);
insert into region(id,pid,name,mylevel) values('a03b01c03d02','a03b01c03','region32',3);
insert into region(id,pid,name,mylevel) values('a03b01c03d03','a03b01c03','region33',3);
insert into region(id,pid,name,mylevel) values('a03b01c03d04','a03b01c03','region34',3);

insert into region(id,pid,name,mylevel) values('a03b01c04d01','a03b01c04','county41',3);
insert into region(id,pid,name,mylevel) values('a03b01c04d02','a03b01c04','county42',3);
insert into region(id,pid,name,mylevel) values('a03b01c04d03','a03b01c04','county43',3);
insert into region(id,pid,name,mylevel) values('a03b01c04d04','a03b01c04','county44',3);

insert into region(id,pid,name,mylevel) values('a01b01c01d01e01','a01b01c01d01','town1',4);
insert into region(id,pid,name,mylevel) values('a01b01c01d01e02','a01b01c01d01','town2',4);
insert into region(id,pid,name,mylevel) values('a01b01c01d01e03','a01b01c01d01','town3',4);
insert into region(id,pid,name,mylevel) values('a01b01c01d01e04','a01b01c01d01','town4',4);

insert into region(id,pid,name,mylevel) values('a03b01c02d04e01','a03b01c02d04','town21',4);
insert into region(id,pid,name,mylevel) values('a03b01c02d04e02','a03b01c02d04','town22',4);
insert into region(id,pid,name,mylevel) values('a03b01c02d04e03','a03b01c02d04','town23',4);
insert into region(id,pid,name,mylevel) values('a03b01c02d04e04','a03b01c02d04','town24',4);

insert into region(id,pid,name,mylevel) values('a03b01c04d04e01','a03b01c04d04','town41',4);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e02','a03b01c04d04','town42',4);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e03','a03b01c04d04','town43',4);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e04','a03b01c04d04','town44',4);

insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f01','a03b01c04d04e01','village1',5);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f02','a03b01c04d04e01','village2',5);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f03','a03b01c04d04e01','village3',5);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f04','a03b01c04d04e01','village4',5);

insert into region(id,pid,name,mylevel) values('a01b01c01d01e02f01','a01b01c01d01e02','village21',5);
insert into region(id,pid,name,mylevel) values('a01b01c01d01e02f02','a01b01c01d01e02','village22',5);
insert into region(id,pid,name,mylevel) values('a01b01c01d01e02f03','a01b01c01d01e02','village23',5);
insert into region(id,pid,name,mylevel) values('a01b01c01d01e02f04','a01b01c01d01e02','village24',5);

insert into region(id,pid,name,mylevel) values('a03b01c02d04e04f01','a03b01c02d04e04','village41',5);
insert into region(id,pid,name,mylevel) values('a03b01c02d04e04f02','a03b01c02d04e04','village42',5);
insert into region(id,pid,name,mylevel) values('a03b01c02d04e04f03','a03b01c02d04e04','village43',5);
insert into region(id,pid,name,mylevel) values('a03b01c02d04e04f04','a03b01c02d04e04','village44',5);

insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f01g01','a03b01c04d04e01f01','smallvillage1',6);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f01g02','a03b01c04d04e01f01','smallvillage2',6);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f01g03','a03b01c04d04e01f01','smallvillage3',6);
insert into region(id,pid,name,mylevel) values('a03b01c04d04e01f01g04','a03b01c04d04e01f01','smallvillage4',6);

------Tomcat 的service.xml

请在%Tomcat_Home%/conf/service.xml文件里参照附件里的service.xml修改创建虚似路径

-------------------------------------------------------------------------------------------------------

工程原稿在附件里,详细见附件