, :
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();
}}