import java.sql.*; class create {
public static void main (String args []) throws SQLException {
try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:zsi_jerzy/haslo@sla b2:1521:lab2");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("CREATE TABLE emp2 AS SELECT * FROM emp
");
rset.close(); stmt.close(); conn.close();
} catch (SQLException e) {
System.err.println("Blad Oracle: "+ e.getErrorCode() + "" + e.getMessage()) ;
} } }
Mar 16, 07 1:08
create.java
Page 1/1
import java.sql.*; class dbaccess {
public static void main (String args []) throws SQLException {
try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:zsi_jerzy/haslo@sla b2:1521:lab2");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION"); while (rset.next()) System.out.println(rset.getString(1)); // kol 1 rset.close(); stmt.close(); conn.close(); } catch (SQLException e) {
System.err.println("Blad Oracle: "+ e.getErrorCode() + e.getMessage()); }
} }
Mar 16, 07 1:08
dbaccess.java
Page 1/1
import java.sql.*; class emp {
public static void main (String args []) throws SQLException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@slab2:1521:lab2", "zsi_jerzy", "haslo");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select * from emp"); ResultSetMetaData rsmd = rset.getMetaData(); int i; for (i=1;i<=rsmd.getColumnCount();i++) { System.out.print(rsmd.getColumnName(i)+""); } System.out.println(); while (rset.next()) { for (i=1;i<=rsmd.getColumnCount();i++) { System.out.print(rset.getString(i)+""); } System.out.println(); } rset.close(); stmt.close(); conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod + e.getMessage()); }
} }
Mar 16, 07 1:08
emp.java
Page 1/1
import java.sql.*; class insert {
public static void main (String args []) throws SQLException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@slab2:1521:lab2", "zsi_jerzy", "haslo");
String q1 = "SELECT empno, ename FROM emp WHERE empno = ?" ; PreparedStatement pstmt1 = conn.prepareStatement(q1); pstmt1.setInt(1, 100);
String q2 = "INSERT INTO emp (empno, ename, sal) VALUES (?,?,?)"; PreparedStatement pstmt2 = conn.prepareStatement(q2); ResultSet rset = pstmt1.executeQuery();
if (rset.next()) {
System.out.println("Istnieje pracownik o nr " + 100 +" jego nazwisko to " + rset.getString(2)); rset.close(); } else { pstmt2.setInt(1, 100); pstmt2.setString(2, "Kowalski"); pstmt2.setFloat(3, 2500f); pstmt2.executeUpdate(); } pstmt1.close(); pstmt2.close(); conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod +"" + e.getMessage()); }
} }
Mar 16, 07 1:08
insert.java
Page 1/1
import java.sql.*; import java.io.*; class list_dept {
public static void main (String args []) throws SQLException, IOException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@slab2:1521:lab2", "zsi_jerzy", "haslo");
String q = "SELECT * FROM emp WHERE deptno = ?" ; PreparedStatement pstmt = conn.prepareStatement(q); System.out.print("Podaj nr oddzialu nr=");
InputStreamReader istr =
new InputStreamReader(System.in); BufferedReader bufr =new BufferedReader(istr); int nr=0;
try {
String linia = bufr.readLine(); nr = Integer.parseInt(linia);
}
catch(IOException e){}
catch(NumberFormatException ne){
System.out.println("Nie podano oddzialu, wybieram nr=10"); nr=10;
}
pstmt.setInt(1, nr);
ResultSet rset = pstmt.executeQuery(); ResultSetMetaData rsmd = rset.getMetaData(); int i; for (i=1;i<=rsmd.getColumnCount();i++) { System.out.print(rsmd.getColumnName(i)+""); } System.out.println(); while (rset.next()) { for (i=1;i<=rsmd.getColumnCount();i++) { System.out.print(rset.getString(i)+""); } System.out.println(); } pstmt.close(); conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod +"" + e.getMessage()); }
} }
Mar 16, 07 1:09
list_dept.java
Page 1/1
import java.sql.*; import oracle.sql.*;
import oracle.jdbc.driver.*; class rowid {
public static void main (String args []) throws SQLException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@slab2:1521:lab2", "zsi_jerzy", "haslo");
String q1 = "SELECT rowid FROM emp WHERE job = ’ANALYST’" ; PreparedStatement pstmt1 = conn.prepareStatement(q1); ResultSet rset = pstmt1.executeQuery();
ResultSetMetaData rsmd = rset.getMetaData(); int i; while (rset.next()) { for (i=1;i<=rsmd.getColumnCount();i++) { System.out.print(rset.getString(i)+""); } System.out.println(); } rset = pstmt1.executeQuery();
String q2 = "DELETE FROM emp WHERE rowid = ?" ;
PreparedStatement pstmt2 = conn.prepareStatement(q2); while (rset.next()) {
oracle.sql.ROWID r_id = ((OracleResultSet)rset).getROWID(1); ((OraclePreparedStatement)pstmt2).setROWID (1, r_id); pstmt2.executeUpdate(); } pstmt1.close(); pstmt2.close(); conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod +"" + e.getMessage()); }
} }
Mar 16, 07 1:09
rowid.java
Page 1/1
import java.sql.*; class select {
public static void main (String args []) throws SQLException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@slab2:1521:lab2", "zsi_jerzy", "haslo");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select empno, ename, job, sal, deptno from emp"); String s="";
while (rset.next()) {
s += rset.getInt(1)+ ""+ rset.getString(2)+ ""+ rset.getString(3) + ""+rset.getFloat(4)+ "" +rset.getInt(5)+ "\n"; } System.out.println(s); rset.close(); stmt.close(); conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod + ""+ e.getMessage()); }
} }
Mar 16, 07 1:09
select.java
Page 1/1
import java.sql.*;
import oracle.jdbc.driver.*; import oracle.sql.*;
class select_oci {
public static void main (String args []) throws SQLException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:@lab2", "zsi_jerz y", "haslo");
Statement stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery("select empno, ename, job, sal, deptno from emp"); String s="";
while (rset.next()) {
s += rset.getInt(1)+ ""+ rset.getString(2)+ ""+ rset.getString(3) + ""+rset.getFloat(4)+ "" +rset.getInt(5)+ "\n"; } System.out.println(s); rset.close(); stmt.close(); conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod + ""+ e.getMessage()); }
} }
Mar 16, 07 1:09
select_oci.java
Page 1/1
import java.sql.*; class transakcja {
public static void main (String args []) throws SQLException {
int kod; try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@slab2:1521:lab2", "zsi_jerzy", "haslo");
conn.setAutoCommit(false); //poczatek transakcji String q1 = "INSERT INTO emp (empno, ename, sal) VALUES (?,?,?)"; PreparedStatement pstmt1 = conn.prepareStatement(q1); pstmt1.setInt(1, 100);
pstmt1.setString(2, "Kowalski"); pstmt1.setFloat(3, 2500f); pstmt1.executeUpdate();
String q2 = "UPDATE emp SET job = ? WHERE empno = 100"; PreparedStatement pstmt2 = conn.prepareStatement(q2); pstmt2.setString(1, "Stolarz");
pstmt2.executeUpdate(); pstmt1.close();
pstmt2.close();
conn.commit(); //koniec transakcji (wycofywanie: conn.rollback() ) conn.close();
} catch (SQLException e) {kod = e.getErrorCode();
System.err.println("Blad Oracle: "+ kod + "" + e.getMessage()); }
} }