Advertisement
Guest User

Untitled

a guest
Jul 31st, 2015
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. @Component(value = "userService")
  2. public class UserService implements AuthenticationProvider {
  3. @Inject
  4. @Named(value = "dataSource")
  5. private DataSource dataSource1;
  6. String name;
  7. String password;
  8. int countRow=0;
  9. public Authentication authenticate(Authentication auth) throws AuthenticationException {
  10. ResultSet resultSet = null;
  11. PreparedStatement preparedStatement = null;
  12. Connection connection = null;
  13. name= auth.getName();
  14. password=auth.getCredentials().toString();
  15. final String select= "select username,password from users where username='"+name+"'and password='"+password+"'";
  16.  
  17. try {
  18. connection = dataSource1.getConnection();
  19. preparedStatement = connection.prepareStatement(select);
  20. resultSet = preparedStatement.executeQuery();
  21. if(resultSet.next()){
  22. countRow++;
  23. if(countRow!=0){
  24.  
  25. return new UsernamePasswordAuthenticationToken(name, null);}
  26. }
  27. return null;
  28. }
  29.  
  30.  
  31.  
  32. return new UsernamePasswordAuthenticationToken("", "");
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement