

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class DataBaseOperation extends HttpServlet {
	private static final long serialVersionUID = 1L;
    public DataBaseOperation() {
        super();

    }

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

		try
		{
			String querystring="INSERT INTO MEMINFO VALUES(?,?,?,?,?,?,?,?,?,?,?,?)";
			Connection con=ConnectionFactory.getInstance().getConnection();
			PreparedStatement ptmt=con.prepareStatement(querystring);
			
			
			
				ptmt.setString(1, String.valueOf(System.currentTimeMillis()));
				ptmt.setString(2, memberBean.getMemFName());
				ptmt.setString(3, memberBean.getMemLName());
				ptmt.setString(4, memberBean.getMemEmail());
				ptmt.setString(5, memberBean.getMemPassword());
				ptmt.setString(6, memberBean.getMemAddr());
				ptmt.setString(7, memberBean.getMemCity());
				ptmt.setString(8, memberBean.getMemPhone());
				ptmt.setString(9, memberBean.getMemPincode());
				ptmt.setString(10, memberBean.getMemCountry());
			
			
			ptmt.executeUpdate();

		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(rs!=null)
					rs.close();
				if(ptmt!=null)
					ptmt.close();
				if(con!=null)
					con.close();
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}

		}

	}
	public void update(MemberBean memberBean)
	{

		try
		{
			String querystring="UPDATE MEM SET MEM_ID=?,MEM_FNAME=?,MEM_LNAME=?,MEM_EMAIL=?, MEM_PASS=?, MEM_ADDR=?," +
			"Mem_PHONE=?, WHERE Mem_ID=?";
			con=ConnectionFactory.getInstance().getConnection();
			ptmt=con.prepareStatement(querystring);
				ptmt.setString(1,memberBean.getMemId());
				ptmt.setString(2, memberBean.getMemFName());
				ptmt.setString(3, memberBean.getMemLName());
				ptmt.setString(4, memberBean.getMemPassword());
				ptmt.setString(5, memberBean.getMemAddr());
				ptmt.setString(6, memberBean.getMemCity());
				ptmt.setString(7, memberBean.getMemCountry());
				ptmt.setString(8, memberBean.getMemEmail());
				ptmt.setString(9, memberBean.getMemPhone());
				ptmt.setString(10, memberBean.getMemId());
			
			ptmt.executeUpdate();

		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(rs!=null)
					rs.close();
				if(ptmt!=null)
					ptmt.close();
				if(con!=null)
					con.close();
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}

		}

	}

	public void delete(String employeeId)
	{

		try
		{
			String querystring="DELETE FROM EMP WHERE Mem_ID=?";
			con=ConnectionFactory.getInstance().getConnection();
			ptmt=con.prepareStatement(querystring);
			ptmt.setString(1, employeeId);
			ptmt.executeUpdate();

		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(rs!=null)
					rs.close();
				if(ptmt!=null)
					ptmt.close();
				if(con!=null)
					con.close();
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}

		}

	}

	public List Info()
	{
		List member=new ArrayList();
		MemberBean memberBean=null;

	}
	
	public MemberBean findByPrimaryKey(String empId)
	{

		MemberBean memberBean=null;
		try
		{
			String querystring="SELECT * FROM MEM WHERE MEM_ID=?";
			con=ConnectionFactory.getInstance().getConnection();
			ptmt=con.prepareStatement(querystring);
			ptmt.setString(1, empId);
			rs=ptmt.executeQuery();
			if(rs.next())
			{
				memberBean=new MemberBean();
				memberBean.setMemId(rs.getString(1));
				memberBean.setMemFName(rs.getString(2));
				memberBean.setMemLName(rs.getString(3));
				memberBean.setMemEmail(rs.getString(4));
				memberBean.setMemPassword(rs.getString(5));
				memberBean.setMemAddr(rs.getString(6));
				memberBean.setMemCity(rs.getString(7));
				memberBean.setMemPhone(rs.getString(8));
				memberBean.setMemPincode(rs.getString(9));
				memberBean.setMemCountry(rs.getString(10));
				
				

				doGet(response,request);
			}

}
