测试可滚动的结果

来源：互联网发布：sql outer 编辑：程序博客网时间：2024/06/04 18:37
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class TestScroll {/** * 测试可滚动的结果 * @param args */public static void main(String[] args) {Connection conn = null;Statement stmt = null;ResultSet rs = null;// TODO Auto-generated method stubString driver = "com.mysql.jdbc.Driver";String url = "jdbc:mysql://127.0.0.1:3306/dw";String usr = "root";String psd = "root";try {Class.forName(driver);conn = DriverManager.getConnection(url,usr,psd);stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.TYPE_SCROLL_SENSITIVE);rs = stmt.executeQuery("select * from code_city");rs.next();System.out.println(rs.getInt(1));rs.last();System.out.println(rs.getInt(1));System.out.println(rs.getString(2));System.out.println(rs.isLast());rs.absolute(6);System.out.println(rs.getString(2));rs.previous();System.out.println(rs.getInt(1));System.out.println(rs.getString(2));}catch (ClassNotFoundException e){e.printStackTrace();}catch (SQLException e){e.printStackTrace();}finally{try {if (rs != null){rs.close();rs = null;}if (stmt != null){stmt.close();stmt = null;}if (conn != null){conn.close();conn = null;}}catch (SQLException e){e.printStackTrace();}}}}
0 0