ar.com.springbasic.dao.AdminDaoImpl.java Source code

Introduction

Here is the source code for ar.com.springbasic.dao.AdminDaoImpl.java

Source

/*
 * 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 ar.com.springbasic.dao;

import ar.com.springbasic.beans.Admin;
import ar.com.springbasic.beans.AdminRowMapper;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.jdbc.core.namedparam.SqlParameterSourceUtils;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author cassisi
 */
@Component("adminDao")
public class AdminDaoImpl implements AdminDao {

    //Plantilla que acepta comodines
    private NamedParameterJdbcTemplate jdbcTemplate;

    @Autowired
    private void setDataSource(DataSource dataSource) {
        this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    }

    @Override
    public boolean save(Admin admin) {
        //        MapSqlParameterSource paramMap = new MapSqlParameterSource();
        //        paramMap.addValue("nombre", admin.getNombre());
        //        paramMap.addValue("cargo", admin.getCargo());
        //        paramMap.addValue("fechaCreacion", admin.getFechaCreacion());

        BeanPropertySqlParameterSource paramMap = new BeanPropertySqlParameterSource(admin);

        return jdbcTemplate.update(
                "insert into springbd.admin (nombre, cargo, fechaCreacion) values (:nombre, :cargo, :fechaCreacion) ",
                paramMap) == 1;
    }

    @Override
    public List<Admin> findAll() {
        return jdbcTemplate.query("select * from admin", new AdminRowMapper() {
        });
    }

    @Override
    public Admin findById(int id) {
        return jdbcTemplate.queryForObject("Select * from admin where idAd=:idAd",
                new MapSqlParameterSource("idAd", id), new AdminRowMapper());
    }

    @Override
    public List<Admin> findByNombre(String nombre) {
        return jdbcTemplate.query("Select * from admin where nombre like :nombre",
                new MapSqlParameterSource("nombre", "%" + nombre + "%"), new AdminRowMapper());
    }

    @Override
    public boolean update(Admin admin) {
        return jdbcTemplate.update(
                "update springbd.admin set nombre=:nombre, cargo=:cargo, fechaCreacion=:fechaCreacion where idAd=:idAd",
                new BeanPropertySqlParameterSource(admin)) == 1;
    }

    @Override
    public boolean delete(int idAd) {
        return jdbcTemplate.update("delete from springbd.admin where idAd=:idAd",
                new MapSqlParameterSource("idAd", idAd)) == 1;
    }

    @Transactional
    @Override
    public int[] saveAll(List<Admin> admins) {
        SqlParameterSource[] batchArgs = SqlParameterSourceUtils.createBatch(admins.toArray());
        return jdbcTemplate.batchUpdate(
                "insert into springbd.admin (nombre, cargo, fechaCreacion) values (:nombre, :cargo, :fechaCreacion)",
                batchArgs);
    }

}