javaでHTMLのファイルを読みだして財務分析をして流動比率というものを調べたいのですが普通に計算したほうが早いのはわかっているのですが、javaでやりたいです!
これは読みだした結果です。
ここから、流動比率を計算したいのですが、取り出し方がわからないです。
そもそもなんですが、HTMLの分析は可能ですか??
HTML
1 2<tr style="min-height: 27px"> 3<td style="border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle"> 4<p style="margin-left: 30px; line-height: 13.33px; margin-right: 6px; text-align: left"> 5<span style="font-family: 'MS Mincho'; font-size: 12px">流動資産合計</span> 6</p> 7</td> 8<td style="border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle"> 9<p style="line-height: 13.33px; text-align: center"> </p> 10</td>...
さらに追記です。
java
1 2/* 3 * To change this license header, choose License Headers in Project Properties. 4 * To change this template file, choose Tools | Templates 5 * and open the template in the editor. 6 */ 7package kakaku_com; 8 9import java.io.PrintWriter; 10import javax.servlet.ServletException; 11import javax.servlet.http.HttpServlet; 12import javax.servlet.http.HttpServletRequest; 13import javax.servlet.http.HttpServletResponse; 14import java.io.File; 15import java.io.FileReader; 16import java.io.IOException; 17import javax.lang.model.util.Elements; 18import org.jsoup.nodes.Element; 19import org.w3c.dom.Document; 20 21 22/** 23 * 24 * @author ichinosemasahiro 25 */ 26public class serch_1 extends HttpServlet { 27 28public class Main { 29 public void takeurl(String[] args) { 30 try { 31 //Fileクラスに読み込むファイルを指定する 32 File file = new File("/Users/ichinosemasahiro/Desktop/Xbrl_Search_20180426_120405/S100CBQ2/XBRL/PublicDoc/0104020_honbun_jpcrp040300-q3r-001_E05350-000_2017-12-31_01_2018-02-09_ixbrl.htm"); 33 //ファイルが存在するか確認する 34 if(file.exists()) { 35 //FileReaderクラスのオブジェクトを生成する 36 FileReader filereader = new FileReader(file); 37 //filereaderクラスのreadメソッドでファイルを1文字ずつ読み込む 38 int data; 39 while((data = filereader.read()) != -1) { 40 System.out.print((char) data); 41 } 42 //ファイルクローズ 43 filereader.close(); 44 } else { 45 System.out.print("ファイルは存在しません"); 46 } 47 } catch (IOException e) { 48 e.printStackTrace(); 49 50 String html = "<tr style=\"min-height: 27px\">\r\n" + 51 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 52 "<p style=\"margin-left: 30px; line-height: 13.33px; margin-right: 6px; text-align: left\">\r\n" + 53 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">流動資産合計</span>\r\n" + 54 "</p>\r\n" + 55 "</td>\r\n" + 56 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 57 "<p style=\"line-height: 13.33px; text-align: center\"> </p>\r\n" + 58 "</td>\r\n" + 59 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 60 "<p style=\"line-height: 13.33px; margin-right: 6px; text-align: right\">\r\n" + 61 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">34,303</span>\r\n" + 62 "</p>\r\n" + 63 "</td>\r\n" + 64 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 65 "<p style=\"line-height: 13.33px; margin-right: 6px; text-align: right\">\r\n" + 66 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">36,762</span>\r\n" + 67 "</p>\r\n" + 68 "</td>\r\n" + 69 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 70 "<p style=\"line-height: 13.33px; margin-right: 6px; text-align: right\">\r\n" + 71 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">28,016</span>\r\n" + 72 "</p>\r\n" + 73 "</td>\r\n" + 74 "</tr>\r\n" + 75 "<tr style=\"min-height: 27px\">\r\n" + 76 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 77 "<p style=\"margin-left: 30px; line-height: 13.33px; margin-right: 6px; text-align: left\">\r\n" + 78 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">流動負債合計</span>\r\n" + 79 "</p>\r\n" + 80 "</td>\r\n" + 81 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 82 "<p style=\"line-height: 13.33px; text-align: center\"> </p>\r\n" + 83 "</td>\r\n" + 84 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 85 "<p style=\"line-height: 13.33px; margin-right: 6px; text-align: right\">\r\n" + 86 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">6,917</span>\r\n" + 87 "</p>\r\n" + 88 "</td>\r\n" + 89 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 90 "<p style=\"line-height: 13.33px; margin-right: 6px; text-align: right\">\r\n" + 91 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">6,809</span>\r\n" + 92 "</p>\r\n" + 93 "</td>\r\n" + 94 "<td style=\"border-left: 1px solid #000000; border-top: 1px solid #000000; border-right: 1px solid #000000; border-bottom: 1px solid #000000; vertical-align: middle\">\r\n" + 95 "<p style=\"line-height: 13.33px; margin-right: 6px; text-align: right\">\r\n" + 96 "<span style=\"font-family: 'MS Mincho'; font-size: 12px\">5,339</span>\r\n" + 97 "</p>\r\n" + 98 "</td>\r\n" + 99 "</tr>"; 100 org.jsoup.nodes.Document doc = org.jsoup.Jsoup.parse(html); 101 org.jsoup.select.Elements spans = doc.select("span"); 102 for (Element el : spans) 103 System.out.println(el.text());} 104 } 105 106} 107 108 /** 109 * Processes requests for both HTTP <code>GET</code> and <code>POST</code> 110 * methods. 111 * 112 * @param request servlet request 113 * @param response servlet response 114 * @throws ServletException if a servlet-specific error occurs 115 * @throws IOException if an I/O error occurs 116 */ 117 protected void processRequest(HttpServletRequest request, HttpServletResponse response) 118 throws ServletException, IOException { 119 response.setContentType("text/html;charset=UTF-8"); 120 try (PrintWriter out = response.getWriter()) { 121 /* TODO output your page here. You may use following sample code. */ 122 out.println("<!DOCTYPE html>"); 123 out.println("<html>"); 124 out.println("<head>"); 125 out.println("<title>Servlet serch_1</title>"); 126 out.println("</head>"); 127 out.println("<body>"); 128 out.println("<h1>Servlet serch_1 at " + request.getContextPath() + "</h1>"); 129 out.println("</body>"); 130 out.println("</html>"); 131 } 132 } 133 134 // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code."> 135 /** 136 * Handles the HTTP <code>GET</code> method. 137 * 138 * @param request servlet request 139 * @param response servlet response 140 * @throws ServletException if a servlet-specific error occurs 141 * @throws IOException if an I/O error occurs 142 */ 143 @Override 144 protected void doGet(HttpServletRequest request, HttpServletResponse response) 145 throws ServletException, IOException { 146 processRequest(request, response); 147 } 148 149 /** 150 * Handles the HTTP <code>POST</code> method. 151 * 152 * @param request servlet request 153 * @param response servlet response 154 * @throws ServletException if a servlet-specific error occurs 155 * @throws IOException if an I/O error occurs 156 */ 157 @Override 158 protected void doPost(HttpServletRequest request, HttpServletResponse response) 159 throws ServletException, IOException { 160 processRequest(request, response); 161 } 162 163 /** 164 * Returns a short description of the servlet. 165 * 166 * @return a String containing servlet description 167 */ 168 @Override 169 public String getServletInfo() { 170 return "Short description"; 171 }// </editor-fold> 172 173} 174
エラーは何も出ていないのですが、結果が思った通りに表示されませんでした、どこがおかしいのでしょうか。GWですが、よろしくお願いいたします!!
回答3件
あなたの回答
tips
プレビュー