读csv，写入数据库

最新推荐文章于 2022-02-10 22:04:30 发布

miao_hong_bin

最新推荐文章于 2022-02-10 22:04:30 发布

阅读量799

点赞数

分类专栏： struts学习笔记文章标签： csv exception buffer 数据库 path null

本文链接：https://blog.csdn.net/miao_hong_bin/article/details/274422

版权

struts学习笔记专栏收录该内容

21 篇文章 0 订阅

订阅专栏

filename = id;
       try {
        FileReader in = new FileReader(filename);
        BufferedReader buffer = new BufferedReader(in);
        while ((strIvNo = buffer.readLine()) != null) {
         ZaikuBean zaikubean1 = new ZaikuBean();
         int indexNo1 = strIvNo.indexOf(",");
         int indexNo2 =
          strIvNo.indexOf(",", indexNo1 + 1);
         strName = strIvNo.substring(0, indexNo1);
         strMailAddress =
          strIvNo.substring(
           indexNo1 + 1,
           indexNo2);
         if (!zaikubean1.getMail(strMailAddress)) {
          if (!zaikubean1
           .addUser(strName, strMailAddress)) {
           strCsvFlg = "Failure";
           throw new Exception("顧客の追加エラー!");
          } else {
           strCsvFlg = "Success";
          }
         } else {
          if (!zaikubean1
           .update(strName, strMailAddress)) {
           strCsvFlg = "Failure";
           throw new Exception("顧客の更新エラー!");
          } else {
           strCsvFlg = "Success";
          }

         }
        }
        request.setAttribute("strCsvFlg", strCsvFlg);
        LoginServlet loginServlet = new LoginServlet();
        loginServlet.SelectTable(request, response);
        RequestDispatcher dispatcher =
         getServletContext().getRequestDispatcher(
          PagePath.LIST_PATH);
        /*リスト画面へ遷移する*/
        dispatcher.forward(request, response);
       } catch (IOException e) {
        System.out.println("File read error: " + e);
       }