JDBC操作数据库有哪些步骤呢？

加载驱动

    Class.forName("oracle.jdbc.driver.OracleDriver");

创建连接

    Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "username", "pwd");

创建语句

    PreparedStatement ps = con.prepareStatement("select * from user where sal between ? and ?");
    ps.setInt(1, 888);
    ps.setInt(2, 9999);

执行语句

    ResultSet rs = ps.executeQuery();

处理结果

    while(rs.next()) {
        System.out.println(rs.getInt("userage") + " - " + rs.getString("username"));
    }

关闭资源

    finally {
        if(con != null) {
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }