解析文件写入数据库代码（附件）.docVIP

1、自动解析文件写入数据库代码批量向数据库导入数据：各数据段以 | 作为分界线（使用struts框架） action： public ActionForward upLoadOne(ActionMapping mapping, ActionForm form,???HttpServletRequest request, HttpServletResponse response) {??UpfileForm upfileForm = (UpfileForm) form;// TODO Auto-generated?????????????// method stub??FormFile file = upfileForm.getFiledata();// 取得上传的文件??String encoding = request.getCharacterEncoding(); // 设置编码??if ((encoding != null) (encoding.equalsIgnoreCase(utf-8))) {???response.setContentType(text/html; charset=gb2312);// 如果没有指定编码，编码格式为gb2312??}??ServletContext context = getServlet().getServletContext();??String filePath = context.getRealPath(/) + upLoad;???UpLoad up = new UpLoad();??try {??? String path = up.up(filePath,file);??? HashMapInteger, Integer map = up.Validate(path);??? request.setAttribute(all, map.get(0));??? request.setAttribute(err, map.get(1));??? request.setAttribute(ret, map.get(2));??} catch (Exception e) {???// TODO Auto-generated catch block???e.printStackTrace();??}?? return mapping.findForward(win);?} ? server： public class UpLoad {?public String up(String path, FormFile file) throws Exception {??// TODO 自动生成方法存根????String dataPath = null;? // 数据路径????String fileName = null;????????? InputStream stream = file.getInputStream();// 把文件读入?????????? // String filePath1 = request.getRealPath(/);//取当前系统路径???????????????? //? String filePath = getServlet().getServletContext().getRealPath(/)+upLoad;? // Servlet 取路径的方式??????????????????? if(!new File(path).isDirectory())???????? //如果没有此文件夹就建立一个?????????? {???????? ?? new File(path).mkdirs();?????????? }?????????? fileName = file.getFileName();?????????? dataPath = path +/+ fileName;?????????? OutputStream bos = new FileOutputStream(dataPath);// 建立一个上传文件的输出流?????????? int bytesRead = 0;?????????? byte[] buffer = new byte[8192];?????????? while ( (bytesRead = stream.read(buffer, 0, 8192)) != -1) {???????????? bos.write(buffer, 0, bytesRead);// 将文件写入服务器???????????? }????