com.microsoft.sqlserver.jdbc.SQLServerException: 必须声明标量变量 "@P8sImage_big2"。
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:461)
at com.yubso.lanling_mycompany.dao.impl.ShopDaoImpl.updataShop(ShopDaoImpl.java:140)
at test.Test.updatePss(Test.java:41)
解决办法:原update shop set sImage_big1=?sImage_big2=?,sOldPrice=? where id= ?
是sql语句少一个“,”update shop set sImage_big1=?,sImage_big2=?,sOldPrice=? where id= ?