 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / March 2004JSP ORACLE CONNECTIVITY
hi well i am a student and i require some help. I am unable to connect to oracle installed on the same machine on which jsp files are stored. It would be great if u help me out. i am sending the code to u and u could reply at [COLOR=Blue]manpreetgrover@rediffmail.com[/COLOR] . after filling up the form in the first page an dthen submit is clicked it says resultset not found in type declaration. I am making use of oracle8i,java web server,jsp. A line in reply will be deeply appreciated [B]addsite.jsp[/B] <html> <head> <title>Add site</title> </head> <body bgcolor="white"> <form name='siteaddform' method='post' action='addsitedetails.jsp'> <p align="center"><font size="4"><strong><u><font face="Verdana, Arial, Helvetica, sans-serif"><b><font color="800000" size="3">Add Site</font></b></font></u></strong></font></p> <div align="center"><center> <table border="1" bgcolor="#68E3FD" cellpadding="5" cellspacing="2" bordercolor="000080"> <tr> <td align="center">SITE NAME : </td><td align="left"> <input type='text' name='sitename' size=30></td> </tr> <tr> <td align="center">SITE ID : </td><td align="left"> <input type='text' name='site_id' size=30></td> </tr> <tr> <td align="center">SITE PHONE : </td><td align="left"> <input type='text' name='site_phone' size=30></td> </tr> <tr> <td align="center">SITE ADDRESS : </td><td align="left"> <input type='text' name='site_add' size=100></td> </tr> <tr> <td align="center">NEXT SITE ID : </td><td align="left"> <input type='text' name='nextsite_id' size=30></td> </tr> <tr> <td align="center">PREVIOUS SITE ID : </td><td align="left"> <input type='text' name='prev_site_id' size=30></td> </tr> <tr> <td align="center">LANDLORD NAME : </td><td align="left"> <input type='text' name='landlordname' size=30></td> </tr> <tr> <td align="center">LANDLORD PHONE : </td><td align="left"> <input type='text' name='landlord_phn' size=30></td> </tr> <tr> <td align="center">INCHARGE ENGINEER : </td><td align="left"> <input type='text' name='inchg_eng_name' size=30></td> </tr> <tr> <td align="center">PATROL RIDER : </td><td align="left"> <input type='text' name='pr_rider_name' size=30></td> </tr> <tr> <td align="center">GUARD : </td><td align="left"> <input type='text' name='guard_name' size=30></td> </table> </center></div> <p> <div align="center"><center> <table border="0"> <tr> <td> <input type='submit' name='sub' value='SUBMIT'></td> <td> <input type='reset' name='rst' value='RESET'></td> </tr> </table> </center></div> </p> </form> </body> </html> [B]addsitedetails.jsp[/B] <html> <head> <title> Add Site Details </title> </head> <%@ page language="java" %> <%@ page import="java.sql.*" %> <%@ page errorPage="errorpage.jsp"%> <body> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:btsol","system","manager"); String sitename=request.getParameter("sitename"); String site_id=request.getParameter("site_id"); String site_phone=request.getParameter("site_phone"); String site_add=request.getParameter("site_add"); String nextsite_id=request.getParameter("nextsite_id"); String prev_site_id=request.getParameter("prev_site_id"); String landlordname=request.getParameter("landlordname"); String landlord_phn=request.getParameter("landlord_phn"); String inchg_eng_name=request.getParameter("inchg_eng_name"); String pr_rider_name=request.getParameter("pr_rider_name"); String guard_name=request.getParameter("guard_name"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeUpdate("insert into site (sitename,site_id,site_phone,site_add,nextsite_id,prev_site_id,landlordname,landlord_phn,inchg_eng_name,pr_rider_name,guard_n ame) values('"+sitename+"','"+site_id+"','"+site_phone+"','"+site_add+"','"+nextsite_id+"','"+prev_site_id+"','"+landlordname+"',' "+landlord_phn+"','"+inchg_eng_name+"','"+pr_rider_name+"','"+guard_name+"')"); %> if (rs==1) { <h1> Successful addition of the site</h1> } else { <h1> Sorry addition failed</h1> } <% stmt.close(); con.close(); %> <form name='sitedetailsform' method='post' action='addequipment.jsp'> <p align="center"><font size="4"><strong><u><font face="Verdana, Arial, Helvetica, sans-serif"><b><fontcolor="800000" size="3">Add Site Details</font></b></font></u></strong></font></p> <div align="center"><center> <table border="1" bgcolor="#68E3FD" cellpadding="5" cellspacing="2" bordercolor="000080"> <td align="center">AC SERIAL NUMBER : </td><td align="left"> <input type='text' name='serial_num' size=30></td> </tr> <tr> <td align="center">AC MAKE : </td><td align="left"> <input type='text' name='make' size=30></td> </tr> <tr> <td align="center">AC MODEL : </td><td align="left"> <input type='text' name='model' size=30></td> </tr> <tr><tr><tr><tr><tr> <td align="center">DG SERIAL NUMBER : </td><td align="left"> <input type='text' name='serial_num' size=30></td> </tr> <tr> <td align="center">DG MAKE : </td><td align="left"> <input type='text' name='make' size=30></td> </tr> <tr> <td align="center">DG MODEL : </td><td align="left"> <input type='text' name='model' size=30></td> </tr> <tr><tr><tr><tr><tr> <td align="center">SERVO SERIAL NUMBER : </td><td align="left"> <input type='text' name='serial_num' size=30></td> </tr> <tr> <td align="center">SERVO MAKE : </td><td align="left"> <input type='text' name='make' size=30></td> </tr> <tr> <td align="center">SERVO MODEL : </td><td align="left"> <input type='text' name='model' size=30></td> </tr> <tr><tr><tr><tr><tr> <td align="center">BATTERY SERIAL NUMBER : </td><td align="left"> <input type='text' name='serial_num' size=30></td> </tr> <tr> <td align="center">BATTERY MAKE : </td><td align="left"> <input type='text' name='make' size=30></td> </tr> </table> </center></div> <p> <div align="center"><center> <table border="0"> <tr> <td> <input type='submit' name='sub' value='SUBMIT'></td> <td> <input type='reset' name='rst' value='RESET'></td> </tr> </table> </body> </html "Manpreet" wrote... > i am sending the code to u and u could reply at > [COLOR=Blue]manpreetgrover@rediffmail.com[/COLOR] . No I will not. You asked in a newsgroup, and will get the answer in the newsgroup, so other can benefit from or object to the answers... > after filling up the form in the first page and > then submit is clicked it says resultset not found > in type declaration. With a quick glance on your code, I see: > ResultSet rs = stmt.executeUpdate(...); executeUpdate doesn't return a ResultSet and it shouldn't. It returns an int with either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing. // Bjorn A Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.