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.如果还是不行,建议直接用加号将赋值的数据直接串联上,而不是使用占位符