/
DataSave.java
38 lines (30 loc) · 1.17 KB
/
DataSave.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
package datasave;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import core.GPSData;
import java.sql.DriverManager;
public class DataSave {
private String url = "jdbc:mysql://localhost:3306/";
private String dbName = "TrackOn";
private String driver = "com.mysql.jdbc.Driver";
private String userName = "root";
private String password = "gaurav";
public void saveData (GPSData data)
{
Connection conn = null;
try {
Class.forName(driver).newInstance();
conn = (Connection) DriverManager.getConnection(url+dbName,userName,password);
PreparedStatement preparedStatement = (PreparedStatement) conn.prepareStatement("INSERT INTO TrackOn ( `Lat`, `Long` , `currentTimeStamp`) VALUES ( ?, ?, ?)") ;
preparedStatement.setFloat(1,(float) data.getLatitude());
preparedStatement.setFloat(2, (float) data.getLongitude());
preparedStatement.setTimestamp(3, data.getTimestamp());
preparedStatement.executeUpdate();
conn.close();
}
catch (Exception e)
{
System.out.println("This entry is already existing, position of the person is static, there is no change in the person position.") ;
}
}
}