java - 从一个txt文件导入数据到android数据库

Question

我向您寻求帮助，因为很长一段时间以来我都在努力寻找此代码的解决方案...

我有一个像这样的 gps 轨迹的 txt。

WGS 84;
U  1;
C  255,0,0,2,-1.0;
L  -02:00:00
V  0.0 0.0 0 0 0 0 0.0 -1.0 0
E 0|1|00-NUL-00 00:00:00|00:00:00|0|2984
i I00
z  12.716222,42.410293,12.736302,42.449607
T  A 42.41060087ºN 12.72081354ºE 25-SEP-08 07:13:34 N 841.8 0.0 0.0 0.0 0 -1000.0 9999999562023526400000000.0 -1 -1.0 -1.0
T  A 42.41060045ºN 12.72082259ºE 25-SEP-08 07:13:39 s 842.7 0.0 0.0 0.0 0 -1000.0 9999999562023526400000000.0 -1 -1.0 -1.0
T  A 42.41060296ºN 12.72083248ºE 25-SEP-08 07:13:44 s 842.3 0.0 0.0 0.0 0 -1000.0 9999999562023526400000000.0 -1 -1.0 -1.0 `

我需要将这个坐标..导入这种格式的数据库...

{
  TracksDB tracksDB = new TracksDB(context);
  TrackPointsDB trackPointsDB = new TrackPointsDB(context);
  tracksDB.open();
  trackPointsDB.open();

  File file = new File(path);
  ObjectInputStream in = new ObjectInputStream(new FileInputStream(file));

  int count = 0;

  try
  {
     Track track;
     while ((track = (Track) in.readObject()) != null)
     {
        long id = tracksDB.insert(track.getName());

        ArrayList<TrackPoint> points = track.getTrackPoints();
        for (TrackPoint point : points)
        {
           trackPointsDB.insert(id, point.getLongitude(), point.getLatitude(), point.getAltitude(), point.getAccuracy(),
                 Long.toString(point.getTime()));
        }

        count++;
     }
  }
  catch (EOFException eof)
  {

  }

  // !// finally?
  in.close();
  tracksDB.close();
  trackPointsDB.close();

  return count;
}

我尝试打开一个轨道文件，但我不明白如何使用相同的导入过程创建一个数据库..请帮忙!谢谢

Answer 1

在调用插入方法之前，先调用一个创建数据库的方法。

例如。 -

public void createDatabase(){

  Class.forName("com.mysql.jdbc.Driver");

  Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

  Statement stmt = conn.createStatement();

  String sql = "CREATE DATABASE Tracks";

  stmt.executeUpdate(sql);

}

之后以同样的方式创建表。