package com.androidlogin.ws;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class LoginWS {
public String authentication(String userName,String password){

String retrievedUserName = "";
String retrievedPassword = "";
String status = "";
try{

Class.forName("com.mysql.jdbc.driver");
Connection con = DriverManager.getConnection("jdbc:mysql://10.0.2.2:3306/android_user","root","");
PreparedStatement statement = con.prepareStatement("SELECT * FROM user WHERE nama_user = '"+userName+"'");
ResultSet result = statement.executeQuery();

while(result.next()){
retrievedUserName = result.getString("username");
retrievedPassword = result.getString("password");
}

if(retrievedUserName.equals(userName)&&retrievedPassword.equals(password)){
status = "Success!";
}

else{
status = "Login fail!!!";
}

}
catch(Exception e){
e.printStackTrace();
}
return status;

}

}