不是,不过下面那句有个错误,应该是 String value = rs2.getString("Value");不过就是改了 还是报一样的错误请大家帮帮忙吧
select TimeInsert, Value from HISTORY_INFO where DateInsert = " +dp.stringToDate(date)+ " and Logical_Address='S7' and TimeInsert between '" +dp.stringToTime(timeto) + "' and '" +dp.stringToTime(timefrom)+"'";你把这句生成一个字符串打印出来,,在sql server里执行看看能不能通过。
String value = rs2.getString("Value");不过就是改了 还是报一样的错误请大家帮帮忙吧
" and Logical_Address='S7' and TimeInsert between '" +dp.stringToTime(timeto) +
"' and '" +dp.stringToTime(timefrom)+"'";你把这句生成一个字符串打印出来,,在sql server里执行看看能不能通过。