import java.sql.*;
import org.junit.Assert;
import org.junit.Test;

public class Main {

@Test
public void test() throws ClassNotFoundException, SQLException {
Class.forName("org.mariadb.jdbc.Driver");
try (Connection connection = DriverManager.getConnection("jdbc:mariadb://localhost/test", "root", "root")) {
try {
connection.prepareStatement("CREATE TABLE table1(column1 int)").execute();
connection.prepareStatement("INSERT INTO table1(column1) VALUES (2)").execute();
try (PreparedStatement ps = connection.prepareStatement("select column1 from table1 limit ?")) {
ps.setInt(1, 20);
ResultSet rs = ps.executeQuery();
while (rs.next())

}
} finally

}
}

}