public class JDBCDemo {
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:demo";
public static final String DBUSER = "scott";
public static final String DBPASSWORD = "tiger";
public static void main(String[] args) throws Exception {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
String sql = "select empno, ename from emp";
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
int empno = rs.getInt(1);
String ename = rs.getString(2);
System.out.println(empno + "\t" + ename);
}
rs.close();
ps.close();
conn.close();
}
}
|
SELECT EMPNO, ENAME
FROM (SELECT ROWNUM RN, EMPNO, ENAME
FROM (SELECT EMPNO, ENAME
FROM EMP
ORDER BY EMPNO)
WHERE ROWNUM <= 10)
WHERE RN > 5;
|