|
<%
String qid=request.getParameter("t1");
String author=request.getParameter("t2");
String quest=request.getParameter("t3");
String op1=request.getParameter("t4");
String op2=request.getParameter("t5");
String op3=request.getParameter("t6");
String op4=request.getParameter("t7");
String ans=request.getParameter("o1");
if(!(qid==" " && author==" " && quest==" " && op1== " "&& op2== " "&& op3== " "&& op4== " "&& ans== " "))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
st.executeQuery("insert into question values("+qid+",'"+quest+"',"+ans+",'"+author+"','"+op1+"','"+op2+"','"+op3+"','"+op4+"')");
out.println ("Insert Successful");
}catch(Exception e1)
{
out.println(e1);
}
}
%>
<%
if(!( qid==" " ))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from question");
while(rs.next())
{
String username=rs.getString(1);
if(qid.equals(username) )
{
//setElementById("txt1")=rs.getString(2);
}
}
if(rs.isLast()==true)
{
out.println("Login Failed,Please try Again");
}
}catch(Exception e1)
{
}
}
%>
<%
qid=request.getParameter("t2");
if(!(qid==" "))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
String query="delete from question where q_id="+qid;
st.executeUpdate(query);
}catch(Exception e1)
{
}
}
%>
<%
qid=request.getParameter("t1");
author=request.getParameter("t2");
quest=request.getParameter("t3");
op1=request.getParameter("t4");
op2=request.getParameter("t5");
op3=request.getParameter("t6");
op4=request.getParameter("t7");
ans=request.getParameter("o1");
if(!(qid==" " && author==" " && quest==" " && op1== " "&& op2== " "&& op3== " "&& op4== " "&& ans== " "))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger");
Statement st=con.createStatement();
String query="update question set q_id="+qid+",ques='"+quest+"',ans="+ans+",author='"+author+"',op1='"+op1+"',op2='"+op2+"',op3='"+op3+"',op4='"+op4+"'where q_id="+qid;
st.executeUpdate(query);
}catch(Exception e1)
{
}
}
%>
|