package internetsignup;
import java.util.Date;
import java.sql.*;


public class ManagerLoginBean
{
	String managerName;
	String managerPassword;		
	
	static Connection con;
	static Statement state;
	static ResultSet result;
	public void setManagerName(String name)
	{
		managerName=name;
	}
	public String getManagerName()
	{
		return managerName;
	}
	public void setManagerPassword(String pass)
	{
		managerPassword=pass;
	}
	public String getManagerPassword()
	{
		return managerPassword;
	}
	
	public ManagerLoginBean()
	{		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" );        
        }
        catch(Exception e)
        {}
    }  
    
    public String checkLogin()
    {
    	try
    	{    		 
            con= DriverManager.getConnection("jdbc:odbc:College", "njgcxx", "njgcxx");
            state=con.createStatement();           
            result=state.executeQuery("select * from ManagerLogin where managerName='"+managerName+"' and managerPassword='"+managerPassword+"'");
            if(result.next()) return "success";
            else return "fail";
        }
        catch(Exception e)
        {
        	return "exception";
        }
        finally
        {
        	try{state.close();con.close();}catch(Exception e){}
        }       
    }
    
    public String getTodayDate()
    {
    	Date d=new Date();
		String signupDate=(1900+d.getYear())+"-"+(d.getMonth()+1)+"-"+d.getDate();
		return signupDate;
	}
    
    public String deleteAll()
    {
    	try
    	{    		 
            con= DriverManager.getConnection("jdbc:odbc:College", "njgcxx", "njgcxx");
            state=con.createStatement();           
            int rs=state.executeUpdate("delete from CollegeStudentInfo");
            if(rs>0) return "success";
            else return "fail";
        }
        catch(Exception e)
        {
        	return "exception";
        } 
        finally
        {
        	try{state.close();con.close();}catch(Exception e){}
        }            
    }
    
    public String changePassword()
    {
    	try
    	{    		 
            con= DriverManager.getConnection("jdbc:odbc:College", "njgcxx", "njgcxx");
            state=con.createStatement();           
            int rs=state.executeUpdate("update ManagerLogin set managerPassword='"+managerPassword+"' where managerName='"+managerName+"'");
            if(rs>0) return "success";
            else return "fail";
        }
        catch(Exception e)
        {
        	return "exception";
        }  
        finally
        {
        	try{state.close();con.close();}catch(Exception e){}
        }  
    	
    }
    	
}