获取商品分类信息 后端像前端传递json数据

dao代码

	public List<Category> finallCategory() throws Exception {
		QueryRunner qr=new QueryRunner(JDBCUtils.getDataSource());
		 List<Category> list = qr.query("select * from category ",new BeanListHandler<Category>(Category.class));
		 return list;
	}```
## service代码
```	private CategoryDao c=new CategoryDaoImp();
	public String findAllCategory() throws Exception {
		 List<Category> list = c.finallCategory();
		 String categorys = JsonUtil.list2json(list);
		return categorys;
	}

servlet代码

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.itcast.store.service.CategoryService;
import cn.itcast.store.service.Impl.CategoryServiceImp;
import cn.itcast.store.utils.JedisUtils;
import cn.itcast.store.web.base.BaseServlet;
import redis.clients.jedis.Jedis;

/**
 * Servlet implementation class CategoryServlet
 */
public class CategoryServlet extends BaseServlet {
	public String findAllCat(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Jedis jedis=JedisUtils.getJedis();
		String cats = jedis.get("allCats");
		if(cats!=null) {
			System.out.println("jedis中有数据！");
			response.setContentType("application/json;charset=utf-8");
			response.getWriter().write(cats);
		}else{
			try {
				System.out.println("缓存中没数据！");
				CategoryService cs=new CategoryServiceImp();
				String category = cs.findAllCategory();
				System.out.println(category);
				jedis.set("allCats", category);
				response.setContentType("application/json;charset=utf-8");
				response.getWriter().write(category);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		JedisUtils.closeJedis(jedis);
		return null;
	}

}

jsp（js）代码

	$(function(){
		var a=null;
	$.post("${pageContext.request.contextPath}/CategoryServlet",{"method":"findAllCat"},function(dt){
		$.each(dt,function(i,obj){
			 var li="<li><a href='ProductServlet?method=findByPage&page=1&cid="+obj.cid+"'>"+obj.cname+"</a> </li>";
			 
			 $("#myUL").append(li	);
		});		
		
	 },"json");
   });
   </script>```
## 用到的json工具类 
package cn.itcast.store.utils;

import java.util.List;
import java.util.Map;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import net.sf.json.JsonConfig;
import net.sf.json.util.CycleDetectionStrategy;
import net.sf.json.xml.XMLSerializer;

/**
 * 处理json数据格式的工具类
 * 
 * @Date 2013-3-31
 * @version 1.0
 */
public class JsonUtil {
	/**
	 * 将数组转换成String类型的JSON数据格式
	 * 
	 * @param objects
	 * @return
	 */
	public static String array2json(Object[] objects){
		
		JSONArray jsonArray = JSONArray.fromObject(objects);
		return jsonArray.toString();
		
	}
	
	/**
	 * 将list集合转换成String类型的JSON数据格式
	 * 
	 * @param list
	 * @return
	 */
	public static String list2json(List list){
		
		JSONArray jsonArray = JSONArray.fromObject(list);
		return jsonArray.toString();
		
	}
	
	/**
	 * 将map集合转换成String类型的JSON数据格式
	 * 
	 * @param map
	 * @return
	 */
	public static String map2json(Map map){
		
		JSONObject jsonObject = JSONObject.fromObject(map);
		return jsonObject.toString();
		
	}
	
	/**
	 * 将Object对象转换成String类型的JSON数据格式
	 * 
	 * @param object
	 * @return
	 */
	public static String object2json(Object object){
		
		JSONObject jsonObject = JSONObject.fromObject(object);
		return jsonObject.toString();
		
	}
	
	/**
	 * 将XML数据格式转换成String类型的JSON数据格式
	 * 
	 * @param xml
	 * @return
	 */
	public static String xml2json(String xml){
		
		JSONArray jsonArray = (JSONArray) new XMLSerializer().read(xml);
		return jsonArray.toString();
		
	}
	
	/**
	  * 除去不想生成的字段（特别适合去掉级联的对象）
	  *
	  * @param excludes
	  * @return
	*/
	public static JsonConfig configJson(String[] excludes) {
		JsonConfig jsonConfig = new JsonConfig();
		jsonConfig.setExcludes(excludes);
		jsonConfig.setIgnoreDefaultExcludes(true);
		jsonConfig.setCycleDetectionStrategy(CycleDetectionStrategy.LENIENT);
		return jsonConfig;
	}
	
}