It this part:
- Add myapp
- Add mariadb library
Add myapp
- under folder <home>/webapps/ add folder myapp
- under folder <home>/webapps/myapp/ add folder WEB-INF
- optional, at folder <home>/webapp/myapp> write index.html e.g
<!DOCTYPE html>
<html lang="en">
<body>
<h1>Hello, World!</h1>
</body>
</html>Restart your jakarta tomcat, and myapp appear in list of application. Test your index.html, url http://localhost:8080/myapp/.
Add mariadb
- Under folder <home>/webapps/myapp/WEB_INF, create folder lib.
- download jconnect from https://mariadb.org/connector-java/all-releases/, and put it in <home>/webapps/myapp/WEB_INF/lib, i.e. <home>/webapps/myapp/WEB-INF/lib/mariadb-java-client-3.5.3.jar
Under folder <home>/webapps/myapp/ write test.jsp
<%
try {
Class.forName("org.mariadb.jdbc.Driver");
out.println("MariaDB JDBC driver FOUND");
} catch (ClassNotFoundException e) {
out.println("MariaDB JDBC driver NOT FOUND");
}
%>
restart your jakarta tomcat and test it http://localhost:8080/myapp/test.jsp.
if you have mariadb running, you can extend test.jsp to this
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%
try {
Class.forName("org.mariadb.jdbc.Driver");
out.println("MariaDB JDBC driver FOUND<br>");
Connection conn = DriverManager.getConnection(
"jdbc:mariadb://localhost:3306/mydb", // change to your db name
"admin", // change to your user
"admin" // change to your password
);
out.println("Connected to MariaDB!<br>");
conn.close();
} catch (ClassNotFoundException e) {
out.println("MariaDB JDBC driver NOT FOUND<br>");
out.println(e);
} catch (Exception e) {
out.println("Database connection FAILED<br>");
out.println(e);
}
%>
