Sign in Get Started

create connection in jdbc

Clinux 
package com.java2novice.jdbc;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
 
public class JdbcConnection {
 
    public static void main(String a[]){
         
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.
                getConnection("jdbc:oracle:thin:@<hostname>:<port num>:<DB name>"
                    ,"user","password");
            Statement stmt = con.createStatement();
            System.out.println("Created DB Connection....");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}
View another examples Add Own solution
Log in, to leave a comment

0
0
Alexander Serebrenik 85 points 

                                    Connection = 
  Helps our java project connect to database
Statement = 
  Helps to write and execute SQL query
ResultSet = 
  A DataStructure where the data from query result stored
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    

  After succesfully created the connect
next step is STATEMENT

Statement statement = connection.createStatement();
We use createStatement() method to create
the statement from our connection.
-The result we get from this type of statement
can only move from top to bottom,
not other way around

Statement statement = connection.
createStatement(ResultSet TYPE_SCROLL_INSENSITIVE
,ResultSet CONCUR_READ_ONLY);

-The result we get from this type of
statement can freely move between rows

Once we have statement we can run
the query and get the result to
ResultSet format 
		import java.sql.ResultSet;
        
We use the method executeQuery()
to execute our queries

ResultSet result = statement.
              executeQuery(&quot;Select * from employees&quot;);

0
0
Are there any code examples left?
Find Add Code snippet
New code examples in category Java
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
how to make a jdbc connection in java how does jdbc connection work java jdbc connection steps JDBC connection\ jdbc connection in jav jdbc connection explained create connection in oracle jdbc establish jdbc connection in java java tutorial jdbc connection how to make jdbc connection in java jdbc connection example describe the connection jdbc to java how to use jdbc connection in java java program using jdbc connection how jdbc connection works java jdbc connection example program connection from jdbc java jdbc connection java via connection using jdbc simple jdbc connection in java jdbc java connection how to setup jdbc connection in java syntax of jdbc connection create a connection class for jdbc java jdbc make connection to database connection jdbc java jdbc connection java example of jdbc connection in java connection statement in jdbc make connection jdbc jdbc connection program in java jdbc connection java example setting up jdbc connection in java what is JDBC connection jdbc establish connection in java jdbc establish connection steps in jdbc connection connection with jdbc in java simple jdbc connection connection jdbc setup java jdbc how to create a jdbc connection in java steps for jdbc connection what is a jdbc connection jdbc connection in java example swing jdbc connection in java example java jdbc connection example connection java jdbc example use JDBC connection in Java jdbc connection how create a jdbc connection in java create jdbc connection jdbc connection in java example proper steps of jdbc connection to oracle connection in jdbc jdbc java connect jdbc connection tutorial steps involved in the process of connecting to a database and executing a query in java steps (in proper order) involved in the process of connecting to a database and executing a query steps involved in jdbc connection The steps involved in JDBC connectivity Execute Query Connection Loading Driver Option 4: All of the mentioned how to Create a Connection class and return the connection. Take url, username, password and establish a jdbc connection. Create a Connection class and return the connection. Take url, username, password and establish a jdbc connection. jdbc connection steps in java jdbc fundamentals in java clean all the steps used for establishing string connection in database What are the steps involved in establishing a JDBC connection steps involded in jdbc connection What are the steps involved in establishing a JDBC connection? jdbc fundamentals how do you connect with jdbc Explain the steps required to establish JDBC connection? jdbc drivermanager getconnection stepsfollow in jdbc Explain the steps of JDBC process. Q6. Explain the steps of JDBC process. steps of jdbc creating connection object in java creating connection obejct in java steps to connect database in java java jdbc number connection create a connection to database java java connect to database with password java database connectivity steps jdbc connection with java steps to connect jdbc how does an instance use a db connection in java Explain seven steps to connect to the database in JAVA how to connect database connection in java What are the main steps in java to make JDBC connectivity oracle getcoonnection write the method for establishing a connection in jdbc method for establishing connection of jdbc connection database by obtaining a connection object getting connection from the database five steps to connect any java application using jdbc connection in java java sql database connection java how to use jdbc select the correct to connect oracle with java class.forname jdbc get connection connection java Explain JDBC connectivity steps with any database Explain how connection is established in JDBC. Discuss the steps involved in setting JDBC environment. get database url how to set jdbc url connect database in java java conection class java connection cla setup a jdbc connection what are the steps to connect to the database in java what are the steps to connect database in java connect a db with jdbc Which of these obtains a Connection? Connection.getConnection(url) Driver.getConnection(url) DriverManager.getConnection(url) new Connection(url) 5 steps to connect jdbc How to connect database in java explain the steps. how to connect database jdbc create connection in jdbc create connection on jdbc methods used to obtain a Connection to a database java differe7 basic stepsof JDBC steps involved in jdbc create connection java jdbc steps for jdbc connection in java 5. What are basic steps in a JDBC based database application? JDBC connect Write the JDBC(Java Database Connectivity) process with code snippet how to get jdbc connection in java java.sql create connection jdbc five steps jdbc java 7 steps jdbc connectivity steps how to use jdbc connection steps in javascript jdbc connection steps jdbc connection in java java jdbc Connection java get jdbc connection how to set up jdbc connection in java What is the first step in accessing the database using JDBC? database connection in java What are the steps to connect to a database in java? establishing jdbc connection in java jdbc steps steps of jdbc in java jdbc connection how to connect jdbc how to setup new connection in mysql workbench how to create jdbc connection in java create jsbc connection java create jdbc connection java create jdbc connection in java
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source