完整例子

来源:互联网 发布:淘宝商城一号店 编辑:程序博客网 时间:2024/05/17 06:27

 class ResultSetTest
{
        public static void main(String[] args)throws Exception
        {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@10.10.3.237:1521:                                                tarena","userName","pwd");
                Statement st=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
                ResultSet rs=st.executeQuery("select * from users");
                System.out.println("test");
                while(rs.next()){
                        System.out.print(“id:”+rs.getInt(1));
                        System.out.print(“name:”+rs.getString(2));
                        System.out.print(“age:”+rs.getInt(3));
                }
        }
}

原创粉丝点击