Microsoft Access 97
this is my programme....
import java.io.;
import java.sql.;
import javax.servlet.;
import javax.servlet.http.;
public class onlineregest extends HttpServlet
{
Connection con;
Statement st;
ResultSet rs;
public void init(ServletConfig sc)
{
try
{
super.init(sc);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:SKYDSN");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
doGet(req,res);
}
public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String str1=null,str2=null,str3=null,str4=null,str5=null,str6=null,str7=null,str8=null,str9=null,str10=null,str11=null,str12=null,str13=null,str14=null,str15=null,str16=null,str17=null,str18=null,str19=null,str20=null,str21=null,str22=null,str23=null,str24=null,str25=null,str26=null,str27=null,str28=null,str29=null,str30=null,str31=null,str32=null,str33=null,str34=null,str35=null,str36=null;
System.out.println("str1");
str1=req.getParameter("t1");
str2=req.getParameter("t2");
str3=req.getParameter("t3");
str4=req.getParameter("t4");
str5=req.getParameter("t5");
str6=req.getParameter("t6");
str7=req.getParameter("t7");
str8=req.getParameter("t8");
str9=req.getParameter("t9");
str10=req.getParameter("t10");
str11=req.getParameter("t11");
str12=req.getParameter("t12");
str13=req.getParameter("t13");
str14=req.getParameter("t14");
str15=req.getParameter("t15");
str16=req.getParameter("t16");
str17=req.getParameter("t17");
str18=req.getParameter("t18");
str19=req.getParameter("t19");
str20=req.getParameter("t20");
str21=req.getParameter("t21");
str22=req.getParameter("t22");
str23=req.getParameter("t23");
str24=req.getParameter("t24");
str25=req.getParameter("t25");
str26=req.getParameter("t26");
str27=req.getParameter("t27");
str28=req.getParameter("t28");
str29=req.getParameter("t29");
str30=req.getParameter("t30");
str31=req.getParameter("t31");
str32=req.getParameter("t32");
str33=req.getParameter("t33");
str34=req.getParameter("t34");
str35=req.getParameter("t35");
str36=req.getParameter("t36");
try
{
st=con.createStatement();
//String str="insert into MEMBER1 (MemberName,FatherName,Age,DOBDate,DOBMonth,DOBYear,Sex,Occupation,NomineeName,NomineeAge,Relationship,EmailID,Address1,Address2,City,Pincode,State,Country,Phone,REGDate,REGMonth,REGYear,Place,IntroducerID)values('"+Tf1+"','"+Tf2+"',"+Tf3+",'"+C1+"','"+C2+"','"+C3+"','"+C4+"','"+Tf4+"','"+Tf5+"',"+Tf6+",'"+Tf7+"','"+Tf8+"','"+Tf9+"','"+Tf10+"','"+Tf11+"',"+Tf12+",'"+Tf13+"','"+C5+"',"+Tf14+",'"+C6+"','"+C7+"','"+C8+"','"+Tf16+"','"+Tf15+"')";
String str="insert into regest(NAME,FATHER'SNAME,AGE,DOBD,DOBM,DOBY,SEX,OCCUPATION,NOMINEENAME,NOMINEEAGE,RELATIONSHIP,ADDRESS1,ADDRESS2,CITY,PINCODE,STATE,COUNTRY,PHONENO,EMAILID,REGD,REGM,REGY,PLACE,DOMAINNAME1,DOMAINNAME2,DOMAINNAME3,DOMAINNAME4,DOMAINNAME5,EMAILNAME1,EMAILNAME2,EMAILNAME3,USERNAME,PASSWORD,REPASSWORD,INTRODUCERID,SERVICEPOINT)values('&"+str1+"','&"+str2+"','&"+str3+"','&"+str4+"','&"+str5+"','&"+str6+"','&"+str7+"','&"+str8+"','&"+str9+"','&"+str10+"','&"+str11+"','&"+str12+"','&"+str13+"','&"+str14+"','&"+str15+"','&"+str16+"','&"+str17+"','&"+str18+"','&"+str19+"','&"+str20+"','&"+str21+"','&"+str22+"','&"+str23+"','&"+str24+"','&"+str25+"','&"+str26+"','&"+str27+"','&"+str28+"','&"+str29+"','&"+str30+"','&"+str31+"','&"+str32+"','&"+str33+"','&"+str34+"','&"+str35+"','&"+str36+"')";
System.out.println(str);
st.executeUpdate(str);
//st.executeUpdate("INSERT INTO regest(NAME,FATHER'SNAME,AGE,DOBD,OBM,DOBY,SEX,OCCUPATION,NOMINEENAME,NOMINEEAGE,RELATIONSHIP,ADDRESS1,ADDRESS2,CITY,PINCODE,STATE,COUNTRY,PHONENO,EMAILID,REGD,REGM,REGY,PLACE,DOMAINNAME1,DOMAINNAME2,DOMAINNAME3,DOMAINNAME4,DOMAINNAME5,EMAILNAME1,EMAILNAME2,EMAILNAME3,USERNAME,PASSWORD,REPASSWORD,INTRODUCERID,SERVICEPOINT)values('"+str1+"','"+str2+"','"+str3+"','"+str4+"','"+str5+"','"+str6+"','"+str7+"','"+str8+"','"+str9+"','"+str10+"','"+str11+"','"+str12+"','"+str13+"','"+str14+"','"+str15+"','"+str16+"','"+str17+"','"+str18+"','"+str19+"','"+str20+"','"+str21+"','"+str22+"','"+str23+"','"+str24+"','"+str25+"','"+str26+"','"+str27+"','"+str29+"','"+str30+"','"+str31+"','"+str32+"','"+str33+"','"+str34+"','"+str35+"','"+str36+"')";
out.println("<body bgcolor=#a6a6fff>");
out.println("<center><h2><b> Your Entry is Successfully Registered </b></h2></center>");
out.println("<center><h3><i>More details Contact Corporate Office</i></h3></center>");
}
catch(SQLException se)
{
out.println("<center><h4>"+se.getMessage()+"</h4></center>");
out.println("<center><h1>Your Entry is not Correct Please try again <h1></center>");
}
try
{
st.close();
con.close();
}
catch(Exception ee)
{
out.println(ee);
}
}
}
when i compile there is no error.... but
when i call the servlet from the html page...
it give general error...
pls give any idea to solve that and why its happening....
