Lab05 - Spring Framework, SpringBoot [ ver. 2025.04.09.008 ]

           <!-- Spring Framework -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>6.2.5</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>6.2.5</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>6.2.5</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>6.2.5</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>6.2.5</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>6.2.5</version>
        </dependency>
        <!--  Spring Data -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>6.2.5</version>
        </dependency>
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.7.5</version>
        </dependency>
        <!-- AspectJ -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjrt</artifactId>
            <version>1.9.22</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.22</version>
        </dependency>
        <!-- Thymeleaf -->
        <dependency>
            <groupId>org.thymeleaf</groupId>
            <artifactId>thymeleaf</artifactId>
            <version>3.1.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.thymeleaf</groupId>
            <artifactId>thymeleaf-spring6</artifactId>
            <version>3.1.2.RELEASE</version>
        </dependency>
        <!-- JSTL -->
        <dependency>
            <groupId>org.glassfish.web</groupId>
            <artifactId>jakarta.servlet.jsp.jstl</artifactId>
            <version>2.0.0</version>
        </dependency>		
        <!-- Logging -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>2.0.13</version>
        </dependency>
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-slf4j-impl</artifactId>
            <version>2.23.1</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-jdk14</artifactId>
            <version>2.0.13</version>
            <scope>test</scope>
        </dependency>

package zti.web;

import java.util.HashMap;
import java.util.Map;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

@Controller(value = "saySimpleController")
@RequestMapping("/labs")
public class SimpleController {

    @RequestMapping("/lab01")
    public ModelAndView lab01() {
        Map<String, String> modelData = new HashMap<String, String>();
        modelData.put("msg", "Hello, world!");
        return new ModelAndView("script01.jsp", modelData);
    }

    @RequestMapping("/lab02")
    public String lab02(@RequestParam(name="name", defaultValue="Anonim") String name, Model model) {
        //Map<String, String> modelData = new HashMap<String, String>();
        //modelData.put("msg", "Hello, world!");
        model.addAttribute("mess","Hello " + name + "!");
        //return new ModelAndView("script02.jsp", modelData);
        return "script02.jsp" ;
    }
}

package zti.web;

import jakarta.servlet.ServletContext;
import jakarta.servlet.ServletException;
import jakarta.servlet.ServletRegistration;
import org.springframework.web.WebApplicationInitializer;
import org.springframework.web.context.support.AnnotationConfigWebApplicationContext;
import org.springframework.web.servlet.DispatcherServlet;

public class WebServlet implements WebApplicationInitializer {
    public void onStartup(ServletContext ctx) throws ServletException {
        AnnotationConfigWebApplicationContext webCtx = new AnnotationConfigWebApplicationContext();
        webCtx.register(WebConfig.class);
        webCtx.setServletContext(ctx);
        ServletRegistration.Dynamic servlet = ctx.addServlet("dispatcher", new DispatcherServlet(webCtx));
        servlet.setLoadOnStartup(1);
        servlet.addMapping("/");
    }
}

package zti.web;

import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.ViewResolver;
import org.springframework.web.servlet.config.annotation.*;
import org.springframework.web.servlet.view.InternalResourceViewResolver;

@EnableWebMvc
@ComponentScan(basePackages = "zti")
@Configuration

public class WebConfig implements ApplicationContextAware, WebMvcConfigurer {

    private ApplicationContext applicationContext;

    @Override
    public void setApplicationContext(ApplicationContext applicationContext) {
        this.applicationContext = applicationContext;
    }

    @Bean
    public ViewResolver jspViewResolver() {
        InternalResourceViewResolver bean = new InternalResourceViewResolver();
        bean.setPrefix("/WEB-INF/views/jsp/");
        bean.setViewNames("*.jsp");
        return bean;
    }

    
}

package zti.model;

public class Person {

    private String lname ;
    private String fname ;
    private String city ;
    private String email ;
    private String tel ;
    private Integer id;

    public Person() {}

    public Person(String lname, String fname, String city, String email, String tel, Integer id){
        this.lname = lname;
        this.fname = fname;
        this.city = city;
        this.email = email;
        this.tel = tel;
        this.id = id;
    }

