首先,javaBean为:
- <span style="color:#ff0000;"></span><p><span style="color:#ff0000;">import java.util.Date;</span></p><p>
- public class OutcomeVo {
- private int oid;
- private int uid;
- private String ocName;
- private String ocType;
- private Date gotOCDate;
- <span style="color:#ffffff;">private Date commitTime;
- </span> private String fileUrl;
-
- public String getFileUrl() {
- return fileUrl;
- }
- public void setFileUrl(String fileUrl) {
- this.fileUrl = fileUrl;
- }
- public String getOcName() {
- return ocName;
- }
- public void setOcName(String ocName) {
- this.ocName = ocName;
- }
- public int getOid() {
- return oid;
- }
- public void setOid(int oid) {
- this.oid = oid;
- }
- public int getUid() {
- return uid;
- }
- public void setUid(int uid) {
- this.uid = uid;
- }
- public String getOcType() {
- return ocType;
- }
- public void setOcType(String ocType) {
- this.ocType = ocType;
- }
- public Date getGotOCDate() {
- return gotOCDate;
- }
- public void setGotOCDate(Date gotOCDate) {
- this.gotOCDate = gotOCDate;
- }
- public Date getCommitTime() {
- return commitTime;
- }
- public void setCommitTime(Date commitTime) {
- this.commitTime = commitTime;
- }
- }
- </p>
其次,在后台从数据库中获取的时候是:
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
-
- import org.springframework.jdbc.core.RowMapper;
- import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
- import org.springframework.jdbc.core.namedparam.SqlParameterSource;
- import org.springframework.jdbc.support.GeneratedKeyHolder;
- import org.springframework.jdbc.support.KeyHolder;
- import org.springframework.stereotype.Repository;
-
- import cn.cnic.outcome.front.vo.OutcomeVo;
- import cn.cnic.outcome.util.BaseDAO;
-
- @Repository
- @SuppressWarnings("unchecked")
- public class OutcomeDao extends BaseDAO{
- private static final String TABLE = " outcome ";
- private static final String FIELDS = " uid,ocType,ocName,fileUrl,gotOCDate,commitTime ";
- private static final String SAVED_VALUES = " :uid,:ocType,:ocName,:fileUrl,:gotOCDate,:commitTime ";
- private static final String UPDATED_VALUES = " uid=:uid,ocType=:ocType,ocName=:ocName,fileUrl=:fileUrl,gotOCDate=:gotOCDate ";
-
- @SuppressWarnings("unchecked")
- public List<OutcomeVo> findByProperty(String propertyName, Object value) {
- String sql = "select distinct * from " + TABLE + " where "
- + propertyName + "=:" + propertyName;
- Map paramMap = new HashMap();
- paramMap.put(propertyName, value);
- return (List<OutcomeVo>) getNamedParameterJdbcTemplate().query(sql,
- paramMap, rowMapper);
- }
-
- @SuppressWarnings("unchecked")
- public List<OutcomeVo> findAll() {
- String sql = "select * from " + TABLE + " order by oid";
- Map paramMap = new HashMap();
- return (List<OutcomeVo>) getNamedParameterJdbcTemplate().query(sql,
- paramMap, rowMapper);
- }
-
- public int save(OutcomeVo outcomeVo) {
- String sql = "insert into " + TABLE + " ( " + FIELDS + " ) values ( "
- + SAVED_VALUES + " )";
- KeyHolder keyHolder = new GeneratedKeyHolder();
- SqlParameterSource ps = new BeanPropertySqlParameterSource(outcomeVo);
- getNamedParameterJdbcTemplate().update(sql, ps, keyHolder);
- return keyHolder.getKey().intValue();
- }
-
- public int update(OutcomeVo outcomeVo) {
- String sql = "update " + TABLE + " set " + UPDATED_VALUES
- + " where oid=:oid";
- SqlParameterSource ps = new BeanPropertySqlParameterSource(outcomeVo);
- return getNamedParameterJdbcTemplate().update(sql, ps);
- }
-
- @SuppressWarnings("unchecked")
- private RowMapper rowMapper = new RowMapper() {
- public Object mapRow(ResultSet rs, int arg1) throws SQLException {
- OutcomeVo outcomeVo = new OutcomeVo();
- <span style="color:#ff0000;">outcomeVo.setCommitTime(rs.getTimestamp("commitTime"));
- </span> outcomeVo.setGotOCDate(rs.getDate("gotOCDate"));
- outcomeVo.setOcType(rs.getString("ocType"));
- outcomeVo.setOcName(rs.getString("ocName"));
- outcomeVo.setFileUrl(rs.getString("fileUrl"));
- outcomeVo.setOid(rs.getInt("oid"));
- outcomeVo.setUid(rs.getInt("uid"));
- return outcomeVo;
- }
- };
- }
最后,在页面上显示的时候是这样的:
- <fmt:formatDate value="${outcome.commitTime}" <span style="color:#ff0000;">pattern="yyyy-MM-dd HH:mm:ss"</span> />
以上仅为关键代码,只需看红色字体部分即可知晓,如何操作
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。