<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%
String qt=request.getParameter("qt");
String op1=request.getParameter("op1");
String op2=request.getParameter("op2");
String op3=request.getParameter("op3");
String op4=request.getParameter("op4");
String ans=request.getParameter("an");
try{
	int slno;
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system", "system");
    PreparedStatement ps=con.prepareStatement("select qid from questions order by qid desc");
    ResultSet rs=ps.executeQuery();
    if(rs.next())
    	slno=rs.getInt(1)+1;
    else
    	slno=1;
    PreparedStatement ps1=con.prepareStatement("insert into questions values(?,?,?,?,?,?,?)");
   ps1.setInt(1, slno);
    ps1.setString(2, qt);
    ps1.setString(3, op1);
    ps1.setString(4,op2);
    ps1.setString(5,op3);
    ps1.setString(6,op4);
    ps1.setString(7,ans);
    int r=ps1.executeUpdate();
    if(r>=1)
    	response.sendRedirect("addquestion.jsp");
    con.close();
}

catch (Exception e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}


%>