package project.controller;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import project.bean.*;
import project.model.*;

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

                System.out.println("hi");
		ProjectBean bean=new ProjectBean();
		if(request.getParameter("action").equals("create"))
		{
		bean.setStudentname(request.getParameter("studentname"));
		System.out.println(request.getParameter("studentname"));
		bean.setDate(request.getParameter("date"));
		bean.setMark(Integer.parseInt(request.getParameter("mark")));
		//System.out.println(+bean.getMark());
		ProjectModel model=new ProjectModel();
		try {
			bean=model.daoCallingMethod(bean);
			System.out.println("rohini");
			request.setAttribute("message","Account created successfully");
			RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/UI_page.jsp");
			redirect.forward(request, response);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		}
		else if(request.getParameter("action").equals("read"))
		{
			System.out.println("hello");
			String studentname=request.getParameter("studentname");
			System.out.println(studentname);
			ReadModel read=new ReadModel();
			try {
			 //request.setAttribute(studentname, bean);
				bean=read.readDaoCalling(studentname);
				request.setAttribute("studentname", bean);
				RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/display.jsp");
				redirect.forward(request, response);
				System.out.println(studentname);
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}


		}

		else if(request.getParameter("action").equals("delete"))
		{
			bean.setStudentname(request.getParameter("studentname"));
			DeleteModel delete=new DeleteModel();
			try {
				delete.deleteDaoCalling(bean);
				request.setAttribute("message","Deleted successfully");
				RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/deletedisplay.jsp");
				redirect.forward(request, response);
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
				}
		else if(request.getParameter("action").equals("update"))
		{
			String studentname=request.getParameter("studentname");
			System.out.println(studentname);
				request.setAttribute("studentname", bean);
				RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/updatepage.jsp");
				redirect.forward(request, response);

		}
		else if(request.getParameter("action").equals("up"))
		{
			bean.setStudentname(request.getParameter("studentname"));
			System.out.println(request.getParameter("studentname"));
			bean.setDate(request.getParameter("date"));
			bean.setMark(Integer.parseInt(request.getParameter("mark")));
			UpdateModel updatemodel=new UpdateModel();
			try {
				updatemodel.updateDaoCalling(bean);
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}


package project.dao;

import project.bean.*;
import java.sql.*;

public class DaoClass extends Connections
{
	public ProjectBean daoMethod(ProjectBean bean) throws ClassNotFoundException, SQLException
	{
		Connection connection=getConnection();
		Statement statement=connection.createStatement();
		System.out.println("insert into studentproject values('"+bean.getStudentname()+"','"+bean.getDate()+"',"+bean.getMark()+")");
		System.out.println("daoclass");
		ResultSet rs=statement.executeQuery("insert into studentproject values('"+bean.getStudentname()+"','"+bean.getDate()+"',"+bean.getMark()+")");
		return bean;
	}
	public ProjectBean readDaoMethod(String studentname) throws ClassNotFoundException, SQLException
	{
		Connection connection=getConnection();
		Statement statement=connection.createStatement();
		ProjectBean bean=new ProjectBean();
		System.out.println("select * from studentproject where studentname='"+studentname+"'");
		ResultSet rs1=statement.executeQuery("select * from studentproject where studentname='"+studentname+"'");
		while(rs1.next())
		{
		bean.setStudentname(rs1.getString("studentname"));
		bean.setDate(rs1.getString("Applydate"));
		bean.setMark(rs1.getInt("mark"));
		}
		return bean;
	}
	public int deleteDaoMethod(ProjectBean bean) throws ClassNotFoundException, SQLException
	{
		Connection connection=getConnection();
		Statement statement=connection.createStatement();
	ResultSet rs2=statement.executeQuery("delete from studentproject where studentname='"+bean.getStudentname()+"'");
	return 1;
	}

	public void updateDaoMethod(ProjectBean bean) throws ClassNotFoundException, SQLException
	{
		Connection connection=getConnection();
		Statement statement=connection.createStatement();
		int result =statement.executeUpdate("update studentproject set studentname='"+bean.getStudentname()+"',applydate='"+bean.getDate()+"',mark="+bean.getMark()+"");
		if(result==1)
		{
			System.out.println("data updated");
		}
		else
		{
			System.out.println("data not updated");
		}
	}
}





package project.dao;

import java.sql.*;

/*class for connections*/
public class Connections {

	Connection con=null;


      /*method for open connection*/
	public Connection getConnection() throws ClassNotFoundException, SQLException
	{
		/*
		 * creating connection
		 */
		Class.forName("oracle.jdbc.OracleDriver");
		String url= "jdbc:oracle:thin:@172.24.137.30:1521:ora10g";
		con=DriverManager.getConnection(url,"e543820","REaqbsude");
		return con;
	}


      /*method for close connection*/
	public void closeConnection(Connection con) throws SQLException
	{
		/*
		 * closing connection
		 */
		con.close();
	}
}



CREATE MODEL:


package project.model;
import java.sql.SQLException;

import project.bean.*;
import project.dao.*;

public class ProjectModel {
	public ProjectBean daoCallingMethod(ProjectBean bean) throws ClassNotFoundException, SQLException
	{
		DaoClass dao=new DaoClass();
		bean=dao.daoMethod(bean);
		return bean;
	}

}


READ MODEL:


package project.model;
import java.sql.SQLException;

import project.bean.*;
import project.dao.DaoClass;

public class ReadModel {
	public ProjectBean readDaoCalling(String studentname) throws ClassNotFoundException, SQLException
	{
		DaoClass dao=new DaoClass();
		ProjectBean bean=new ProjectBean();
		bean=dao.readDaoMethod(studentname);
		return bean;
	}

}


DELETE MODEL:

package project.model;

import java.sql.SQLException;

import project.bean.ProjectBean;
import project.dao.DaoClass;

public class DeleteModel {
    public int deleteDaoCalling(ProjectBean bean) throws ClassNotFoundException, SQLException
    {
    	DaoClass dao=new DaoClass();
    	int result=dao.deleteDaoMethod(bean);
		return result;

    }

}


package project.model;
import java.sql.SQLException;

import project.bean.*;
import project.dao.DaoClass;
public class UpdateModel {
	public void updateDaoCalling(ProjectBean bean) throws ClassNotFoundException, SQLException
	{
		DaoClass dao=new DaoClass();
	    dao.updateDaoMethod(bean);
		}

}