[테스트 환경]

• Database: MySQL 5.5
• Java : 1.6
• OS : Windows 7

[소스 코드]

try {

    String url = "jdbc:mysql://localhost:3306/testDB?characterEncoding=utf8";
    String userName = "coozplz";
    String userPass = "test";
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection(url, userName, userPass);


    String sql = "select * from test";

    PreparedStatement psmt = conn.prepareStatement(sql);
    ResultSet rs = psmt.executeQuery();


    if(rs != null) {
        System.out.println("Result Set is Null");
        return;
    }


    String[] columnNames = null;
    ResultSetMetaData rsmd = rs.getMetaData();


     // Get Column Count
    int columnCount = rsmd.getColumnCount(); 


    // Initialize array for Column Names
    columnNames = new String[columnCount]; 


    for(int i=1; i<=columnCount; i++) {
        // Put column name into array
        columnNames[i-1] = rsmd.getColumnName(i); 
    }


    while(rs.next()) {
        for (String columnName: columnNames) {
            // Print Column Name and value 
            System.out.println(columnName+" "+rs.getObject(columnName)); 
        }
    }
} catch (ClassNotFoundException e) {

    e.printStackTrace();

} catch (SQLException e) {

    // TODO Auto-generated catch block
    e.printStackTrace();
}