package dsu.cs;

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

public class MemberList {

    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
            conn = DriverManager.getConnection(
            		"jdbc:mysql://localhost/studydb?useSSL=false&serverTimezone=UTC",
                    "study",
                    "study");
            stmt=conn.createStatement();
            rs=stmt.executeQuery("SELECT MNO, MNAME, EMAIL, CRE_DATE from MEMBERS ORDER BY MNO ASC");
            while (rs.next())
            {
                System.out.println(
                		rs.getInt("MNO")+",\t"
                		+rs.getString("MNAME")+",\t"
                		+rs.getString("EMAIL")+",\t"
                );
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try { if (null!=rs) rs.close(); } catch (Exception e) {}
            try { if (null!=stmt) stmt.close(); } catch (Exception e) {}
            try { if (null!=conn) conn.close(); } catch (Exception e) {}
        }
    }
}