import java.sql.*;

public class mysqlconn1 {

        static final String JDBC_DRIVER = "org.mariadb.jdbc.Driver";
        static final String DB_URL = "jdbc:mysql://slavedb.hhs.local:3306/board";

        static final String USERNAME = "dbadmin";
        static final String PASSWORD = "123456";

        public static void main(String[] args) {
                Connection conn = null;
                Statement stmt = null;
                try{
                        //Class.forName(JDBC_DRIVER);
                        Class.forName("org.mariadb.jdbc.Driver");
                        conn = DriverManager.getConnection(DB_URL,USERNAME,PASSWORD);
                        System.out.println("\n- MySQL Connection");
                        stmt = conn.createStatement();

                        String sql;
                        sql = "SELECT * FROM board";
                        ResultSet rs = stmt.executeQuery(sql);

                        while(rs.next()){
                                String id = rs.getString("id");
                                String content = rs.getString("content");
                                String title = rs.getString("title");

                                System.out.print("\n** id : " + id);
                                System.out.print("\n** content : " + content);
                                System.out.print("\n    -> title: " + title);
                        }
                        rs.close();
                        stmt.close();
                        conn.close();
                }catch(SQLException se1){
                        se1.printStackTrace();
                }catch(Exception ex){
                        ex.printStackTrace();
                }finally{
                        try{
                                if(stmt!=null)
                                        stmt.close();
                        }catch(SQLException se2){
                        }
                        try{
                                if(conn!=null)
                                        conn.close();
                        }catch(SQLException se){
                                se.printStackTrace();
                        }
                }
                System.out.println("\n\n- MySQL Connection Close");
        }
}