import java.sql.*;

public class FirstExample {

    static final String JDBC_DRIVER = "org.mariadb.jdbc.Driver";

    static final String DB_URL = "jdbc:mariadb://localhost:3306/Test";

//  static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  

//  static final String DB_URL = "jdbc:mysql://localhost:3306/WearPdm";

    static final String USER = "test";

    static final String PASS = "test";

    static final String _SQL =

        "insert into alerte ( alerte_code, alerte_libelle_court, alerte_libelle_long )" +

        "select  TMP.alerte_code, TMP.alerte_libelle_court, TMP.alerte_libelle_long " +

        "from    ( " +

        "select  ? alerte_code, ? alerte_libelle_court, ? alerte_libelle_long " +

        "from   dual " +

        ") TMP";

    public static void main(String[] args) {

        Connection conn = null;

        PreparedStatement stmt = null;

        try {

            Class.forName(JDBC_DRIVER);

            conn = DriverManager.getConnection(DB_URL,USER,PASS);

            stmt = conn.prepareStatement(_SQL);

            stmt.setString(1, "test");

            stmt.setString(2, "test");

            stmt.setString(3, "test");

            stmt.executeUpdate();

            stmt.close();

            conn.close();

        } catch(SQLException se) {

            se.printStackTrace();

        } catch(Exception e) {

            e.printStackTrace();

        } finally {

            try {

                if(stmt!=null) stmt.close();

            } catch(SQLException se2){ }

            try {

                if(conn!=null) conn.close();

            } catch(SQLException se) {

                se.printStackTrace();

            }

        }

    }

}