best365(中文版)官网登录-Official Platform

XML 地图 package com.wyebd.controller; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.log4j.Logger; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RestController; import org.springframework.web.servlet.ModelAndView; import com.alibaba.fastjson.JSON; import com.wyebd.bean.Contract; import com.zhuozhengsoft.pageoffice.OpenModeType; import com.zhuozhengsoft.pageoffice.PageOfficeCtrl; import com.zhuozhengsoft.pageoffice.wordwriter.WordDocument; @RestControllerpublic class ReadDataController {    private static Logger log = Logger.getLogger(ReadOnlyController.class);    private final String DB_URL = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";    private static final String USER = "root";    private static final String PASS = "root";    private static Connection con = null;    private static PreparedStatement ps = null;    private static Statement stmt = null;    private static ResultSet rs = null;         /**      * 跳转至查询页面      * @param request      * @param response      * @param map      * @return     */     @RequestMapping(value = "/readData", method = RequestMethod.GET)    public ModelAndView readData() {         ModelAndView mv = new ModelAndView("readData");        return mv;     }         /**      * 保存      * @param request      * @param response      * @param map      * @return     */     @RequestMapping("saveInfo")    public String saveInfo(HttpServletRequest request, HttpServletResponse response, Map map) {         List list = new ArrayList();         String firstname = request.getParameter("firstname");         String lastname = request.getParameter("lastname");         String phone = request.getParameter("phone");         String email = request.getParameter("email");         String json = null;        int id = 0;        try {             getConnection();             ps = con.prepareStatement("insert into test values (?,?,?,?,?)");             ps.setInt(1, id);             ps.setString(2, firstname);             ps.setString(3, lastname);             ps.setString(4,phone);             ps.setString(5, email);             ps.executeUpdate();             log.info("添加成功");             rs = stmt.executeQuery("select * from test");            while(rs.next()){                 Contract con = new Contract();                 con.setFirstname(rs.getString("firstname"));                 con.setLastname(rs.getString("lastname"));                 con.setPhone(rs.getString("phone"));                 con.setEmail(rs.getString("email"));                 list.add(con);             }            // list转为json传入前端             json = JSON.toJSONString(list);             log.info(json);            // 取得流向JSP传递数据             response.setContentType("text/html;charset=UTF-8");             response.getWriter().println(json);             response.reset();         } catch (Exception e) {             log.info("SQLException: " + e.getMessage());             e.printStackTrace();         } finally {            try {                 ps.close();                 con.close();             } catch (SQLException e) {                 e.printStackTrace();             }         }         return json;     }    /**      * 连接数据库      * @throws ClassNotFoundException      * @throws SQLException     */     public void getConnection() throws ClassNotFoundException, SQLException {        try {             Class.forName("com.mysql.jdbc.Driver");             con = DriverManager.getConnection(DB_URL, USER, PASS);             stmt = con.createStatement();         } catch (Exception e) {             System.out.println("SQLException: " + e.getMessage());             e.printStackTrace();         }     }      }

XML 地图