.


:




:

































 

 

 

 


Oracle




, :

1. Import Packages

2. Register the JDBC Drivers

3. Open a Connection to a Database

4. Create a Statement Object

5. Execute a Query and Return a Result Set Object

6. Process the Result Set

7. Close the Result Set and Statement Objects

8. Make Changes to the Database

9. Commit Changes

10. Close the Connection

1.

import java.sql.*; // JDBC

import oracle.jdbc.driver.*; // JDBC Oracle import oracle.sql.*; // SQL Oracle

classpath JDBC ([ORACLE_HOME\jdbs\lib\zip-]). 2

:

1.

2. javac -classpath ".; ORACLE_HOME\jdbs\lib\classes12.zip; ORACLE_HOME\jdbs\lib\nls_charset12.zip"

2.

:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

3.

getConnection() DriverManager, Connection.

getConnection(String URL, String user, String password); URL :

jdbc:oracle:<drivertype>:@<database>.

,

DriverManager.getConnection ("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");

DriverManager.getConnection("jdbc:oracle:oci8:@(description=(address=(host=myhost)(protocol=tcp)(port=1521)(connect_data=(sid=orcl)))","scott","tiger");

Connection conn = DriverManager.getConnection

("jdbc:oracle:oci8:@mics", "stud01", "stud01");

4.

Statement createStatement

Statement stmt = conn.createStatement();

5.

executeQuery Statement. ResultSet, .

ResultSet rset = stmt.executeQuery ("SELECT ename FROM emp");

6.

ResultSet next() , .

getXXX() ResultSet,

XXX Java.

while (rset.next())

System.out.println (rset.getString(1));

7.

Statement ResultSet close().

finalizer(), close().

rset ResultSet, stmt Statement,

rset.close();

stmt.close();

8.

Insert Update PreparedStatement. .

PreparedStatement setXXX() PreparedStatement.

,

PreparedStatement pstmt =conn.prepareStatement ("insert into EMP (EMPNO, ENAME) values (?,?)");

// Add LESLIE as employee number 1500

pstmt.setInt (1, 1500); // The first? is for EMPNO

pstmt.setString (2, "LESLIE"); // The second? is for ENAME

Do the insertion pstmt.execute ();

9.

, DML (Insert, Update, Delete) . conn.setAutoCommit(false);

, commit rollback:

conn.commit() conn.rollback()

commit DDL.

10.

conn.close()

Oracle

import java.sql.*; import java.io.*; import java.awt.*; class JdbcTest {

 

public static void main (String args []) throws SQLException { // Load Oracle driver

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@myhost:1521:ORCL","scott", "tiger"); // Query the employee names

Statement stmt = conn.createStatement ();

ResultSet rset = stmt.executeQuery ("SELECT ename FROM emp");

while (rset.next ())

System.out.println (rset.getString (1));

//close the result set, statement, and the connection

rset.close(); stmt.close(); conn.close();

}}

 





:


: 2018-10-18; !; : 210 |


:

:

, .
==> ...

815 - | 653 -


© 2015-2024 lektsii.org - -

: 0.015 .