import java.sql.*;
public class test {
public static void main(String[] args) {
// add();
Connection conn = null;
String strURL = "jdbc:oracle:thin:@127.0.0.1:1521:DKBE";
String strUSER = "hero";
String strPWD = "hero";
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(strURL, strUSER, strPWD);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from dept2");
while (rs.next()) {
System.out.println(rs.getInt(1) + " " + rs.getString("DNAME"));
}
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
static void add() {
Connection conn = null;
String strURL = "jdbc:oracle:thin:@localhost:1521:MAX";
String strUSER = "MAX";
String strPWD = "MAX";
PreparedStatement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(strURL, strUSER, strPWD);
stmt = conn
.prepareStatement("insert into dept2(deptno, dname, loc) values (?, ?, ?)");
stmt.setInt(1, 88);
stmt.setString(2, "name88");
stmt.setString(3, "loc88");
int i = stmt.executeUpdate();
if (i == 1) {
System.out.println("???��??");
}
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}