[chunshu00]

1. Syntax : public Statement createStatement()throws SQLException
Example to create the statement object
1. Statement stmt= teStatement();
4) Execute the query
To execute queries to the database executeQuery() method of Statement interface is used. This method returns the object of ResultSet that can be used to get all the records of a table.
Syntax of executeQuery() method
1. public ResultSet executeQuery(String sql)throws SQLException
Example to execute query
1. ResultSet rs= uteQuery("select * from emp");
2.
3. while( ()){
4. tln( nt(1)+" "+ tring(2));
5. }
5) Close the connection object
By closing connection object statement and ResultSet will be closed automatically. The close() method of Connection interface is used to close java course in Bangalore the connection.


Syntax :
public void close()throws SQLException
Example to close connection
e();
Connection with Oracle database :
To connect java application with the oracle database Zach Allen Cardinals Jersey , we need to follow 5 steps to perform database connectivity. Before that some information is needed :
1. Driver class: The driver class for the oracle database is leDriver.
2. Connection URL: The connection URL for the oracle database is jdbc:oracle:thin:@localhost:1521:xe where jdbc is the API, oracle is the database Andy Isabella Cardinals Jersey , thin is the driver, localhost is the server name on which oracle is running Byron Murphy Cardinals Jersey , , 1521 is the port number and XE is the Oracle service name. Username: The default username for the oracle database is system. Java course in Bangalore
3. Password: Password is given by the user at the time of installing the oracle database.
Steps :
1. step1 : load the driver class
2. ame(" leDriver");
1. step2: create the connection object
2. Connection con= onnection
3. ( "jdbc:oracle:thin:@localhost:1521:xe" Kyler Murray Cardinals Jersey ,"system","oracle");
4.
5. step3: create the statement object
6. Statement stmt= teStatement();
7.
8. step4: execute query
9. ResultSet rs= uteQuery("select * from emp");
while( ())
tln( nt(1)+" "+ tring(2)+" "+ tring(3));
10.
step5: close the connection object
11. e();
What is JDBC Drivers ? best core java training in bangalore
JDBC Driver is a software component that enables java application to interact with the database. There are 4 types of JDBC drivers:
1. JDBC-ODBC bridge driver
2. Native-API driver (partially java driver)
3. Network Protocol driver (fully java driver)
4. Thin driver (fully java driver)
1) JDBC-ODBC bridge driver
The JDBC-ODBC bridge driver uses ODBC driver to connect to the database. The JDBC-ODBC bridge driver converts JDBC method calls into the ODBC function calls. This is now discouraged because of thin driver.
2) Native-API driver
The Native API driver uses the client-side libraries of the database. The driver converts JDBC method calls into native calls of the database API. It is not written entirely in java.
3) Network Protocol driver
The Network Protocol driver uses middleware (application server) that converts JDBC calls directly or indirectly into the vendor-specific database protocol. It is fully written in java. Core and advanced java institute in marathahalli
4) Thin driver
The thin driver converts JDBC calls directly into the vendor-specific database protocol. That is why it is known as thin driver. It is fully written in Java language.
3. This is the short description about the JDBC connectivity . To get the more knowledge on java for getting a job as java developer join Infocampus Software Training Institute .


Author : Infocampus is the best institute for the javaj2ee classes Bangalore . It provides Advanced java training with the 100% job support . 3 days free demo classes are available for java training center Bangalore . Java course is provided by the more than 10 years experienced trainers .
Every weekend free demo classes are available. Syllabus is according to getting a job easily . Infocampus provides best core java training in bangalore with the real time project .
Learn OOPs concept Haason Reddick Cardinals Jersey , packages , multithreading Christian Kirk Cardinals Jersey , JDBC connec

Dubai has a lot of thinks to offer to you! Along with the extravagant sky scrapper. wholesale air max air max wholesale Cheap Jerseys Cheap Jerseys From China Cheap Jerseys From China Wholesale Jerseys China Cheap NFL Jerseys Cheap NFL Jerseys China Wholesale NFL Jerseys Cheap Jerseys