SpringMVC3+jdbc demo

package com.tx.demo.action; /** * @author zlx; * */ import java.io.PrintWriter; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONObject; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import com.tx.demo.dao.UserDaoImpl; @Controller @RequestMapping("/main") public class MainAction { @Autowired @Qualifier("dao") UserDaoImpl userDaoImpl; @RequestMapping(value = "view/{name}", method = RequestMethod.GET) public void view(HttpServletRequest request, HttpServletResponse response, @PathVariable("name") String name) throws Exception { List<Map<String, Object>> list = userDaoImpl.query(name); // JSONArray jsonArray = JSONArray.fromObject(list); JSONObject json = JSONObject.fromObject(list.get(0)); response.setCharacterEncoding("GBK"); PrintWriter prw = response.getWriter(); prw.print(json); prw.flush(); prw.close(); System.out.println("----over----"); } }