@Override
public void packParams(PreparedStatement stmt) throws SQLException {
stmt.setString(1, taskId);
}
});
return jdbcCallbackTemplate.excute(getSql("task.delete.bytaskid"));
}
}
sql我也用MessageProperties来读取了,定义在一个单独的properties文件里,
Sql代码
task.search.bytaskid = select TASK_ID,TASK_NAME,TASK_DESC from TB_TASKS where TASK_ID =
task.insert = insert into TB_TASKS (TASK_ID,TASK_NAME,TASK_DESC) values ( , , )
task.delete.bytaskid = Delete from TB_TASKS where TASK_ID =