JSP ORACLE CONNECTIVITY
From: Manpreet (guy_manpreet_at_yahoo.com)
Date: 03/26/04
- Next message: Tommy Karlsson: "Calling a stored procedure with many arguments"
- Previous message: ugianka: "in memory db of 200 GB"
- Next in thread: Bjorn Abelli: "Re: JSP ORACLE CONNECTIVITY"
- Reply: Bjorn Abelli: "Re: JSP ORACLE CONNECTIVITY"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 26 Mar 2004 03:28:25 -0800
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>
- Next message: Tommy Karlsson: "Calling a stored procedure with many arguments"
- Previous message: ugianka: "in memory db of 200 GB"
- Next in thread: Bjorn Abelli: "Re: JSP ORACLE CONNECTIVITY"
- Reply: Bjorn Abelli: "Re: JSP ORACLE CONNECTIVITY"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
