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


public class MysqlHelper {
    private static final String dbDriver = "com.mysql.jdbc.Driver";
    private static final String dbUrl = "jdbc:mysql://remote.mysql:3306/";
    private static final String dbDatabase = "dbDatabase";
    private static final String dbUser = "dbUser";
    private static final String dbPassword = "dbPassword";
    private static final String characterEncoding = "utf-8";
    private Connection connection = null;

    public MysqlHelper() {
        try {
            Class.forName(dbDriver);
            connection = DriverManager.getConnection(dbUrl + dbDatabase + "?characterEncoding=utf-8&useUnicode=true", dbUser, dbPassword);
            
            String sqlCharset = "SET NAMES utf8 COLLATE utf8_general_ci";
            Statement st = connection.createStatement();
            st.executeQuery(sqlCharset);
            st.executeQuery("SET CHARACTER SET utf8");
            
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();    
        }
        
    }
    
    public Connection getConnection() {
        return connection;
    }
}

public static void exportUnits() {
        final String tableName = "TOF_CRITERIA";
        final String tableCountry = "TOF_DESIGNATIONS";
        final String tableDescriptions = "TOF_DES_TEXTS";
        final String mysqlTable = "tof_units";

        final String sqlDropTable = "DROP TABLE IF EXISTS " + mysqlTable;
        final String sqlCreateTable = " CREATE TABLE IF NOT EXISTS " + mysqlTable + " (" +
                "id int(11) PRIMARY KEY," +
                "text varchar(100)" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8";

        Statement st;
        Statement mysqlSt;
        try {

            System.out.println("Get units");
            st = connection.createStatement();
            String query = "SELECT DISTINCT CRI_UNIT_DES_ID, TEX_TEXT " +
                    " FROM "  + tableName + ", " + tableCountry + ", " + tableDescriptions +
                    " WHERE  DES_LNG_ID = " + langId + " AND DES_TEX_ID = TEX_ID AND CRI_UNIT_DES_ID = DES_ID";
            
            ResultSet result = st.executeQuery(query);

            ResultSetMetaData metaResult = result.getMetaData();
            int numberOfColumns = metaResult.getColumnCount();

            mysqlSt = mysqlConnection.createStatement();
            mysqlSt.executeUpdate(sqlDropTable);

            mysqlSt = mysqlConnection.createStatement();
            mysqlSt.executeUpdate(sqlCreateTable);

            exportTableData(result, numberOfColumns, mysqlTable);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

select a.ART_ID
from TecDoc.TOF_ART_LOOKUP al
    inner join TecDoc.TOF_ARTICLES a on a.ART_ID = al.ARL_ART_ID
    inner join TecDoc.TOF_SUPPLIERS s on s.SUP_ID = a.ART_SUP_ID
where al.ARL_SEARCH_NUMBER = 'Номер' and s.SUP_BRAND = 'Виробник' and al.ARL_KIND <> 3;