Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package uta.ak.usttmp.common.dao.mapper; import java.sql.ResultSet; import java.sql.SQLException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.logging.Level; import java.util.logging.Logger; import org.springframework.jdbc.core.RowMapper; import uta.ak.usttmp.common.model.RawText; import uta.ak.usttmp.common.model.Text; /** * * @author zhangcong */ public class TextRowMapper implements RowMapper { @Override public Object mapRow(ResultSet rs, int rowNum) throws SQLException { try { Text rt = new Text(); rt.setId(rs.getLong("mme_eid")); SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); rt.setCreateTime(formatter.parse(rs.getString("text_createdate"))); rt.setText(rs.getString("text")); rt.setTitle(rs.getString("title")); rt.setRawTextId(rs.getLong("rawtext_id")); rt.setTag(rs.getString("tag")); return rt; } catch (ParseException ex) { Logger.getLogger(RawTextRowMapper.class.getName()).log(Level.SEVERE, null, ex); } return null; } }