MyEclipse connecting Oracle databases in the Java language

Java connection to Oracle database under MyEclipse

First step: New Java Project.

Fill in the project name, other settings by default, click Done.

Create a new Java class, fill in the package name and class name, tick public static void main (String [] args), and click Done.

Step Two: Add Oracle Drive.

Under Libraries, click Add Extra Jar Package

Click OK after adding

At this point the project directory has been driven.

Step three: Write code tests

Add the following code to the Orcltest.java file:

Package OPERATEORCL;

import java.sql.Connection;

import Java.sql.DriverManager;

import Java.sql.ResultSet;

import java.sql.Statement;

Public class orcltest {

Public Static void Main (string[] args) {

TODO auto-generated Method stub

Basedao Basedao = new Basedao ();

Connection con = basedao.getconnection ();

if (con = = null) {

System. out. println ("Oracle database Connection failed");

} Else {

System. out. println ("Oracle database Connection succeeded");

}

}

}

class Basedao {

Private Static String URL = "Jdbc:oracle:thin: @localhost: 1521:ORCL";

Private Static String User = "C # #scott";

Private Static String Password = "Tiger";

Public Connection Conn;

Public Static Statement PS;

Public Static ResultSet rs;

Ways to connect to a database

Public Connection getconnection () {

Try {

Initializing the driver package

Class. forname ("Oracle.jdbc.OracleDriver");

According to the database connection character, name, password to Conn

System. out. println ("Start trying to connect to the database!") ");

conn = DriverManager. getconnection (URL, user, password);

} catch (Exception e) {

E.printstacktrace ();

}

return Conn;

}

}

Click Run to see the output: The Oracle connection is successful.

MyEclipse connecting Oracle databases in the Java language