January 5, 2011 at 12:54 PM
Hi Friend,
Follow these steps:
1) Import the following packages in your servlet file:
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;
2) Load and Register the JDBC driver:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
or you can use
Class.forName("oracle.jdbc.driver.OracleDriver");
3) Connect to database:
a) If you are using oracle oci driver,you have to use:
Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:
@oracle.world", "root", "root");
where oracle.world is the TNSNAMES entry and root is the username and password.
b) If you are using oracle thin driver,you have to use:
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@localhost:3306:roseindia",
"root", "root");
where localhost is the host,3306 is the port, roseindia is the database and root is the username and password.
4) Querying the database:
a)create statement:
Statement st = conn.createStatement();
b)write query and execute the query:
ResultSet rs = st.executeQuery("SELECT * from student");
5) Close the statement,resultset and connection:
rs.close();
st.close();
conn.close();
Try the following code:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;
public class Data extends HttpServlet {
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
String msg=req.getParameter("msg");
res.setContentType("text/html");
PrintWriter out = res.getWriter();
System.out.println(msg);
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin: @localhost:3306:Oracle", "rose", "rose");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from data");
while(rs.next()){
out.println(rs.getString("name")+" "+rs.getString("address")+"<br>");
}
con.close();
}
catch(Exception e){
System.out.println(e);
}
}
}
Thanks
Related Tutorials/Questions & Answers:
Advertisements
Could not establish the connection to oracle - JDBC to use:
Connection conn = DriverManager.getConnection("
jdbc:
oracle:oci8... to use:
Connection conn = DriverManager.getConnection ("
jdbc:
oracle:thin... oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("
jdbc:
oracle REQ for connection b/w jdbc and oracle database REQ for
connection b/w
jdbc and
oracle database REQ for
connection b/w
jdbc and
oracle database
The Java classes to
connect...());
Connection conn = DriverManager.getConnection("
jdbc:
oracle:thin: @localhost
java to oracle code - JDBCjava to
oracle code please suggest m calculate the database performance between scaled images and unscaled images in the database
jdbc connection to java program code - JDBCjdbc connection to java program code i want a simple java program that which communicates with
oracle database like creating table,insert values and update records in database and show in program output? please take a simple
ex. connect to Oracle - Java Beginnersex.
connect to Oracle dear sir,
I want to ask how to
connect java to
oracle, please give me a details tutorial with example
code how to
connect...";
String db = "XE";
String url = "
jdbc:
oracle:thin:@" + serverName
jdbc oracle connectivity problemjdbc oracle connectivity problem Hi All,
I am trying to
connect my swing application to
oracle DB . but class.forname is giving error. Please suggest me if there is some different way to
connect swing application to
oracle code for jsp to db connection using jdbccode for jsp to db
connection using jdbc please send me the
code
Hi Friend,
Try the following
code:ADS_TO_REPLACE_1
1)form.html:
<...("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con
Connect GWT application with OracleConnect GWT application with Oracle Can anyone tell me how to
connect gwt with
oracle database...??? I tried but, I failed every time. If possible please rply with a sample
code in while database is connected in gwt application
connect netbeans with oracleconnect netbeans with oracle how to
connect netbeans with
oracle
Hi Friend,
Please visit the following link:
http://www.roseindia.net/jsf/visual-jsf.shtml
Here you will find the steps to
connect netbeans
HTML code to servlet to database using jdbcHTML
code to
servlet to database using jdbc pls send me the
code related to the title
Hi Friend,
Try the following
code:ADS...);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con
Java Connection to Oracle databaseJava
Connection to
Oracle database HI
I am ubable to connnect
jdbc to
Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed
Oracle and in TNS i culdn't
oracle - JDBCoracle sir iam hari
iam doing the project using
oracle
with
jdbc in xp
when iam inserting the data it is giving error like ora-01034:
oracle not available
sir plz.......give me the solution
it is urgent sir
thanku
JDBC Oracle programJDBC Oracle program Here is my
code:
import java.sql.*;
public...("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("
jdbc:
oracle:thin:@localhost:8080:
oracle", "System", "System
JDBC connection we illustrates you
JDBC url
connection. The current
Tutorial helps you to understand
JDBC connection. The
code explains you
how...
JDBC connection
The
JDBC error oracle database connection?error
oracle database
connection? hi now i am trying to
connect oracle database and also insert my data into table, but it's not working.. I created... in
oracle table. my table name is logininfoclient_sla. this is my coding
java connecting to oracle db - JDBC to use:
Connection conn = DriverManager.getConnection("
jdbc:
oracle:oci8... have to use:
Connection conn = DriverManager.getConnection ("
jdbc:
oracle:thin...());
Connection conn = DriverManager.getConnection("
jdbc:
oracle:thin: @localhost
Java vs Oracle Connectivity - JDBC connection with
oracle database? Hi Friend,
Use
Oracle with Java... are using
oracle oci driver,you have to use:
Connection conn = DriverManager.getConnection("
jdbc:
oracle:oci8:
@oracle.world", "root", "root");
where
oracle - JDBCoracle HI i am using
ORACLE 10g.
How to i find "TNSNAMES.ORA" file in my system after installation of
ORACLE 10g succussfully.
please send... that depends on the actual network implementation used.
Oracle recommends that SDU
Oracle - JDBCOracle fetch variables i wanted to fetch variables from database using
Oracle how to connect mysql with JDBC - JDBC in the database MYsql, i have to
connect them now using
JDBC, can u please suggest me... {
connection = DriverManager.getConnection("
jdbc:mysql://localhost...();
}
}
Thanks
Rajanikant Hi friend,
To mysql
connect using
JDBC About connection database oracle to javaAbout
connection database
oracle to java Hi
I culdn't
connect oracle datebase to java.when i compile the program it is ok.but when i clicked...
Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to javaAbout
connection database
oracle to java Hi
I culdn't
connect oracle datebase to java.when i compile the program it is ok.but when i clicked...
Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to javaAbout
connection database
oracle to java I culdn't
connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected
Oracle... just typed DNS as
Oracle and for TNS i clicked on the list of TNS. But it has
About connection database oracle to javaAbout
connection database
oracle to java I culdn't
connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected
Oracle... just typed DNS as
Oracle and for TNS i clicked on the list of TNS .But it has
About connection database oracle to javaAbout
connection database
oracle to java **Hi
I culdn't
connect oracle datebase to java.when i compile the program it is ok.but when i clicked...
Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
oracle - JDBC to store these two fields into
oracle database
for that i have given one jsp page... it is giving error like
java.sql.SQLException:[MICROSOFT][ODBC Driver for
oracle][
oracle oracle - JDBCoracle How to collect the backup of tables in
oracle?
plz,, i want some tables in
oracle of one system to be shifted to the another system...;There are two .exe files in
ORACLE, with the FOLLOWING names,generally
Hibernate- Oracle connection - Hibernate to make a
connection to
oracle DB from eclipse.
Thanks...Hibernate-
Oracle connection In Eclipse I tried
Windows -->... on databaseconnection --> New
Oracle
Added ojdbc14 Jar file path
UID
Oracle - JDBCOracle How to Use Blob and Clob Data types in
Oracle... Hi friend
BLOB : Binary Large Object
CLOB : Character Large Object
Default storage each time a BLOB or CLOB exceeds 4000 bytes you could cause
Java Jdbc connectionJava
Jdbc connection What are the steps involved for making a
connection with a database or how do you
connect to a database
servlet - JDBC about oracle.I am giving this
code below please
connect this
code from sql... = DriverManager.getConnection("
jdbc:
oracle:thin:@localhost:1521:
oracle","scott... con = DriverManager.getConnection("
jdbc:
oracle:thin:@localhost:1521:
oracle jdbc-oracle - JDBCjdbc-oracle Hi!
sub: image insertion in
oracle:
I inserted the image in
oracle database using java through
jdbc-odbc bridge driver Successfully. But how to view the table contents ? because when I did select*from table
i can not connect to database in servlet - JSP-Servlet offer . Hi friend,
Code to
connect to database in
servlet... the tutorial in this site on
servlet and
JDBC.
I did all the proccedure for connecting...("");
out.println("
Servlet JDBC");
out.println("");
out.println("
Servlet JDBC i can not connect to database in servlet - JSP-Servlet offer . Hi friend,
Code to
connect to database in
servlet... the tutorial in this site on
servlet and
JDBC.
I did all the proccedure for connecting...");
PrintWriter out = response.getWriter();
out.println("");
out.println("
Servlet JDBC server database connection - JSP-Servlet");
2.Connection con=DriverManager.getConnection("
jdbc:odbc:Driver={Microsoft ODBC For
Oracle}","scott","tiger");
But how to get the
connection from...server database connection sir generally we will
connect Oracle ANd JDBC - JDBCOracle ANd JDBC How to Save and Retrieve an Image or File into a
Oracle Table..
Please give me answer as early as possible..
Thanks
jdbc connection issues in the database correspondingly.
How pls tell me how
connect these 11 forms and 11 tables with only one
jdbc connection program...if possiable pls post a sample
code...
jdbc connection issues Hello.
kindly pls help in this issue...i
servlets+jdbc+oracle - JDBCservlets+
jdbc+oracle can you please help me to create a dynamic website.
can you send me source
code for creating a dynamic website for an engneering college
connect jdbc to an Excel spreadsheetconnect jdbc to an Excel spreadsheet hello,
How can I
connect to an Excel spreadsheet file using
jdbc?
Hello Friend,ADS_TO_REPLACE_1...("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("
jdbc