将数据解析为表格 [英] Parsing data into tables

问题描述

我通过jdbc创建了与Mysql和java程序的连接。现在我想填充mysql数据库中的表。如何从java代码中将数据解析为表？

I have created a connection with Mysql and java program via jdbc. Now I want to populate the tables in the mysql database. How do I parse the data into the tables from the java code?

我有两个输入数据文件。文件格式如下：

I have two input data files.The format of file is like:

"AAH196","17:13:00","02:49:00",287,166.03,"Austin","TX","Virginia Beach","VA"
"AAH3727","21:38:00","03:04:00",273,176.44,"Los Angeles","CA","Colorado Springs","CO" 

推荐答案

您可以使用 LOAD DATA INFILE SQL命令。

You can use the LOAD DATA INFILE SQL command.

这篇关于将数据解析为表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！