JSP显示新闻

2021-02-04 23:17

阅读：749

标签：tac jsp bsp inf for 效果 tps next from

一、建表并初始化数据

技术图片

二、登陆

2.1 登陆失败提示

技术图片

2.2 登陆成功显示新闻列表

public class NewsMapperImpl implements NewsMapper {
    @Override
    public List findAllNewsHref() {
        Connection conn = null;
        Statement statement = null;
        ResultSet rs = null;
        List news = new ArrayList();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        try {
            conn = DBUtil.getConnection();
            statement = conn.createStatement();

            String sql = "select * from news";
            rs = statement.executeQuery(sql);
            while (rs.next()) {
                News nw = new News(
                        rs.getInt(1),
                        rs.getString(2),
                        rs.getString(3),
                        rs.getString(4),
                        sdf.parse(rs.getString(5))
                );
                news.add(nw);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (ParseException e) {
            e.printStackTrace();
        }

        return news;
    }
}