出错了
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)
at jp.co.nec.ome.connection.database.OmPreparedQuery.executeUpdate(OmPreparedQuery.java:229)
at jp.co.kintetsu_is.batch.ps.psm.common.dao.PsTPsTaskaToriatsukaiDao.delete(PsTPsTaskaToriatsukaiDao.java:144)
at jp.co.kintetsu_is.batch.ps.psmc.PPSMC0100.init(PPSMC0100.java:555)
at jp.co.nec.ome.application.console.OmBreakBatchApplication.execute(OmBreakBatchApplication.java:103)
at jp.co.kintetsu_is.batch.ps.psmc.PPSMC0100.main(PPSMC0100.java:474)
Statement = [ DELETE FROM T_PS_TASKA_TORIATSUKAI T01 WHERE T01.HOKOKU_YMD = :HOKOKU_YMD AND T01.HOKOKU_YMD = DATEADD(DAY,1,:GYOMU_DATE)]
Parameters = [{HOKOKU_YMD=20130328, GYOMU_DATE=20130328}]
--------------------编程问答-------------------- 做数据删除时不能用别名,
DELETE FROM T_PS_TASKA_TORIATSUKAI WHERE HOKOKU_YMD = :HOKOKU_YMD AND HOKOKU_YMD = DATEADD(DAY,1,:GYOMU_DATE)
补充:Java , Java SE