insert.java

private void insertDataIsa(ResultSet resultSet) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://192.168.24.70:3306/ipd_management", mysqlUsername, mysqlPassword);

            String query = String.format("INSERT INTO criteria(criteria_code, criteria_id, criteria_name, criteria_query, "
                    + "criteria_keyword, criteria_type, criteria_report_type,criteria_media, criteria_media_tag, "
                    + "criteria_status, criteria_access, "
                    + "account_id, criteria_data, analysis_network) "
                    + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE criteria_code=?");
            PreparedStatement statement = con.prepareStatement(query);
            statement.setString(1, resultSet.getString(1));
            statement.setString(2, resultSet.getString(2));
            statement.setString(3, resultSet.getString(3));
            statement.setString(4, resultSet.getString(4));
            statement.setString(5, resultSet.getString(5));
            statement.setInt(6, resultSet.getInt(6));
            statement.setInt(7, resultSet.getInt(7));
            statement.setInt(8, resultSet.getInt(8));
            statement.setString(9, resultSet.getString(9));
            statement.setInt(10, 1);
            statement.setInt(11, 1);
            statement.setInt(12, 1);
            statement.setInt(13, 0);
            statement.setInt(14, 0);
            statement.setString(15, resultSet.getString(1));

            statement.executeUpdate();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Mysql Connection error insert!");
        }
    }