waterElectricityService/ConfigDaoImpl.java

package com.happy.dao.impl;

import com.happy.Model.Config;
import com.happy.Model.Consume;
import com.happy.dao.ConfigDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository("ConfigDao")
public class ConfigDaoImpl implements ConfigDao {

    @Autowired
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate() {
        return namedParameterJdbcTemplate;
    }

    public void setNamedParameterJdbcTemplate(
            NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
        this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
    }

    public List<Config> query(String name){
        String sql="select * from config where name=:name";
        MapSqlParameterSource sps = new MapSqlParameterSource();
        sps.addValue("name", name);
        List<Config> list=namedParameterJdbcTemplate.query(sql, sps,new BeanPropertyRowMapper<Config>(Config.class));
        if(list != null && list.size() >0){
            return list;
        }
        return null;
    }
}