Please help(Problem in insertion data to database)

Reply

Join Date: Sep 2006
Posts: 3
Reputation: mysticcc is an unknown quantity at this point 
Solved Threads: 0
mysticcc mysticcc is offline Offline
Newbie Poster

Please help(Problem in insertion data to database)

 
0
  #1
Sep 15th, 2006
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:odbcriver={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>
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 2,326
Reputation: masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of 
Solved Threads: 248
Moderator
masijade's Avatar
masijade masijade is offline Offline
Nearly a Posting Maven

Re: Please help(Problem in insertion data to database)

 
0
  #2
Sep 15th, 2006
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.
Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Reply With Quote Quick reply to this message  
Join Date: Sep 2006
Posts: 3
Reputation: mysticcc is an unknown quantity at this point 
Solved Threads: 0
mysticcc mysticcc is offline Offline
Newbie Poster

Re: Please help(Problem in insertion data to database)

 
0
  #3
Sep 18th, 2006
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?
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 2,326
Reputation: masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of 
Solved Threads: 248
Moderator
masijade's Avatar
masijade masijade is offline Offline
Nearly a Posting Maven

Re: Please help(Problem in insertion data to database)

 
0
  #4
Sep 18th, 2006
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:
  1. catch (Exception e) {
  2. System.err.println("Insertion Error: " + e.getMessage());
  3. e.printStackTrace();
  4. }

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.
Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Reply With Quote Quick reply to this message  
Join Date: Sep 2006
Posts: 3
Reputation: mysticcc is an unknown quantity at this point 
Solved Threads: 0
mysticcc mysticcc is offline Offline
Newbie Poster

Re: Please help(Problem in insertion data to database)

 
0
  #5
Sep 18th, 2006
Thank you very much, I solved problem. I made a mistake that forgot a bracket.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC