jdbc driver 적용

org.mariadb.jdbc.Driver 오류가 발생할때 라이브러리를 적용하면 쉽게 해결할 수 있습니다.

인텔리제이(IntelliJ) 해결법
1. Settings - ProjectStructure - ProjectSettings - Modules 
   - Dependencies에 들어갑니다.
하단에 있는 +를 눌러

mariadb jar를 선택하고 OK합니다.

Apply 하고 OK 눌러서 나옵니다.

Main 메소드가 있는 곳에서 우클릭하고 Run하면 작동합니다.

MariaDB의 JDBC 연결
http://www.gisdeveloper.co.kr/?p=4858
MySQL에서 파생된 MariaDB를 프로젝트에 사용하고 있는데요. 이 MariaDB를 Java에서 연결해 필요한 데이터를 조회하기 위해 JDBC를 사용하는 코드를 정리해 둡니다.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class MainEntry {
    public static void main(String[] args) {
        Connection con = null;
        PreparedStatement pstmt = null;   
        ResultSet rs = null;
        try {
            Class.forName("org.mariadb.jdbc.Driver");
            
            con = DriverManager.getConnection(
                "jdbc:mariadb://100.100.100.7:3306/dbname",
                "userId",
                "password");
                        
            pstmt = con.prepareStatement("select * from his_bus_voltage");
            
            rs = pstmt.executeQuery();
            
            while(rs.next()) {
                //.
            }
        } catch(Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if(rs != null) {
                    rs.close(); // 선택 사항
                }
                
                if(pstmt != null) {
                    pstmt.close(); // 선택사항이지만 호출 추천
                }
            
                if(con != null) {
                    con.close(); // 필수 사항
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}
MariaDB의 JDBC 라이브러리는 공식 사이트인 https://downloads.mariadb.org/connector-java/에서 다운로드받았으며, 
이 글을 작성할 때는 mariadb-java-client-2.0.3.jar를 사용하였습니다.