/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package cn.toher.DataImport; import cn.toher.bean.User; import cn.toher.connection.DBConnectionManager; import static cn.toher.util.common.ReadTxtImport.readTxtFile; import java.io.File; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.lang.StringUtils; /** * * @author Administrator */ @WebServlet(name = "DataImportServlet", urlPatterns = {"/tohersystem/dataimport"}) public class DataImportServlet extends HttpServlet { /** * Processes requests for both HTTP <code>GET</code> and <code>POST</code> * methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */ /* 1,上传文件 * 2,获取路径 3,处理 */ String path = request.getParameter("filePath"); String filePath = request.getSession().getServletContext().getRealPath("/") +path; System.out.println("DataImportServlet_51: "+filePath); DBConnectionManager pool =null; Connection conn = null; pool = DBConnectionManager.getInstance(); conn = pool.getConnection("db"); // String filePath = "F:\MigrationData.txt"; User user = (User)request.getSession().getAttribute("Suser"); String parentNo = (user.getParentNo() != null ? user.getParentNo() : user.getUserNo()); MigrationData migrationData = new MigrationData(); Object[] a = {parentNo}; String result = readTxtFile(filePath,"calls_item_package",migrationData,conn,"GBK",a); if(StringUtils.isNumeric(result)){ out.print("success"); }else out.print(result); } } // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> /** * Handles the HTTP <code>GET</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Handles the HTTP <code>POST</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); } /** * Returns a short description of the servlet. * * @return a String containing servlet description */ @Override public String getServletInfo() { return "Short description"; }// </editor-fold> }