Java Servlet JSP

Create Project Java WebApp

Using ctrl + shift + p select Maven: New Project and Select an archetype: maven-archetype-webapp

mvn archetype:generate -DgroupId=ceb.net.vn -DartifactId=cms -DarchetypeGroupId=org.apache.maven.archetypes -DarchetypeArtifactId=maven-archetype-webapp -DarchetypeVersion=1.4 -DinteractiveMode=false

Jdbc SQL Server

<!-- https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc -->
<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>12.8.1.jre11</version>
</dependency>

Manven Jdbc Mysql

<!-- https://mvnrepository.com/artifact/com.mysql/mysql-connector-j -->
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>9.0.0</version>
</dependency>

Maven Servlet jakarta

<!-- https://mvnrepository.com/artifact/jakarta.servlet/jakarta.servlet-api -->
<dependency>
    <groupId>jakarta.servlet</groupId>
    <artifactId>jakarta.servlet-api</artifactId>
    <version>6.1.0</version>
    <scope>provided</scope>
</dependency>

Maven jstl

<!-- https://mvnrepository.com/artifact/jakarta.servlet.jsp.jstl/jakarta.servlet.jsp.jstl-api -->
<dependency>
    <groupId>jakarta.servlet.jsp.jstl</groupId>
    <artifactId>jakarta.servlet.jsp.jstl-api</artifactId>
    <version>3.0.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.glassfish.web/jakarta.servlet.jsp.jstl -->
<dependency>
    <groupId>org.glassfish.web</groupId>
    <artifactId>jakarta.servlet.jsp.jstl</artifactId>
    <version>3.0.1</version>
</dependency>

Using Jstl in jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

Connection String SQL Server

jdbc:sqlserver://localhost:1433;database=WebStore;user=sa;password=123;trustServerCertificate=true;

Connection String Mysql

jdbc:mysql://localhost:3306/WebStore

Config web.xml

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
         http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         version="3.1">
  <display-name>ceb.net.vn</display-name>
  <servlet>
    <servlet-name>CategoryController</servlet-name>
    <servlet-class>CategoryController</servlet-class>
  </servlet>
  <servlet-mapping>
      <servlet-name>CategoryController</servlet-name>
      <url-pattern>/category</url-pattern>
  </servlet-mapping>
</web-app>

Plugin maven

<plugin>
    <groupId>org.eclipse.jetty</groupId>
    <artifactId>jetty-maven-plugin</artifactId>
    <version>11.0.18</version>
    <configuration>
    <scanIntervalSeconds>3</scanIntervalSeconds>
    <reload>automatic</reload>
    </configuration>
</plugin>

Run maven jetty Server

mvn jetty:run

JSTL If

<c:if test="${condition}">
    ...
</c:if>

JSTL choose

<c:choose>
    <c:when test="${condition1}">
        ...
    </c:when>
    <c:when test="${condition2}">
        ...
    </c:when>
    <c:otherwise>
        ...
    </c:otherwise>
</c:choose>

JSTL token

<c:forTokens items = "Zara,nuha,roshy" delims = "," var = "name">
    <c:out value = "${name}"/><p>
</c:forTokens>

<c:forEach var = "i" begin = "1" end = "5">
    Item <c:out value = "${i}"/><p>
</c:forEach>