BookControllernotDAO

package com.kietna.kietspring.book;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RestController;

import jakarta.annotation.PostConstruct;


@Controller

public class BookController {
    @GetMapping("/books")
    public String getBooks(Model model) throws IOException{
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;
        List<Book> books = new ArrayList<Book>();
        try {
            getClass().forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_demo","root","NguyenAnhKiet@@123");
            statement = connection.createStatement();
            resultSet = statement.executeQuery("select * from book;");
            while(resultSet.next()) {
                int bookcode = resultSet.getInt("bookcode");
                String title = resultSet.getString("title");
                String author = resultSet.getString("author");
                String category = resultSet.getString("category");
                int approved = resultSet.getInt("approved");
                books.add(new Book(bookcode, title, author, category, approved == 0 ? false:true));
            }

        }catch (Exception e) {
            e.printStackTrace();
        }
        model.addAttribute("books", books);
        return "books";
    }
    @GetMapping("/book/{bookcode}")
    public String getBook(Model model, @PathVariable String bookcode) {
        model.addAttribute("bookcode", bookcode);
        Connection connection = null;
        PreparedStatement ps = null;
        ResultSet result = null;
        Book book = new Book();
        try {
            getClass().forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_demo","root","NguyenAnhKiet@@123");
            ps = connection.prepareStatement("select * from book where bookcode = ?");
            ps.setInt(1, Integer.valueOf(bookcode));
            result = ps.executeQuery();
            while(result.next()) {
                book.setBookcode(result.getInt("bookcode"));
                book.setTitle(result.getString("title"));
                book.setAuthor(result.getString("author"));
                book.setCategory(result.getString("category"));
                book.setApproved(result.getInt("approved")!=0 ? true : false);
            }
        }catch (Exception e) {
            e.printStackTrace();
        }
        model.addAttribute("book", book);
        return "book-detail";
    }
    @PostMapping("/book/save/{bookcode}")
    public String addBook(Book book, @PathVariable String bookcode) {
        Connection connection = null;
        PreparedStatement ps = null;
        int result = 0;
        try {
            getClass().forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_demo","root","NguyenAnhKiet@@123");
            ps = connection.prepareStatement("INSERT INTO book VALUES(?,?,?,?,?)");
            ps.setInt(1, Integer.valueOf(book.getBookcode()));
            ps.setString(2, book.getTitle());
            ps.setString(3, book.getAuthor());
            ps.setString(4, book.getCategory());
            ps.setInt(5, book.getApproved() ? 1 : 0);
            result = ps.executeUpdate();
            ps.close();
            connection.close();
            return "redirect:/books";
        }catch (Exception e) {
            e.printStackTrace();
        }
        return "error";
    }
    @PutMapping("/book/save/{bookcode}")
    public String update(Book book, @PathVariable String bookcode) {
        Connection connection = null;
        PreparedStatement ps = null;
        int result = 0;
        try {
            getClass().forName("com.mysql.cj.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_demo","root","NguyenAnhKiet@@123");
            ps = connection.prepareStatement("UPDATE book SET title = ?,author=?,category=?,approved=? WHERE bookcode=?");
            ps.setString(1, book.getTitle());
            ps.setString(2, book.getAuthor());
            ps.setString(3, book.getCategory());
            ps.setInt(4, book.getApproved() ? 1 : 0);
            ps.setInt(5, Integer.valueOf(book.getBookcode()));
            result = ps.executeUpdate();
            ps.close();
            connection.close();
            return "redirect:/books";
        }catch (Exception e) {
            e.printStackTrace();
        }
        return "error";
    }

}