这是查询方法：
//通过出发地、目的地、发车日期 查询车次
public List queryAll(String toAddress,String fromAddress,Date startDate){
String sql ="select * from tts_traininfo where toAddress like ? and fromAddress like ? and startDate like TO_DATE(?,'yyyy-mm-dd hh24:mi:ss')";
List list = new ArrayList();
Connection conn = DBConnection.getConnection();
try {
PreparedStatement pstm = conn.prepareStatement(sql);
pstm.setString(1, "%" + toAddress + "%");
pstm.setString(2, "%" + fromAddress + "%");
pstm.setString(3, "%" + startDate + "%");
ResultSet rs = pstm.executeQuery();
if (rs.next()) {
Train train = new Train(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getDate(5),
rs.getDate(6), rs.getDouble(7));
list.add(train);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
这是测试方法：
@Test
public void queryAll() {
Scanner sc = new Scanner(System.in);
System.out.println("请输入出发地：");
String toAddress = sc.nextLine();
System.out.println("请输入目的地：");
String fromAddress = sc.nextLine();
System.out.println("请输入发车日期：");
String sDate = sc.nextLine();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
Date date;
try {
date = sdf.parse(sDate);
Date startDate = new java.sql.Date(date.getTime());
System.out.println(startDate);
List list = tot.queryAll(toAddress, fromAddress, startDate);
System.out.println(list);
list.forEach((item) -> {
System.out.println(
item.getId() + "," + item.getTrainId() + "," + item.getToAddress() + "," + item.getFromAddress()
+ "," + item.getStartDate() + "," + item.getStartTime() + "," + item.getFares());
});
} catch (ParseException e) {
e.printStackTrace();
}
}
输入目的地、出发地、还有时间后 报错
请输入出发地：
北京
请输入目的地：
上海
请输入发车日期：
2018-06-08
2018-01-08
java.sql.SQLDataException: ORA-01841: (完整) 年份值必须介于 -4713 和 +9999 之间, 且不为 0
求大神解决！！！ 急急急急！！！ |
天盟APP下载
