package managers;
import beans.*;
import java.sql.*;
import java.util.*;

import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.hibernate.Session;

public class MemberManager{


public Member getById(String id) throws Exception
	{
		 Class.forName("org.gjt.mm.mysql.Driver");
         Connection dbConn = DriverManager.getConnection("jdbc:mysql://antares.nait.ca:3306/dracula","cst6492","cst6492");
         String sql = "Select * from member where memberId = ?";
         PreparedStatement dbStatement = dbConn.prepareStatement(sql);
         dbStatement.setString(1, id);
         ResultSet dbResultSet = dbStatement.executeQuery();
         Member bean = null;
         if(dbResultSet.next())
         {
        	 bean = new Member();
         }
         dbStatement.close();
         dbConn.close();
         return bean;
	}
	



	public void add (Member Bean ) throws Exception
	{
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();	
	
        	session.save(Bean);
              
        	session.getTransaction().commit();
	        HibernateUtil.getSessionFactory().close();
	
	}
	public ArrayList getMembers() throws Exception
	{
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();	

//      to retrieve all records from  table
    	ArrayList list = (ArrayList)session.createQuery("from Member").list();
          
    	session.getTransaction().commit();
        HibernateUtil.getSessionFactory().close();
        
        return list;
	}
}