import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Date;



        public class ResultSetTest {

            public static void main(String[] args) {

                try {
                    String myDriver = "com.mysql.jdbc.driver";
                    String myUrl = "Jdbc:mysql:C:\folder\badge\source\box\db\tables\service";

                  Class.forName(myDriver);
                    Connection conn = DriverManager.getConnection(myUrl, "root", "");

                     String query = "SELECT * FROM users";

                     Statement st = conn.createStatement();

                     ResultSet rs = st.executeQuery(query);

                     while (rs.next())
                      {
                        int id = rs.getInt("ORG_ID");
                        int serviceoption = rs.getInt("SERVICE_OPTION_ID");
                        int enumval = rs.getInt("ENUM_VALUE");
                        String loginname = rs.getString("LOGIN_NAME");
                        Date lastupdate = rs.getDate("LAST_UPDATED");



                        System.out.format("%s, %s, %s, %s, %s, %sn", id, serviceoption, enumval, loginname, lastupdate);
                      }
                     st.close();

        } catch (Exception e) {

            System.err.println("Got an exception ");
            System.err.println(e.getMessage());

            e.printStackTrace();

        } finally {


        }
            }

        }