hey friends i'm getting an error
in this code
[CODE=java]import java.io.*;
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.sql.*;
public class E_3_DeptEntry extends HttpServlet
{
public void doPost(HttpServ letRequest req,HttpServlet Response res)throws IOException,Ser vletException
{ String a,b,c,d,e,f;
int i;
Connection con;
try
{
res.setContentT ype("text/html");
Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
con=DriverManag er.getConnectio n("jdbc:Oracle: thin:@server:15 21:Oracle8i","t y289","ty289");
String Query="insert into dept Values(?,?,?)";
Statement st=con.createSt atement();
PreparedStateme nt ps;
ps=con.prepareS tatement(Query) ;
a=(String)req.g etParameter("tx tNo");
b=(String)req.g etParameter("tx tName");
c=(String)req.g etParameter("tx tLoc");
ps.setString(1, a);
ps.setString(2, b);
ps.setString(3, c);
ps.executeUpdat e();
PrintWriter out=res.getWrit er();
ResultSet rs=st.executeQu ery("select * from dept");
ResultSetMetaDa ta md=rs.getMetaDa ta();
int num=md.getColum nCount();
out.println("<h tml><body><tabl e border=1><tr>") ;
for(i=1;i<=num; i++)
{
out.print("<th> "+md.getColumnN ame(i)+"</th>");
}
out.println("</tr>");
while(rs.next() )
{ d=rs.getString( 1);
e=rs.getString( 2);
f=rs.getString( 3);
out.println("<t r><td>");
out.println(d);
out.println("</td><td>");
out.println(e);
out.println("</td><td>");
out.println(f);
out.println("</td></tr>");
}
out.println("</table>");
con.commit();
out.println("<a href=DeptForm_2 97.class>BACK</a>");
out.println("</body></html>");
}
catch (Exception ae){
System.out.prin tln(ae.getMessa ge());
}
}
}[/CODE]
please help me out
Code:
HTTP Status 405 - HTTP method GET is not supported by this URL
[CODE=java]import java.io.*;
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.sql.*;
public class E_3_DeptEntry extends HttpServlet
{
public void doPost(HttpServ letRequest req,HttpServlet Response res)throws IOException,Ser vletException
{ String a,b,c,d,e,f;
int i;
Connection con;
try
{
res.setContentT ype("text/html");
Class.forName(" oracle.jdbc.dri ver.OracleDrive r");
con=DriverManag er.getConnectio n("jdbc:Oracle: thin:@server:15 21:Oracle8i","t y289","ty289");
String Query="insert into dept Values(?,?,?)";
Statement st=con.createSt atement();
PreparedStateme nt ps;
ps=con.prepareS tatement(Query) ;
a=(String)req.g etParameter("tx tNo");
b=(String)req.g etParameter("tx tName");
c=(String)req.g etParameter("tx tLoc");
ps.setString(1, a);
ps.setString(2, b);
ps.setString(3, c);
ps.executeUpdat e();
PrintWriter out=res.getWrit er();
ResultSet rs=st.executeQu ery("select * from dept");
ResultSetMetaDa ta md=rs.getMetaDa ta();
int num=md.getColum nCount();
out.println("<h tml><body><tabl e border=1><tr>") ;
for(i=1;i<=num; i++)
{
out.print("<th> "+md.getColumnN ame(i)+"</th>");
}
out.println("</tr>");
while(rs.next() )
{ d=rs.getString( 1);
e=rs.getString( 2);
f=rs.getString( 3);
out.println("<t r><td>");
out.println(d);
out.println("</td><td>");
out.println(e);
out.println("</td><td>");
out.println(f);
out.println("</td></tr>");
}
out.println("</table>");
con.commit();
out.println("<a href=DeptForm_2 97.class>BACK</a>");
out.println("</body></html>");
}
catch (Exception ae){
System.out.prin tln(ae.getMessa ge());
}
}
}[/CODE]
please help me out
Comment