Some useful commands for my Distribute Database assignment
- sqlplus
- connect USER_NAME@DB_NAME
- @FileName.sql
- describe DB_NAME
- drop table TABLE_NAME
- spool FILE_NAME
- spool off
- JDBC apply
import java.sql.*;
String sConnect = "jdbc:oracle:thin:@emu.cs.rmit.edu.au:1521:database_name";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection(sConnect, "user", "password");
Statement stmt = con.createStatement();
ResultSet rs = stmt.excuteQuery("select * from Employee");
While (rs.next()) {}
String sEmployee = rs.getString("ENAME");
double nPay = rs.getDouble("SAL");
int iRowsUpdate = stmt.executeUpdate("update pay set sal = sal * 1.1");
rs.close();
stmt.close();
con.close();
posted by isay @ 4:13 PM
