 |  |  |  |  |  |  |  |
JSP using Oracle Database
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hi all ..
this jsp code when we use database access, to get the information by entering the price , my problem is that now iam using oracle as database and i dont know what are the changes that can be made here only ofcorse the path of database this i have , but string will it change because in oracle its varchar ? .. !! .. plz help.. its my first time to do this ..
Thanks
<html>
<body>
<%@ page import="java.sql.*" %>
<%
Connection con = null;
Statement st;
ResultSet rs;
String sql = "";
int price;
price= Integer.parseInt(request.getParameter("price"));
sql = "SELECT * FROM itemTBL where price = "+ price;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:prodDSN");
st = con.createStatement();
rs = st.executeQuery(sql);
%>
<table border=2>
<%
while(rs.next())
{
%> <tr>
<td><%=rs.getString("prodno")%></td>
<td><%=rs.getString("prodname")%></td>
<td><%=rs.getString("price")%></td>
<td><%=rs.getString("ptype")%></td>
</tr>
<% } %>
</table>
<%
rs.close();
con.close();
}
catch(Exception ex)
{
out.print(ex.getMessage());
}
%>
</body>
</html>
this jsp code when we use database access, to get the information by entering the price , my problem is that now iam using oracle as database and i dont know what are the changes that can be made here only ofcorse the path of database this i have , but string will it change because in oracle its varchar ? .. !! .. plz help.. its my first time to do this ..
Thanks
<html>
<body>
<%@ page import="java.sql.*" %>
<%
Connection con = null;
Statement st;
ResultSet rs;
String sql = "";
int price;
price= Integer.parseInt(request.getParameter("price"));
sql = "SELECT * FROM itemTBL where price = "+ price;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:prodDSN");
st = con.createStatement();
rs = st.executeQuery(sql);
%>
<table border=2>
<%
while(rs.next())
{
%> <tr>
<td><%=rs.getString("prodno")%></td>
<td><%=rs.getString("prodname")%></td>
<td><%=rs.getString("price")%></td>
<td><%=rs.getString("ptype")%></td>
</tr>
<% } %>
</table>
<%
rs.close();
con.close();
}
catch(Exception ex)
{
out.print(ex.getMessage());
}
%>
</body>
</html>
•
•
Join Date: Feb 2006
Posts: 2,387
Reputation: 
Solved Threads: 254
No. The query and setString statements can remain the same. It is, however, not recommended to use scriptlets this way. The DB code should be moved out to a bean. Scriptlets, AFAIK, are only still supported for backwards compatability reasons.
You don't want to be backwards do you? ;-)
You don't want to be backwards do you? ;-)
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
----------------------------------------------
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
Thanks masijade ...
hehe no i dont want
.. but this what they taught us in college !! ... basic things ..
however the most important thing is that the code doesnt fully change ... we have 4 weeks to finish the project ..
thanks again
... hehe no i dont want
.. but this what they taught us in college !! ... basic things ..however the most important thing is that the code doesnt fully change ... we have 4 weeks to finish the project
.. thanks again
tough luck. If they teach you to do it like that ask for your money back.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
they don't teach you the basics either the way they should.
What they are teaching you is the way things were done nearly 10 years ago which has been recognised as exactly the wrong way to do them for the last 7 or so.
If they insist in teaching it like that the course isn't worth the time and money you invest in it.
What they are teaching you is the way things were done nearly 10 years ago which has been recognised as exactly the wrong way to do them for the last 7 or so.
If they insist in teaching it like that the course isn't worth the time and money you invest in it.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Aha, well you know better than me ..
Thanks for your consideration.. i will talk to my supervisor about it ..
..Thanks for your consideration.. i will talk to my supervisor about it
.. •
•
Join Date: Aug 2007
Posts: 80
Reputation:
Solved Threads: 10
Junior Poster in Training
Hi,
You are using jdbc-odbc bridge to connect to Oracle db here
You might have successfully created the odbc data source. But it is the Tomcat runtime that needs to know about the odbc datasource. You'll have a tough time configuring it on Tomcat as you are still a student and migh not have played much with the Tomcat configuration files. I would suggest you to use Pure JDBC driver to connect to Oracle database. You can find the Oracle JDBC driver in the Oracle installation folder under jdbc directory. You can find some zip and jar files with name like oci12.zip oci12.jar, etc (Can't remember the names properly so you can send me the names which you find there if you are not sure which one to use). Copy the oci12.jar to either the lib directory of Tomcat Installation ("C:\Program Files\Apache Software Foundation\Apache Tomcat 6.0\lib") or to your web applications WEB-INF\lib (best practice to copy here) directory. Why we are doing it? The runtime environment of Tomcat i.e., the Tomcat's JVM needs the information at runtime about the Oracle related Jdbc drivers (remember the CLASSPATH setting you might have done earlier so that your program knows at runtime where to find specific classes). If you don't do this Tomcat will throw ClassNotFoundException at runtime.
Now, the JDBC specific parameters are need to be passed while establishing the Connection. So you'll have to make the following code changes
Please refer the following FAQ on more information
http://www.orafaq.com/faqjdbc.htm
You are using jdbc-odbc bridge to connect to Oracle db here
JSP Syntax (Toggle Plain Text)
You might have successfully created the odbc data source. But it is the Tomcat runtime that needs to know about the odbc datasource. You'll have a tough time configuring it on Tomcat as you are still a student and migh not have played much with the Tomcat configuration files. I would suggest you to use Pure JDBC driver to connect to Oracle database. You can find the Oracle JDBC driver in the Oracle installation folder under jdbc directory. You can find some zip and jar files with name like oci12.zip oci12.jar, etc (Can't remember the names properly so you can send me the names which you find there if you are not sure which one to use). Copy the oci12.jar to either the lib directory of Tomcat Installation ("C:\Program Files\Apache Software Foundation\Apache Tomcat 6.0\lib") or to your web applications WEB-INF\lib (best practice to copy here) directory. Why we are doing it? The runtime environment of Tomcat i.e., the Tomcat's JVM needs the information at runtime about the Oracle related Jdbc drivers (remember the CLASSPATH setting you might have done earlier so that your program knows at runtime where to find specific classes). If you don't do this Tomcat will throw ClassNotFoundException at runtime.
Now, the JDBC specific parameters are need to be passed while establishing the Connection. So you'll have to make the following code changes
JSP Syntax (Toggle Plain Text)
Please refer the following FAQ on more information
http://www.orafaq.com/faqjdbc.htm
•
•
Join Date: Aug 2007
Posts: 80
Reputation:
Solved Threads: 10
Junior Poster in Training
I'm sorry for my earlier reply, I thought you r facing Connectivity issues so please ignore it.
According to ur post, the price field is a VARCHAR in Oracle (Correct me if I'm wrong). In that case, the code will change to
You will have to convert price to a String(VARCHAR/CHAR format) for comparison to a String (VARCHAR) in database. To avoid the "'" + field + "'", use PreparedStatements. Or JDBC 2.0 features.
According to ur post, the price field is a VARCHAR in Oracle (Correct me if I'm wrong). In that case, the code will change to
JSP Syntax (Toggle Plain Text)
You will have to convert price to a String(VARCHAR/CHAR format) for comparison to a String (VARCHAR) in database. To avoid the "'" + field + "'", use PreparedStatements. Or JDBC 2.0 features.
|
Similar Threads
- How to connect Oracle database from JSP page (Java)
- Will the jsp code will change if we connected to the oracle database ? (JSP)
- how to connect oracle 8i database with jsp page (JSP)
- connecting jsp with oracle database (JSP)
- Posting form data to an Oracle database (JavaScript / DHTML / AJAX)
Other Threads in the JSP Forum
- Previous Thread: Help needed in JSP project-Online Examination
- Next Thread: Incomplete Loading of JSP page
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest JSP Posts
- Today's Posts
- Unanswered Threads
apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial update video web
