حرکت بین رکورد ها

[agusta.ada]

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class ConnectB {

    public static void main(String[] args) {

        Connection conn = null;

        String dbName = "school";

        String serverip="localhost";

        String serverport="1433";

        String url = "jdbc:sqlserver://"+serverip+"\\SQLEXPRESS:"+serverport+";databaseName="+dbName+"";

        Statement stmt = null;

        ResultSet result = null;

        String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"  ;

        String databaseUserName = "sa";

        String databasePassword = "123456789";

        try {

            Class.forName(driver).newInstance();

            conn = DriverManager.getConnection(url, databaseUserName, databasePassword);

            stmt = conn.createStatement();

            result = null;

            String name, family;

            result = stmt.executeQuery("select * from Student ");

            

            while (result.next()) {

                name = result.getString("first_name");

                family = result.getString("last_name");

                System.out.println(name+"  "+family);

            }

            conn.close();

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

}