    public void setFname( String newValue ){ fname = newValue ; }
    public String getFname() { return fname ; }
    public void setLname ( String newValue ) { lname = newValue ; }
    public String getLname() { return lname ; }
    public void setCity ( String newValue ) { city = newValue ; }
    public String getCity() { return city ; }
    public void setEmail ( String newValue ) { email = newValue ; }
    public String getEmail() { return email ; }
    public void setTel ( String newValue ) { tel = newValue ; }
    public String getTel() { return tel ; }
    public void setId ( Integer newValue ) { id = newValue ; }
    public Integer getId() { return id ; }

}

package zti.model;

import org.springframework.stereotype.Component;

import java.util.List;


public interface PersonDao {

    public List<Person> getPeople();
    public Person getPersonByID(int id);
    public int save(Person person);
    public int update(int id);
    public int delete(int id);

}

package zti.model;


import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

@Repository
public class PersonDaoImpl implements PersonDao {

    @Autowired
    @Qualifier("dbDataSource")

    private DataSource dataSource;
    private JdbcTemplate jdbcTemplate;


    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;

    }

    public PersonDaoImpl(DataSource dataSource) {
        jdbcTemplate = new JdbcTemplate(dataSource);
    }

    public List<Person> getPeople() {

        List<Person> people = new ArrayList<Person>();
        String query = "select id, fname, lname, email, city, tel from Person";
        //jdbcTemplate = new JdbcTemplate(dataSource);
        List<Map<String,Object>> personRows = jdbcTemplate.queryForList(query);

        for(Map<String,Object> personRow : personRows){
            Person person = new Person();
            person.setId(Integer.parseInt(String.valueOf(personRow.get("id"))));
            person.setFname(String.valueOf(personRow.get("fname")));
            person.setLname(String.valueOf(personRow.get("lname")));
            person.setCity(String.valueOf(personRow.get("city")));
            person.setEmail(String.valueOf(personRow.get("email")));
            person.setTel(String.valueOf(personRow.get("tel")));
            people.add(person);
        }
        return people;
    }

    public Person getPersonByID (int id) {
        String sql = "SELECT * FROM person WHERE id=?" ;
        //jdbcTemplate = new JdbcTemplate(dataSource);
        return jdbcTemplate.queryForObject(sql,  new Object[]{id}, new BeanPropertyRowMapper<Person>(Person.class));
    }

    public int delete(int id) {
        String sql = "DELETE FROM person WHERE id=?" ;
        //jdbcTemplate = new JdbcTemplate(dataSource);
        return jdbcTemplate.update(sql);
    }

    public int save(Person person) {
        String sql = "" ;
        //jdbcTemplate = new JdbcTemplate(dataSource);
        return jdbcTemplate.update(sql);
    }

    public int update(int id) {
        String sql = "" ;
        //jdbcTemplate = new JdbcTemplate(dataSource);
        return jdbcTemplate.update(sql);
    }



}

package zti.web;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;


import zti.model.Person;
import zti.model.PersonDaoImpl;

@Controller(value = "MvcController")
@RequestMapping("/mvc")
public class MvcJDBC {

    @Autowired
    PersonDaoImpl personDao;

    @RequestMapping(value = "/list")
    public String getTable(Model model) {
        // logger.info("Start getAllEmployees.");
        List<Person> people = personDao.getPeople() ;
        model.addAttribute("table",people);
        return "list.jsp";
    }

}

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>    
  
<h1>People List</h1>  
<table border="2" width="70%" cellpadding="2">  
<tr><th>Id</th><th>Fname</th><th>Lname</th><th>Email</th><th>Edit</th><th>Delete</th></tr>  
   <c:forEach var="person" items="${table}">   
   <tr>  
   <td>${person.id}</td>  
   <td>${person.fname}</td>  
   <td>${person.lname}</td>  
   <td>${person.email}</td>  
   <td><a href="editemp/${person.id}">Edit</a></td>  
   <td><a href="deleteemp/${person.id}">Delete</a></td>  
   </tr>  
   </c:forEach>  
   </table>