package com.ilp.tsi.um.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.ilp.tsi.um.constant.BankConstant;
public class BankDao {
    public static Connection createconnection() {
        Connection conn = null;
        try 
        {
            Class.forName(BankConstant.DRIVER).newInstance();
            conn = DriverManager.getConnection(BankConstant.DBURL,BankConstant.DBUSER, BankConstant.DBPASS);

        } 
        catch (ClassNotFoundException ce) 
        {
            ce.printStackTrace();
        } 
        catch (SQLException e) 
        {
            e.printStackTrace();
        } 
        catch (InstantiationException e)
        {
            e.printStackTrace();
        } 
        catch (IllegalAccessException e) 
        {
            e.printStackTrace();
        }
        return conn;
    }

}

//bean:

package com.ilp.tsi.um.bean;

public class BankBean {

private String userName;
private String password;

public String getUsername(){
    return userName;

}
public void setUsername(String username){
    userName=username;
}
public String getPassword(){
    return password;

}
public void setPassword(String password){
    this.password=password;
}
}

//service:

package com.ilp.tsi.um.service;


    import java.sql.Connection;

    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;

    import com.ilp.tsi.um.bean.BankBean;

    public class BankService {
         //To Perform login authentication of Administrator
        public boolean authenticate(BankBean loginBean, Connection connection)
                throws SQLException {

            try {
                String Username = loginBean.getUsername();
                String Password = loginBean.getPassword();

                Statement statement = connection.createStatement();
                // Executing required select query using Statement
                ResultSet rs = statement.executeQuery("select * from adminlogin  where username='"+Username+"' and  password='"+Password+"'");
                // Iterating resultset for the data from table
                if (rs.next()) {
                    return true;
                    // end if 
                } else {
                    return false;
                } // end else

            } catch (SQLException sqle) {
                sqle.printStackTrace();
                connection.close();

            } // end catch 
            catch (Exception e) {
                e.printStackTrace();
                connection.close();
            }// end catch 
            finally
            {
            connection.close();}
            return false;
        }// end finally


    }