RoyalAjax(15)------QueryDictHandler.java

package com.ajax.setup;

import java.sql.SQLException;

import com.support.ajax.AjaxHandler;
import com.support.ajax.AjaxReturnBean;
import com.support.basic.DefaultAction;
import com.support.basic.RequestWrapper;
import com.support.db.QueryResult;

public class QueryDictHandler extends DefaultAction implements AjaxHandler {

 public AjaxReturnBean doHandlerAjax(RequestWrapper request) {
  AjaxReturnBean bean=new AjaxReturnBean();
  String dict_id=request.getString("dict_id");
  try {
   QueryResult result=query("select value from sys_select where class='"+dict_id+"'");
   String[] res=result.getCol("value");
   bean.setData(res);
  } catch (SQLException e) {
   e.printStackTrace();
   bean.setMsg(e.getMessage());
   bean.setStatus("fail");
  }
  return bean;
 }

}