struts2+spring留言板

package org.snow.dao; import java.rmi.server.UID; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import java.util.List; import javax.sql.DataSource; import org.snow.model.LeaveWord; import org.springframework.jdbc.core.SqlParameter; import org.springframework.jdbc.object.MappingSqlQuery; import org.springframework.jdbc.object.SqlUpdate; public class LeaveDAOImpl implements LeaveDAO { private DataSource dataSource; @SuppressWarnings("unchecked") @Override public List<LeaveWord> getAllTopics() { MappingSqlQuery query = new MappingSqlQuery() { @Override protected Object mapRow(ResultSet rs, int rowno) throws SQLException { LeaveWord leaveWord = new LeaveWord(); leaveWord.setTopic(rs.getString("topic")); leaveWord.setLeaveId(rs.getString("leaveId")); leaveWord.setLeaveName(rs.getString("leaveName")); leaveWord.setLeaveTime(rs.getDate("leaveTime")); return leaveWord; } }; query.setDataSource(dataSource); query.setSql("select * from tb_leave order by leaveTime desc"); return query.execute(); } public void setDataSource(DataSource dataSource) { this.dataSource = dataSource; } @Override public void addLeaveWord(LeaveWord leaveWord) { SqlUpdate update = new SqlUpdate(); update.setDataSource(dataSource); update.setSql("insert into tb_leave (leaveId,topic,leaveContent,leaveTime,leaveName) values(?,?,?,sysdate,?)"); update.declareParameter(new SqlParameter(Types.VARCHAR)); update.declareParameter(new SqlParameter(Types.VARCHAR)); update.declareParameter(new SqlParameter(Types.VARCHAR)); // update.declareParameter(new SqlParameter(Types.DATE)); update.declareParameter(new SqlParameter(Types.VARCHAR)); update.update(new Object[]{new UID().toString(),leaveWord.getTopic(),leaveWord.getLeaveContent(),leaveWord.getLeaveName()}); } @SuppressWarnings("unchecked") @Override public List<LeaveWord> getLeaveDetail(String leaveId) { MappingSqlQuery query = new MappingSqlQuery() { protected Object mapRow(ResultSet rs, int rowno) throws SQLException { LeaveWord leaveWord = new LeaveWord(); leaveWord.setTopic(rs.getString("topic")); leaveWord.setLeaveId(rs.getString("leaveId")); leaveWord.setLeaveContent(rs.getString("leaveContent")); leaveWord.setLeaveName(rs.getString("leaveName")); leaveWord.setLeaveTime(rs.getDate("leaveTime")); return leaveWord; } }; query.setDataSource(dataSource); query.setSql("select * from tb_leave where leaveID = ?"); query.declareParameter(new SqlParameter(Types.VARCHAR)); return query.execute(new Object[]{leaveId}); } }