Web工程配合Spring从数据库查询信息到前端显示案例(初级)
整个文件目录:
依赖jar包
1.数据库建表
表结构如下:
数据库名:temporary
表名:book
表字段:id/bookname/author
2.创建实体类
Book类(不需要Spring 管理)
public class Book {
private Integer id;
private String bookName;
private String author;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getBookName() {
return bookName;
}
public void setBookName(String bookName) {
this.bookName = bookName;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
}
3.创建Dao的接口和实现类
BookDao接口
public interface BookDao {
//查询所有图书
List<Book> queryAll();
}
实现类BookDaoImpl
public class BookDaoImpl implements BookDao {
private QueryRunner queryRunner;
public BookDaoImpl(QueryRunner queryRunner) {
this.queryRunner = queryRunner;
}
@Override
public List<Book> queryAll() {
List<Book> books = null;
try {
books = queryRunn