java sql ora-01747,java.sql.SQLSyntaxErrorException: ORA-01747: user.table.column, table.column 或列说明...

java.sql.SQLSyntaxErrorException: ORA-01747: user.table.column, table.column 或列说明无效

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:221)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:137)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:468)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:418)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1089)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1250)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1516)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3889)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4033)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:4008)

at com.daoimpl.WaterSoilConservationDaoImpl.updateWaterSoilConservation(WaterSoilConservationDaoImpl.java:167)

at com.daoimpl.WaterSoilConservationDaoImpl.main(WaterSoilConservationDaoImpl.java:197)

修改失败

其中原来的sql是:

String updatesql = "update WaterSoilConservation set wsc_name = ? " +

",set wsc_checktime = ? ,wsc_checkcontext = ?,wsc_checkmethod = ?" +

" ,wsc_mainresult = ? ,wsc_sendconpany = ?,wsc_docompany =      ?,wsc_watchcompany = ? where wsc_id = ?";

我的问题在于:是因为有两个set在sql里面,一般而言有占位符的,使用输出语句的时候,占位符还是原样输出的.

备注:

1.上面的问题也可能是因为使用了oracle的关键字导致

2.如果还是不行,建议直接用加号将赋值的数据直接串联上,而不是使用占位符