/** * @author WH * @description 导出风控表 * @date 2017/10/11 11:28 */ @WebServlet("/export/risk") public class ExportRiskCheckWordServlet extends HttpServlet { private static final long serialVersionUID = 1L; public Logger logger = LogManager.getLogger(this.getClass()); public ExportRiskCheckWordServlet() { super(); } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) { doPost(request, response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) { Integer id = Integer.valueOf((String) request.getParameter("id")); Connection conn = null; DataSource ds = Utils.getDs(); conn = ds.getConnection(); conn.setAutoCommit(false); QueryRunner run = new QueryRunner(); ResultSetHandler<List<Map<String, Object>>> h = new MapListHandler(); list = run.query(conn, " SELECT o.id FROM fdd_order o WHERE o.ID = ? ", h, new Object[]{id}); } }