package com.work.support.jdbc;

import org.mariadb.jdbc.MariaDbDataSource;

import java.sql.Connection;
import java.sql.SQLException;

public class MariadbJdbcTest {

    private static Connection fetchConnection() throws SQLException {
        String username = "****" ;
        String password = "***************";
        String url = "jdbc:mariadb://*.*.*.*:3306/***" ;

        var dataSource = new MariaDbDataSource(url);
        var conn = dataSource.getConnection(username,password);
        var isAutoCommit = conn.getAutoCommit();
        System.out.println("before autoCommit: "+isAutoCommit);
        conn.setAutoCommit(false);
        isAutoCommit = conn.getAutoCommit();
        System.out.println("after autoCommit: "+isAutoCommit);
        return conn;
    }

    public static void main(String[] arg) throws SQLException {
        var conn = fetchConnection();
        var stmt = conn.createStatement();
        var rs = stmt.executeQuery("SHOW VARIABLES LIKE 'autocommit'");
        while(rs.next()) {
            System.out.println("val: "+rs.getString(1)+"-val2:"+rs.getString(2));
        }
    }




}