使用bootstrap的轮播图
使用thymeleaf模板引擎,将从后台取到的数据渲染到HTML前端页面。
轮播的图片存储在数据库中,表名为banner,两个字段,id和url.
![banner表](https://img-blog.csdnimg.cn/20210603095706150.png#pic_center)
Controller控制器:
//创建BannerDao
BannerDao bd = new BannerDao();
List<Banner> banners = bd.findAll();
//创建context对象
Context context = new Context();
//将集合中的数据装进context容器
context.setVariable("banners",banners);
ThUtils.print("home.html",context,response);
dao层的查询所有方法:
public List<Banner> findAll() {
List<Banner> list = new ArrayList<>();
try {
conn = JDBCUtils.getConnection();
String sql = "select * from banner";
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while (rs.next()){
int id = rs.getInt("id");
String url = rs.getString("url");
list.add(new Banner(id,url));
}
return list;
} catch (SQLException e)