Advertisement
Guest User

Untitled

a guest
Jan 7th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. <mvc:interceptors>
  2. bean class="br.com.softwarescomerciais.os.interceptor.AutorizadorInterceptor"></bean>
  3. /mvc:interceptors>
  4. mvc:default-servlet-handler/>
  5.  
  6. <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  7. property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  8. property name="url" value="jdbc:mysql://192.168.101.178/sc"/>
  9. property name="username" value="sfilho"/>
  10. property name="password" value="123"/>
  11. /bean>
  12.  
  13. @Autowired
  14. private DataSource dataSource;
  15.  
  16. public boolean existe(Usuario usuario) {
  17. if (usuario == null) {
  18. throw new IllegalArgumentException("Usuário não deve ser nulo");
  19. }
  20.  
  21. String sql = "select NOME from USUARIOS where NOME = :NOME and SENHA = :SENHA";
  22.  
  23. NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
  24. Map<String, Object> parametros = new HashMap<String, Object>();
  25. parametros.put("NOME", usuario.getNome());
  26. parametros.put("SENHA", usuario.getSenha());
  27.  
  28. SqlRowSet srs = jdbcTemplate.queryForRowSet(sql, parametros);
  29.  
  30. boolean existe = srs.next();
  31. return existe;
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement