java select database

package main.java.com.study.jdbc.main.dml;


import main.java.com.study.jdbc.util.DBConnection2;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class test3 {

    public static void main(String[] args) {
        Connection connection = DBConnection2.getInstance().getConnection();

        String sql = "select * from study_mst ";

        try {
            PreparedStatement pstmt = connection.prepareStatement(sql); 
            ResultSet rs = pstmt.executeQuery();          

            while(rs.next()) {
                System.out.println("id: " + rs.getInt(1) 
                        + "\t name: " + rs.getString(2)
                        + "\t address: " + rs.getString(3)
                        + "\t age: " + rs.getInt(4));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

결과