JSP显示新闻

package Entity;

public class News {
    private String title;
    private String content;
    private String author;
    private String date;

    public String getTitle() {
        return title;
    }

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

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getAuthor() {
        return author;
    }

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

    public String getDate() {
        return date;
    }

    public void setDate(String date) {
        this.date = date;
    }

    @Override
    public String toString() {
        return "News{" +
                "title=‘" + title + ‘\‘‘ +
                ", content=‘" + content + ‘\‘‘ +
                ", author=‘" + author + ‘\‘‘ +
                ", date=‘" + date + ‘\‘‘ +
                ‘}‘;
    }

    public News() {
    }

    public News(String title, String content, String author, String date) {
        this.title = title;
        this.content = content;
        this.author = author;
        this.date = date;
    }
}

package Dal;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.StatementImpl;

import javax.print.attribute.HashPrintRequestAttributeSet;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SqlHelper {
    static {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

    }
    public static Connection getConnection() throws SQLException {
        return (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/new_database", "root", "root");
    }

    public static ResultSet executeQuery(String sql)
    {
        try {
            Connection  conn = getConnection();
            ResultSet rs = conn.createStatement().executeQuery(sql);
            return rs;
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }
    public static void close(Connection conn) {

        if (conn != null) {
            try {
                conn.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}

package Service;

import Dal.SqlHelper;
import Entity.News;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class newsService {

    public List QueryNews() throws SQLException{
        String sql="Select * from News";
        ResultSet rs;
        rs= SqlHelper.executeQuery(sql);
        List lstNews=new ArrayList();
        while (rs.next()){
            News news=new News();
            news.setTitle(rs.getString("title"));
            news.setContent(rs.getString("content"));
            news.setAuthor(rs.getString("author"));
            news.setDate(rs.getString("date"));
            lstNews.add(news);
        }
        return lstNews;
    }

    public newsService() {
    }
}

package Controller;

import Entity.News;
import Service.newsService;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.plaf.synth.SynthEditorPaneUI;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

@WebServlet( "/Controller.ShowNewsServlet")
public class ShowNewsServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        newsService newsService=new newsService();
        try {
            List lsNews=newsService.QueryNews();
            request.setAttribute("lsNews",lsNews);
            request.getRequestDispatcher("showNews.jsp").forward(request,response);
            for(int i=0;i)
            {
                System.out.println(lsNews.get(i).toString());
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request,response);
    }
}

新闻列表



















标题
内容
作者
时间



${news.title} 
${news.content}
${news.author}
${news.date}