Hi I have a difficulty in insertion data. I wrote my html code (a form in it) and jsp code to get the form data and insert it to database. I don't get any error message but it doesn't insert data to database. My code is below. Where am I wrong?

---kisisel.html---

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
//onSubmit olayýný yönlendirme fonksiyonu
function onayla() {
 return confirm('Bu sipariþi vermek istediðinizden emin misiniz?');
 }
//-->
</script>
</head>
<body bgcolor="#F7F5D5" link="#009900">
<p>&nbsp; </p>
<table width="96%" border="1" bordercolor="#003333" bgcolor="#CCFF99">
  <tr>
    <td align="center"><a href="kisisel.html"><strong><font size="+1">Kisisel 
      Bilgiler</font></strong></a></td>
    <td align="center"><a href="egitim.html"><font size="+1"><strong>Egitim Bilgileri</strong></font></a></td>
    <td align="center"><a href="beceri.html"><strong><font size="+1">Beceriler</font></strong></a></td>
    <td align="center"><a href="ekbilgi.html"><font size="+1"><strong>Ek Bilgiler</strong></font></a></td>
  </tr>
</table>
<p>&nbsp;</p><fieldset>
<p> 

  <legend><strong><font color="#663366" size="5"> 
  <input name="imageField" type="image" src="../../../../../Documents%20and%20Settings/Nurhan/Belgelerim/nur/L3.gif" width="32" height="32" border="0">
  Kisisel Bilgiler </font></strong></legend>
</p>
<form name="form1" method="post" action="test.jsp" >
  <p><font color="#9900FF"><strong>Ad* : </strong></font> 
    <input type="text" name="ad">
    <font color="#9900FF"><strong>Soyad*:</strong></font> 
    <input type="text" name="soyad">
  </p>
  <p><strong><font color="#9900FF">Dogum Tarihi*</font></strong>: 
    <input type="text" name="dogum">
  </p>
  <p><strong><font color="#9900FF">Cinsiyet* : 
    <label> </label>
    </font> 
    <label></label>
    </strong> 
    <label> 
    <input type="radio" name="cins" value="Bayan">
    Bayan</label>
    <label> 
    <input type="radio" name="cins" value="Erkek">
    Erkek</label>
    <br>
    <label> </label>
    <br>
    <font color="#9900FF"><strong>Medeni Durum* :</strong></font> 
    <label> </label>
    <select name="medeni_hal">
      <option value="Evli">Evli</option>
      <option value="Bekar">Bekar</option>
    </select>
    <input type="submit" name="Submit2" value="Kaydet" onSubmit="return onayla()" >
  </p>
  </form>

<p>&nbsp; </p>
</fieldset>
</body>
</html>

------------and here is test.jsp-----------

<html>
<head>
<%@ page 
 import = "java.io.*"
 import = "java.lang.*"
 import = "java.sql.*"
%>
<title>
JSP Example 2
</title>
</head>
<body>
<h1>JSP Example 3</h1>
<% 
    String ad=request.getParameter("ad");
 String soyad=request.getParameter("soyad");
 String dogum_tarih=request.getParameter("dogum");
 String cinsiyet=request.getParameter("cins");
 String medeni=request.getParameter("medeni_hal");

try {            

                  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");                        
                  String filename = "C:/Program Files/Tomcat 5.0/webapps/jsp-examples/vt1.mdb" ;            
                  String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";            
                  database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end             

                  Connection conn = DriverManager.getConnection( database ,"",""); 
                  Statement st=conn.createStatement();

         st.executeUpdate("INSERT INTO veriler VALUES ('"+ad+"','"+soyad+"','"+dogum_tarih+"','"+cinsiyet+"','"+medeni+"'"); 
   //      st.executeUpdate("INSERT INTO iletisim VALUES ('"+adres+"','"+semt+"','"+sehir+"','"+ulke+"','"+evtel+"','"+ceptel+"','"+email+"'"); 
         conn.close();
                        }
            catch (Exception e) { 
             /*   System.err.println("Got an exception! "); 
                System.err.println(e.getMessage()); */
            }       
%>
</body> 
</html>

Edited 3 Years Ago by Reverend Jim: Fixed formatting

Well, you might not be getting an error message, because you have commented out the contents of your catch block, effectively ignoring any errors. Remove the comment symbols in the catch block and try it again in order to check whether or not you actually get any error messages.

I removed comments but my problem still go on. I don't get any error message. Maybe catalina path is wrong. I set it to my folder where jsp and html files exist. Is it wrong?

Did you remove the comments in the catch block or only the comment symbols (i.e. /* and */). If you removed the comments all together, then of course you are still not seeing any errors as the catch block is still empty. Make sure the catch block is actuall doing something. Your catch block should be as follows:

catch (Exception e) { 
    System.err.println("Insertion Error:  " + e.getMessage());
    e.printStackTrace();
}

Make sure that it is that way, and try again. Then tell us what error you get.

And, trust me, if your path were wrong you would be getting errors. Usually ClassNotFoundException errors.

Thank you very much, I solved problem. I made a mistake that forgot a bracket. :)

This article has been dead for over six months. Start a new discussion instead.