Maria DB Connection By Java

우선은 Maria DB와의 연동에 필요한 connector/client를 구해서 classpath에 등록해 둡니다.

아래의 링크에서 구할 수 있습니다.

https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/

아래서 연결 테스트를 위해 작성한 코드 입니다.

필요한 부분 변경하셔서 사용하면 됩니다.

package whitesquall.db;

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

public class MariaDBConnectionTest {

	static final String JDBC_DRIVER = "org.mariadb.jdbc.Driver";  
	static final String DB_URL = "jdbc:mariadb://[서버주소]:3306/[DB명]";


	static final String USERNAME = "[사용자명]";
	static final String PASSWORD = "[비밀번호]";

	public static void main(String[] args) {
		
		Connection conn = null;
		Statement stmt = null;
		try {
			Class.forName(JDBC_DRIVER);
			conn = DriverManager.getConnection(DB_URL, USERNAME, PASSWORD);

			System.out.println("\n- MariaDB Connection");

			stmt = conn.createStatement();

			String sql;
			sql = "SELECT id, name FROM user";
			ResultSet rs = stmt.executeQuery(sql);

			while (rs.next()) {
				String userId = rs.getString("id");
				String userName = rs.getString("name");

				System.out.print("\n** id : " + userId);
				System.out.print("\n    -> name : " + userName);
			}
			
			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- MariaDB Connection Close");
	}
}