java - 在从解析器写入数据库之前如何更改数据的格式？

Question

我正在通过解析器从 txt 文件将数据写入数据库。我使用的代码是这样的:

BufferedReader reader = new BufferedReader(new FileReader("C:/Users/RPR/Desktop/test.txt"));

            String dados[] = new String[6];
            String linha = reader.readLine();

            while (linha != null) {

                StringTokenizer st = new StringTokenizer(linha, ";\"");

                dados[0] = st.nextToken();
                dados[1] = st.nextToken(); 
                dados[2] = st.nextToken();
                dados[3] = st.nextToken();
                dados[4] = st.nextToken();

                DateFormat dateFormat = new SimpleDateFormat("d-M-yy");

PreparedStatement stmt = (PreparedStatement) conexao.prepareStatement("replace into registos"
   + " (date, hour, IdSensor, Temp, Humid) values (?,?,?,?,?)");
                        try {
                            stmt.setDate(1, new java.sql.Date(dateFormat.parse(dados[0]).getTime()));
                            stmt.setString(2, dados[1]);
                            stmt.setString(3, dados[2]);
                            stmt.setString(4, dados[3]);


                        } catch (java.text.ParseException ex) {
                            Exceptions.printStackTrace(ex);
                        }

stmt.executeUpdate();

                linha = reader.readLine();

但是，有些数据采用以下格式:--- 我想在写入数据库之前将它们转换为0。有谁知道有什么可以做到这一点吗？

Answer 1

要清理数据，请使用 replace() 方法:

stmt.setString(2, dados[1].replace("-", "0")); // etc for other data