package fr.su.commande.service.business.impl;

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

import org.junit.Test;

public class JsonTest {

    // private static final String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
    // private static final String DB_CONNECTION = "jdbc:oracle:thin:@localhost:1521:MKYONG";
    // private static final String DB_USER = "user";
    // private static final String DB_PASSWORD = "password";
    private static final String DB_DRIVER = "com.ibm.as400.access.AS400JDBCDriver";
    private static final String DB_CONNECTION = "jdbc:as400://u3reca83;date format=iso;prompt=false;naming=system;trace=false;";
    private static final String DB_USER = "smetivie";
    private static final String DB_PASSWORD = "superu";

    public JsonTest() {
        super();
    }

    public static void main(String[] argv) {

    }

    @Test
    public void selectRecordsFromTable() throws SQLException {

        Connection dbConnection = null;
        PreparedStatement preparedStatement = null;

        String selectSQL = "SELECT * FROM $tableName";
        String query2 = "SELECT * FROM TABLE (MANLIB.JSONSME1('DMOREAU')) a";
        String maTable = "MANLIB.SM";

        try {
            dbConnection = getDBConnection();

            String query = selectSQL.replace("$tableName", maTable);
            preparedStatement = dbConnection.prepareStatement(query2);
            // preparedStatement.setString(1, maTable);

            // execute select SQL stetement
            ResultSet rs = preparedStatement.executeQuery();

            while (rs.next()) {

                String json = rs.getString("DONNEE");

                System.out.println("json : " + json);

            }

        } catch (SQLException e) {

            System.out.println(e.getMessage());

        } finally {

            if (preparedStatement != null) {
                preparedStatement.close();
            }

            if (dbConnection != null) {
                dbConnection.close();
            }

        }

    }

    private static Connection getDBConnection() {

        Connection dbConnection = null;

        try {

            Class.forName(DB_DRIVER);

        } catch (ClassNotFoundException e) {

            System.out.println(e.getMessage());

        }

        try {

            dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
            return dbConnection;

        } catch (SQLException e) {

            System.out.println(e.getMessage());

        }

        return dbConnection;

    }
}