如何使用@ModelAttribute注释将对象传递给数据库？

Question

我将使用@modelattribute而不是@requestparam绑定用户输入并将其写入数据库。当@modelattribute将请求处理程序方法(@modelattributebook book)中的数据绑定为book对象时，我感到困惑，那么我应该如何将该对象传递给数据库呢？通常使用@requestparam，我根据我的模型类逐个变量绑定用户输入，然后使用相关的DAO方法将它们发送到db。我在下面展示我的课程。如果我使用@modelattribute，谁能说出我的请求处理程序方法应该是什么样子？

模型类：

@Component
public class Book {
int bookId;
String title;
Author author;
Publisher publisher;

public int getBookId() {
    return bookId;
}

public void setBookId(int bookId) {
    this.bookId = bookId;
}

public String getTitle() {
    return title;
}

public void setTitle(String title) {
    this.title = title;
}

public Author getAuthor() {
    return author;
}

public void setAuthor(Author author) {
    this.author = author;
}

public Publisher getPublisher() {
    return publisher;
}

public void setPublisher(Publisher publisher) {
    this.publisher = publisher;
}
}

public class BookDAO extends JdbcDaoSupport {
@Autowired
AuthorDAO authorDAO;
@Autowired
PublisherDAO publisherDAO;

public void addBook(String title, int authorId, int publisherId)
        throws ClassNotFoundException, SQLException {

    String sql = "insert into tbl_book (title, authId, pubId) values (?, ?, ?)";
    this.getJdbcTemplate().update(sql, new Object[]{title, authorId, publisherId});
}
}

@Service
public class BookService {

@Autowired
BookDAO bookDAO;

public Book getBookById(int bookId) throws ClassNotFoundException,
        SQLException {

    return bookDAO.getBookById(bookId);

}

public List<Book> getAllBooks() throws ClassNotFoundException,
        SQLException {

    List<Book> bookList = bookDAO.getAllBooks();
    return bookList;

}

public void addBook(String title, int authorId, int publisherId) throws ClassNotFoundException,
        SQLException {

    bookDAO.addBook(title, authorId, publisherId);
}
}

控制器：

@Controller

公共类簿记员{

@RequestMapping(value = "/addBookExecution", method = equestMethod.POST)
protected ModelAndView addBookExecution(@RequestParam String title,
        @RequestParam int authorId, @RequestParam int blisherId)
        throws ClassNotFoundException, SQLException {
    bookService.addBook(title, authorId, publisherId);
    ModelAndView model = new ModelAndView("adminFunctionsPage");
    model.addObject("Msg", "Your request has been processed successfully.");
    return model;

}
}

Answer 1

您的表单应该有参数名称作为您的book对象，请检查下面的示例代码

<form >
<input type="text" name="authorId"/>
<input type="text" name="authorName"/>
etc...
</form>


Book.java

class Book{
  Integer authorId;
  String authorName;
  etc..
}
@RequestMapping(value = "/addBookExecution", method = equestMethod.POST)
protected ModelAndView addBookExecution(@ModelAttribute Book book)
        throws ClassNotFoundException, SQLException {
    bookService.addBook(book);
    ModelAndView model = new ModelAndView("adminFunctionsPage");
    model.addObject("Msg", "Your request has been processed successfully.");
    return model;

}