/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package database;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.RequestScoped;

import java.sql.*;
import java.util.*;

@ManagedBean(name="DBConnection")
@RequestScoped
public class DBConnection {
    private String username;
    private String password;
    private String dbusername;

    public String getDbpassword() {
        return dbpassword;
    }
    public String getDbusername() {
        return dbusername;
    }

    private String dbpassword;
    Connection con;
    Statement ps;
    ResultSet rs;
    String SQL_Str;

    public void dbData(String UName)
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/footballdb","root","");
            ps = con.createStatement();
            SQL_Str="Select * from users where user_name like ('" + UName +"')";
            rs=ps.executeQuery(SQL_Str);
            rs.next();
            dbusername=rs.getString(2).toString();
            dbpassword=rs.getString(4).toString();
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
            System.out.println("Exception Occur :" + ex);
        }
    }
    public String getPassword() {
        return password;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }
    public String checkValidUser()
    {
        dbData(username);

        if(username.equalsIgnoreCase(dbusername))
        {

            if(password.equals(dbpassword))
                return "home.xhtml";
            else
            {
                return "invalid";
            }
        }
        else
        {
            return "invalid";
        }
    }

    public List<Team> displayTeams(Connection con, Statement ps, ResultSet rs, String SQL_Str) {
        List<Team> teams = new ArrayList<Team>();
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/footballdb","root","");
            ps = con.createStatement();
            SQL_Str="Select * from team";
            rs = ps.executeQuery(SQL_Str);
            Team t;
            while(rs.next()) {
                t = new Team();
                t.setId(rs.getInt("teamId"));
                t.setTeamname(rs.getString("teamName"));
                t.setYearFounded(rs.getInt("yearFounded"));
                t.setTeamCrest(rs.getString("teamCrest"));
                t.setLeaguename(rs.getString("leagueName"));
                t.setLeagueId(rs.getInt("leagueId"));
                teams.add(t);
                System.out.println(t);
            }
            System.out.println(teams+"nTeams");
            return teams;
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
            System.out.println("Exception Occur :" + ex);
            return null;
        }
    }

    private Team team = new Team();
    List<Team> teams = new ArrayList<Team>();

    public List<Team> getTeams() {
        teams = displayTeams(con, ps, rs, SQL_Str);
        return teams;
    }

    public void setTeams(List<Team> teams) {
        this.teams = teams;
    }

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package database;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.RequestScoped;

import java.sql.*;
import java.util.*;

@ManagedBean(name="DBConnection")
@RequestScoped
public class DBConnection {
    private String username;
    private String password;
    private String dbusername;

    public String getDbpassword() {
        return dbpassword;
    }
    public String getDbusername() {
        return dbusername;
    }

    private String dbpassword;
    Connection con;
    Statement ps;
    ResultSet rs;
    String SQL_Str;

    public void dbData(String UName)
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/footballdb","root","");
            ps = con.createStatement();
            SQL_Str="Select * from users where user_name like ('" + UName +"')";
            rs=ps.executeQuery(SQL_Str);
            rs.next();
            dbusername=rs.getString(2).toString();
            dbpassword=rs.getString(4).toString();
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
            System.out.println("Exception Occur :" + ex);
        }
    }
    public String getPassword() {
        return password;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }
    public String checkValidUser()
    {
        dbData(username);

        if(username.equalsIgnoreCase(dbusername))
        {

            if(password.equals(dbpassword))
                return "home.xhtml";
            else
            {
                return "invalid";
            }
        }
        else
        {
            return "invalid";
        }
    }

    public List<Team> displayTeams(Connection con, Statement ps, ResultSet rs, String SQL_Str) {
        List<Team> teams = new ArrayList<Team>();
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/footballdb","root","");
            ps = con.createStatement();
            SQL_Str="Select * from team";
            rs = ps.executeQuery(SQL_Str);
            Team t;
            while(rs.next()) {
                t = new Team();
                t.setId(rs.getInt("teamId"));
                t.setTeamname(rs.getString("teamName"));
                t.setYearFounded(rs.getInt("yearFounded"));
                t.setTeamCrest(rs.getString("teamCrest"));
                t.setLeaguename(rs.getString("leagueName"));
                t.setLeagueId(rs.getInt("leagueId"));
                teams.add(t);
                System.out.println(t);
            }
            System.out.println(teams+"nTeams");
            return teams;
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
            System.out.println("Exception Occur :" + ex);
            return null;
        }
    }

    private Team team = new Team();
    List<Team> teams = new ArrayList<Team>();

    public List<Team> getTeams() {
        teams = displayTeams(con, ps, rs, SQL_Str);
        return teams;
    }

    public void setTeams(List<Team> teams) {
        this.teams = teams;
    }


}