If you are wondering why I ask, it is because I have numerous different methods all with very similar code (the only difference in the code in each method is what is between the generate resultset comments). I have tried any amount of times to try and shorten this but I am out of ideas. What I have been trying to get is to have the repeating code in the main method (so therefore it won't be repeating), and then to be able to call the resultSet methods from here./** * This is the Main Method. *  * @param args */public static void main(String[] args) {// call method resultSet1resultSet1();}/** * This Method shows Resultset1. */public static void resultSet1() {// declare my variables and assign values to themString url = jdbc:mysql://lamp.eeecs.qub.ac.uk/mmeaklim01;Connection connection;// declare my prepared statement and assign a value to itPreparedStatement updateSalaries;String updateSalariesString = update Staff_Members set salary = ? where idStaff = ?;// declare two arrays and put values in themint[] staffSalaries = { 45000, 40000, 35000, 42000, 29000, 29500,        47000, 34000, 30500, 42000, 44500, 41000, 29500, 29500, 30000,        34000 };String[] staffIDs = { M001, M002, M003, M004, M005, M006,        M007, M008, M009, M010, M011, M012, M013, M014,        M015, M016 };// try catch block to handle exceptionstry {    // connect to the database    connection = DriverManager.getConnection(url, mmeaklim01,            xxx);    // start the update    updateSalaries = connection.prepareStatement(updateSalariesString);    // declare my variable and assign a value to it    int length = staffIDs.length;    // for loop to take the values from my two arrays and use them to    // update the Staff_Members table    for (int loop = 0; loop < length; loop++) {        updateSalaries.setInt(1, staffSalaries[loop]);        updateSalaries.setString(2, staffIDs[loop]);        updateSalaries.executeUpdate();    }    // generate resultset1    ResultSet resultSet1 = updateSalaries            .executeQuery(SELECT name, position, salary FROM Staff_Members);    // while loop    System.out.println(Resultset 1\n);    System.out.println(Name\t\tPosition\tSalary);    System.out.println(----------\t----------\t----------);    while (resultSet1.next()) {        String name = resultSet1.getString(name);        String position = resultSet1.getString(position);        int salary = resultSet1.getInt(salary);        // print out resultset1        System.out.println(name + \t + position + \t + salary                + \t);    } // end of resultset1    // close the update    updateSalaries.close();    // close the connection    connection.close();    // add a linebreak    System.out.println();    // output a message to the user to indicate that the program has    // executed correctly    System.out.println(The Method has executed correctly.);} catch (SQLException sqlException) {    // catch block    System.out.println(Error:  + sqlException.getMessage());}}And all I want the resultSet Methods to have, ideally, would be:    // generate resultset1    ResultSet resultSet1 = updateSalaries            .executeQuery(SELECT name, position, salary FROM Staff_Members);    // while loop    System.out.println(Resultset 1\n);    System.out.println(Name\t\tPosition\tSalary);    System.out.println(----------\t----------\t----------);    while (resultSet1.next()) {        String name = resultSet1.getString(name);        String position = resultSet1.getString(position);        int salary = resultSet1.getInt(salary);        // print out resultset1        System.out.println(name + \t + position + \t + salary                + \t);    } // end of resultset1I'm sure there is probably an easy way around this but I can't seem to figure it out.
JDBC connection and retrieval of info
java;beginner;mysql;jdbc