TengFei’s Blog - jdbc– 结果集ResultSet


    // 结果集ResultSet
    @Test
    public void resultSetTest() throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException, IOException {

        // 注册驱动
        Class<?> aClass = Class.forName("com.mysql.jdbc.Driver");
        Driver driver =(Driver) aClass.newInstance();
        DriverManager.registerDriver(driver);
        FileInputStream fileInputStream = new FileInputStream("src/cn/usts/edu/config/db.properties");
        Properties properties = new Properties();
        properties.load(fileInputStream);
        String url=(String) properties.get("url");
        String user=(String) properties.get("user");
        String password=(String) properties.get("password");

        // 建立连接
        Connection connection = DriverManager.getConnection(url, user, password);

        // 执行sql
        String sql ="select * from per";
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery(sql);

        // 获取结果
        while (resultSet.next()){ // 判断有没有下一row行        (列索引从1开始)
            System.out.print("name:"+resultSet.getString(1));
            System.out.print("\tid:"+resultSet.getInt(2));
            System.out.print("\tage:"+resultSet.getInt(3)+"\n");
        }

        // 切断链接
        resultSet.close();
        statement.close();
        connection.close();


    }