我试图将数据从spraprehseet.csv插入到我的数据库中,但无法解析布尔值。它总是将布尔值作为所有列的false。
在我的播放器中,我既有和错误又是错误的,但是当我上传到db时,它将所有coumn均为false。
我正在尝试解析以boolean值为true或false
的in_service属性我需要两个值(True和False)
希望我做对吗?
try {
// read line
String[] fileData;
String line = dis.readLine().replaceAll(""", "");
fileData = line.split(",");
int tripID = Integer.parseInt(fileData[0]);
int driver_id = Integer.parseInt(fileData[1]);
String timestamp = fileData[2];
boolean in_service = Boolean.parseBoolean(fileData[3]);
int trips_pos = Integer.parseInt(fileData[4]);
double lat = Double.parseDouble(fileData[5]);
double lon = Double.parseDouble(fileData[6]);
int parish_id = Integer.parseInt(fileData[7]);
double distance = Double.parseDouble(fileData[8]);
int duration = Integer.parseInt(fileData[9]);
int trip_id = Integer.parseInt(fileData[10]);
double taxi_fare = Double.parseDouble(fileData[11]);
String query = " INSERT INTO aid_atidivyakumarpatra "
+ "(id, driver_id, date, in_service, trips_pos, lat, lon, point, parish_id, distance, duration, trip_id, taxi_fare)"
+ "VALUES ("+tripID+","+driver_id+",'"+timestamp+"',"+in_service+","+trips_pos+","
+ lat+","+lon+",ST_GeomFromText('POINT("+lon+" "+lat+")', 4326) , "+parish_id+","+distance+","+duration+", "
+ trip_id +","+taxi_fare +")";
对不起我的回答,但真正的问题是,为什么您不使用JPA处理数据库(Java Persistence API)?(实体经理,查询等...)
使用这种插入语句(串联),可能的SQL注入攻击很高(我同意Reimeus)