JSP作业

github地址：https://github.com/kubaiyi/javaee-jsp

小组成员：齐鹏，文宇豪

1.数据库连接

public class SqlHelper {
    private static String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private static String dbURL="jdbc:sqlserver://localhost:1433;databasename=Education";
    private static String userName="sa";
    private static String userPwd="123456";

    private static Connection  getCoonection()
    {
        try
        {
            Class.forName(driverName);
            Connection conn=DriverManager.getConnection(dbURL,userName,userPwd);
            return conn;
        }

        catch(Exception e)
        {
            e.printStackTrace();
            System.out.print("----------------连接失败");
        }
        return null;
    }

2、新建NewsService，提供News类的数据服务

 

public class NewService {
    public void AddNews(){}
    public boolean DeleteNews(int newID){
        String sql="delete from News where NewID="+newID;
        System.out.println(sql);
         boolean result= SqlHelper.executeUpdate(sql);
         return result;
    }
    public boolean UpdateNews(News news){

        String sql="update News set NewsContent='"+news.getNewsContent()+"'   where NewID="+ news.getNewID();
        System.out.println(sql);
        boolean result= SqlHelper.executeUpdate(sql);
        return result;

    }
    public List<News> QueryNews() throws SQLException {
        String sql="Select * from News";
        ResultSet rs;
        rs= SqlHelper.executeQuery(sql);
        List<News> lstNews=new ArrayList<News>();
        while (rs.next()){
            News news=new News();
            news.setNewID(rs.getInt("NewID"));
            news.setTitle(rs.getString("Category"));
            news.setNewsContent(rs.getString("NewsContent"));
            news.setAuthor(rs.getString("Author"));
            news.setNewsDate(rs.getDate("NewsDate"));
            lstNews.add(news);
        }
        return lstNews;
    }
    public News GetNews(int newID) throws SQLException {
        String sql="Select * from News where NewID="+newID;
        ResultSet rs;
        rs= SqlHelper.executeQuery(sql);
        News  news=new News();
        if (rs.next()){
            news.setNewID(rs.getInt("NewID"));
            news.setTitle(rs.getString("Category"));
            news.setNewsContent(rs.getString("NewsContent"));
            news.setAuthor(rs.getString("Author"));
            news.setNewsDate(rs.getDate("NewsDate"));
        }
        return news;

    }

 

3、新建ShowNewsListServlet

@WebServlet(urlPatterns = "/ShowNewsListServlet")
public class ShowNewsListServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        NewService newService=new NewService();
        try {
            List<News> lstNews=newService.QueryNews();
            for(News n:lstNews){
                System.out.println(n.getNewsContent());
            }
            request.setAttribute("lstNews", lstNews);
            request.getRequestDispatcher("ShowList.jsp").forward(request,response);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

 

 

4、新建新显示动态界面ShowNewsList.jsp

 

<body>
<span class="cp_title">新闻管理</span>
<div class="add_cp">
    <a href="logo.html">+添加新闻</a>
</div>
<div class="table_con">
    <table>
        <tr class="tb_title">
            <td width="10%">ID</td>
            <td width="30%">标题</td>
            <td width="12%">内容</td>
            <td width="12%">作者</td>
            <td width="10%">时间</td>
            <td width="26%">操作</td>
        </tr>
        <c:forEach var="news" items="${lstNews}" >
            <tr>
                <td width="10%">${news.title}</td>
                <td width="30%">${news.newsContent} </td>
                <td width="12%">${news.author}</td>
                <td width="12%">${news.newsDate}</td>
                <td width="10%">—</td>
                <td width="26%">
                    <a href="EditNewsServlet?newid=${news.newID}" class="del_btn">编辑</a>
                    <a href="viewServlet?newid=${news.newID}" class="del_btn">查看</a>
                    <a href="DeleteNewsServlet?newid=${news.newID}" class="del_btn">删除</a>
                </td>
            </tr>
        </c:forEach>
    </table>
</div>
</body>

 

5、显示效果

 

 

 

 

 

posted on 2020-06-15 13:34  Nauthiz  阅读(212)  评论(0)  编辑  收藏  举报

导航