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?autoReconnect=true&useSSL=false",
					"study",
					"study");
			stmt=conn.createStatement();
			rs=stmt.executeQuery("SELECT MNO, MNAME, EMAIL, CRE_DATA from MEMBERS ORDER BY MNO ASC");
			while (rs.next())
			{
				System.out.print(rs.getInt("MNO"));
			}
		} 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) {}
		}

	}

}