Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <mvc:interceptors>
- bean class="br.com.softwarescomerciais.os.interceptor.AutorizadorInterceptor"></bean>
- /mvc:interceptors>
- mvc:default-servlet-handler/>
- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- property name="driverClassName" value="com.mysql.jdbc.Driver"/>
- property name="url" value="jdbc:mysql://192.168.101.178/sc"/>
- property name="username" value="sfilho"/>
- property name="password" value="123"/>
- /bean>
- @Autowired
- private DataSource dataSource;
- public boolean existe(Usuario usuario) {
- if (usuario == null) {
- throw new IllegalArgumentException("Usuário não deve ser nulo");
- }
- String sql = "select NOME from USUARIOS where NOME = :NOME and SENHA = :SENHA";
- NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
- Map<String, Object> parametros = new HashMap<String, Object>();
- parametros.put("NOME", usuario.getNome());
- parametros.put("SENHA", usuario.getSenha());
- SqlRowSet srs = jdbcTemplate.queryForRowSet(sql, parametros);
- boolean existe = srs.next();
- return existe;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement