package br.org.agilcoop.cursos.testes.bancoDeDados;

 import java.util.List;

 import java.util.Map;

 import org.springframework.jdbc.core.JdbcTemplate;

 public class UsuarioDAO {

         JdbcTemplate jdbc;

         public UsuarioDAO(JdbcTemplate jdbc) {

                 this.jdbc = jdbc;

         }

         public void insereUsuario(String nome, String senha) {

                 int id = jdbc.queryForInt("select max(id) from usuario");

                 id += 1;

                 Object[] args = new Object[] {id, nome, senha};

                 jdbc.update("insert into usuario (id, nome, senha) values (?, ?, ?)", args);

         }

         public void atualizaUsuario(Integer id, String nome, String senha) {

                 jdbc.update("update usuario set nome = ?, senha = ? where id = ?", new Object[] {nome, senha, id});

         }

         public void removeUsuario(String nome) {

                 jdbc.update("delete from usuario where nome = ?", new Object[]{nome});

         }

         @SuppressWarnings("unchecked")

         public List<Map<String, Object>> buscaPorNome(String nome) {

                 List<Map<String, Object>> map;

                 map = jdbc.queryForList("select * from usuario where nome like ?", new Object[]{nome.replaceAll("[*]", "%")});

                 return map;

         }

 }