package com.ns;

/*
Date                Author                 	Changes
----------------    -------------------		-------------------
Jul 2, 2020        BSarkar				    Created
*/

/***************************************************************/

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Properties;

/***************************************************************/

/**
 * 
 */
public class Sample
{
    /**
     * main
     *
     * @param args
     */
    public static void main(String[] args)
    {
        Properties credentials = new Properties();
        credentials.setProperty("user", "abs");
        credentials.setProperty("password", "xxxxxxx");
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MMM-dd HH:mm:ss");
        
        //MySQL Driver
        {
            try(Connection con = new com.mysql.jdbc.Driver().connect("jdbc:mysql://localhost:3310/safenet?useUnicode=true&characterEncoding=UTF-8&jdbcCompliantTruncation=false&zeroDateTimeBehavior=convertToNull", credentials))
            {
                try(Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select now()")) 
                {
                    if (rs.next())
                    {
                        System.out.printf("MySQL Date Returned: %s\n", sdf.format(rs.getDate(1)));  
                    }
                }
            }
            catch (SQLException e) 
            {
                e.printStackTrace();
            }
        }

        //MariaDB Driver
        {
            try(Connection con = new org.mariadb.jdbc.Driver().connect("jdbc:mariadb://localhost:3308/safenet?useUnicode=true&characterEncoding=UTF-8&jdbcCompliantTruncation=false&zeroDateTimeBehavior=convertToNull", credentials))
            {
                try(Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select now()")) 
                {
                    if (rs.next())
                    {
                        System.out.printf("MariaDB Date Returned: %s\n", sdf.format(rs.getDate(1)));  
                    }
                }
            }
            catch (SQLException e) 
            {
                e.printStackTrace();
            }
        }
    }

}