jdbcTemplate使用

dataSource

<bean name="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
   destroy-method="close">
   <property name="driverClassName" value="${driverClassName}" />
   <property name="url" value="${url}" />
   <property name="username" value="${username}" />
   <property name="password" value="${password}" />
   <property name="initialSize" value="10" />
   <property name="maxActive" value="150"/>  
   <property name="maxIdle" value="50"/>   
</bean>

jdbcTemplate

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
   <property name="dataSource">
      <ref bean="dataSource"/>
   </property>
</bean>

代码中使用

public class LocationDao {
    @Resource
    private JdbcTemplate jdbcTemplate;

    public void add(LocationModel model) {
        // TODO Auto-generated method stub
        StringBuilder sql = new StringBuilder();

        sql.append("insert into t_location");
        sql.append("(longitude, latitude, "
                + "createBy, createTime)");
        sql.append("values");
        sql.append("(?,?,?,?)");

        Object[] args = new Object[] {
                model.getLongitude(), model.getLatitude(),
                model.getCreateBy(), model.getCreateTime()
        };

        jdbcTemplate.update(sql.toString(), args);
    }

    public List<LocationModel> getByCreateBy(String createBy) {
        StringBuilder sql = new StringBuilder();
        sql.append("select id, longitude, latitude, "
                + "createBy, createTime");
        sql.append(" from t_location");
        sql.append(" where createBy = ?");
        sql.append(" order by createTime desc");
//      sql.append(" limit 10");

//      return jdbcTemplate.query(sql.toString(), LocationModel.class, createBy);
        return jdbcTemplate.query(sql.toString(), new LocationModel(), createBy);
    }

}

LocationModel

import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;

public class LocationModel implements RowMapper<LocationModel>, Serializable {

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    private int id;
    private String longitude; 
    private String latitude;
    private String createTime;
    private String createBy;


    /**
     * @return the id
     */
    public int getId() {
        return id;
    }


    /**
     * @param id the id to set
     */
    public void setId(int id) {
        this.id = id;
    }


    /**
     * @return the longitude
     */
    public String getLongitude() {
        return longitude;
    }


    /**
     * @param longitude the longitude to set
     */
    public void setLongitude(String longitude) {
        this.longitude = longitude;
    }


    /**
     * @return the latitude
     */
    public String getLatitude() {
        return latitude;
    }


    /**
     * @param latitude the latitude to set
     */
    public void setLatitude(String latitude) {
        this.latitude = latitude;
    }


    /**
     * @return the createTime
     */
    public String getCreateTime() {
        return createTime;
    }


    /**
     * @param createTime the createTime to set
     */
    public void setCreateTime(String createTime) {
        this.createTime = createTime;
    }


    /**
     * @return the createBy
     */
    public String getCreateBy() {
        return createBy;
    }


    /**
     * @param createBy the createBy to set
     */
    public void setCreateBy(String createBy) {
        this.createBy = createBy;
    }


    /**
     * @return the serialversionuid
     */
    public static long getSerialversionuid() {
        return serialVersionUID;
    }


    /* (non-Javadoc)
     * @see org.springframework.jdbc.core.RowMapper#mapRow(java.sql.ResultSet, int)
     */
    public LocationModel mapRow(ResultSet arg0, int arg1) throws SQLException {
        // TODO Auto-generated method stub
        LocationModel model = new LocationModel();
        model.id = arg0.getInt("id");
        model.longitude = arg0.getString("longitude");
        model.latitude = arg0.getString("latitude");
        model.createBy = arg0.getString("createBy");
        model.createTime = arg0.getString("createTime");
        return model;
    }
}