用你熟悉的语言写一个连接ORACLE数据库的程序,能够完成修改和查询工作
参考解答:
public void testJdbc() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:服务名", "用户名", "密码");
String sql = "SELECT empno, ename FROM emp";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
}
rs.close();
ps.close();
sql = "UPDATE emp SET sal=? WHERE empno=?";
ps = conn.prepareStatement(sql);
ps.setDouble(1, 3000.0);
ps.setLong(2, 7369);
int rows = ps.executeUpdate();
System.out.println(rows + " rows affected.");
ps.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception e1) {
}
}
}