DBConnectionService dbService = new DBConnectionService();
DBContext dbContext = new DBContext("10.62.100.2", "TOMC", "system", "oracle", "1521");
Connection conn = dbService.getConnection(dbContext);
String sql = "insert into CSPPM.PM_COLLECT_VALUE_TABLE(collecttime,groupid,indexid,product,value) values(to_date(?,'yyyy-MM-dd HH24:mi:ss'),?,?,?,?)";
System.out.println(sql);
PreparedStatement prepstmt = conn.prepareStatement(sql);
String date ="2015-02-03 12:23:05";
prepstmt.setString(1, date);
String groupId = "6666";
prepstmt.setString(2, groupId);
String indexId = "6666";
prepstmt.setString(3, indexId);
String product = "6666";
prepstmt.setString(4, product);
int value =36;
prepstmt.setLong(5, value);
prepstmt.executeUpdate(sql);
prepstmt.close();
conn.close();
-------------------------报错:
insert into CSPPM.PM_COLLECT_VALUE_TABLE(collecttime,groupid,indexid,product,value) values(to_date(?,'yyyy-MM-dd HH24:mi:ss'),?,?,?,?)
java.sql.SQLException: ORA-01008: 并非所有变量都已绑定
--------------------------处理:
prepstmt.executeUpdate(sql); ---->prepstmt.executeUpdate( ); 去掉括号中sql就行了,已经被覆盖了