Android Open Source - foodroid Login S M S

From Project

Back to project page foodroid.

License

The source code is released under:

GNU General Public License

If you think the Android project foodroid listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor./*  w  w w.j a  va  2  s .c  om*/
 */
package smsserver;

import java.sql.*;

public class LoginSMS 
{
    public String get(String username, String password)
    {
        String result="";
        Connection connection = null;
        PreparedStatement lookupUser = null;

        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(Settings.DATABASE_URL,
                    Settings.DATABASE_USER, Settings.DATABASE_PASS);
            lookupUser = connection.prepareStatement(
            "SELECT username FROM user WHERE username = '" + username + "' and " + 
                    "password = '" + password + "'");

            ResultSet resultSet = lookupUser.executeQuery();
            if(resultSet.next())
                result="success";
            else
            {
                result= "fail";
            }
         }
        catch(SQLException e)
        {
           result= "error";
        }
        catch (ClassNotFoundException cE)
        {
            result= "error";
            System.out.println("Class Not Found Exception: "+ cE.toString());
        }
        catch(Exception e)
        {
            result= "error";
            e.printStackTrace();
        }
        finally
        {
            try{
                lookupUser.close();
                //registerUser.close();
                connection.close();
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }

        return result;
        
    }
}

Java Source Code List