<span id="ld197"><th id="ld197"><progress id="ld197"></progress></th></span>
<menuitem id="ld197"></menuitem>

    <dl id="ld197"></dl>

    <track id="ld197"><big id="ld197"><big id="ld197"></big></big></track><noframes id="ld197"><dfn id="ld197"><address id="ld197"></address></dfn>

    <output id="ld197"></output>
    <var id="ld197"><noframes id="ld197">
      <dfn id="ld197"><nobr id="ld197"><sub id="ld197"></sub></nobr></dfn>
          <b id="ld197"><form id="ld197"><delect id="ld197"></delect></form></b>

                當前位置:首頁 > 開發教程 > Web前端 >

                基于jsp的新聞發布系統

                時間:2016-06-07 11:14 來源: 作者: 瀏覽: 收藏 挑錯 推薦 打印

                1.在jsp頁面中會用到的兩種標簽有:struts2與jstl。一定要區分兩者的標簽形式,下面從三種場景來區分下。a.在jstl中使用struts2 jstl: el:${ee.id} struts2: 通過struts2標簽取jstl標簽的變量時,如果有設置scope,可以從scope中取值如果沒有就需要用#attr來 新聞發布系統
                下面就讓我們來說一說基于jsp的新聞發布系統,其中使用的技術有JavaBean、fillter、數據庫等,能夠實現新聞的發布功能,在發布之后能夠進行對每一條新聞的刪除、修改、或者繼續增加新的文章,最后還能夠進行查詢功能。 一、效果演示 首先讓我們來看一看實現的效果: 下面是登陸的首界面: 基于jsp的新聞發布系統
                圖1 首界面
                管理員登錄頁面: 基于jsp的新聞發布系統
                圖2 管理員登錄界面
                下面是管理員登陸之后的界面,可以進行添加新聞、刪除新聞、查詢新聞: 基于jsp的新聞發布系統
                圖3 管理員管理界面
                下面是添加新聞界面,能夠進行新聞的添加: 基于jsp的新聞發布系統
                圖4 添加新聞界面
                下面是所添加的新聞: 基于jsp的新聞發布系統
                圖5 添加后的新聞
                下面是修改新聞界面: 基于jsp的新聞發布系統
                圖6 修改新聞界面 下面是修改后的界面 基于jsp的新聞發布系統
                圖7 修改后的界面
                下面是刪除新聞后的界面: 基于jsp的新聞發布系統
                圖8 刪除新聞后的界面

                對于新聞的查找,與其他類似,在這里我們使用的是利用新聞編號進行查詢所需的信息,然后在新的頁面上進行顯示 二、具體實現過程  1、環境:編程環境為NetBeans8.0和Oracle數據庫  2、數據庫后臺的設計     在新聞管理系統中,我們需要數據庫后臺管理,其具體步驟如下所示: 根據所需的業務進行建表,可參見如下所示:建立數據庫
                 3、編寫步驟: (1)首先建立以個項目,在此命名為Demo_08_NewsRealese,項目布局結構如下圖所示,根據如下布局對項目進行布局設計,方便后面的編程,項目中web-inf為項目配置文件夾,images文件夾用于儲存項目中使用的圖片文件,ueditor為百度富文本編輯器文件夾,源包文件夾為Java類文件夾:
                基于jsp的新聞發布系統
                圖9 項目布局結構圖 接著,我們進行創建數據庫連接層,即DAO和VO,分別存于包com.lut.beans和dao,類命名分別命名為NewsRealese、NewsRealeseDao,對于類NewsRealese而言,主要是實現字符串的包裝,其內容與數據庫里邊的內容一一對應,其代碼分別如下所示:
                package com.lut.beans;
                public class NewsRealese {
                  private String newsId;
                private String classId;
                private String kindId;
                private String myOther;
                private String headTitle;
                private String content;
                private String connectRealtive;
                private String author;
                private String editor;
                private String newsFrom;
                private String top;
                private String newsTime;
                private String hits;
                private String state;
                private String tag;
                
                    public String getNewsId() {
                        return newsId;
                    }
                
                    public void setNewsId(String newsId) {
                        this.newsId = newsId;
                    }
                
                    public String getClassId() {
                        return classId;
                    }
                
                    public void setClassId(String classId) {
                        this.classId = classId;
                    }
                
                    public String getKindId() {
                        return kindId;
                    }
                
                    public void setKindId(String kindId) {
                        this.kindId = kindId;
                    }
                
                    public String getMyOther() {
                        return myOther;
                    }
                
                    public void setMyOther(String myOther) {
                        this.myOther = myOther;
                    }
                
                    public String getHeadTitle() {
                        return headTitle;
                    }
                
                    public void setHeadTitle(String headTitle) {
                        this.headTitle = headTitle;
                    }
                
                    public String getContent() {
                        return content;
                    }
                
                    public void setContent(String content) {
                        this.content = content;
                    }
                
                    public String getConnectRealtive() {
                        return connectRealtive;
                    }
                
                    public void setConnectRealtive(String connectRealtive) {
                        this.connectRealtive = connectRealtive;
                    }
                
                    public String getAuthor() {
                        return author;
                    }
                
                    public void setAuthor(String author) {
                        this.author = author;
                    }
                
                    public String getEditor() {
                        return editor;
                    }
                
                    public void setEditor(String editor) {
                        this.editor = editor;
                    }
                
                    public String getNewsFrom() {
                        return newsFrom;
                    }
                
                    public void setNewsFrom(String newsFrom) {
                        this.newsFrom = newsFrom;
                    }
                
                    public String getTop() {
                        return top;
                    }
                
                    public void setTop(String top) {
                        this.top = top;
                    }
                
                    public String getNewsTime() {
                        return newsTime;
                    }
                
                    public void setNewsTime(String newsTime) {
                        this.newsTime = newsTime;
                    }
                
                    public String getHits() {
                        return hits;
                    }
                
                    public void setHits(String hits) {
                        this.hits = hits;
                    }
                
                    public String getState() {
                        return state;
                    }
                
                    public void setState(String state) {
                        this.state = state;
                    }
                
                    public String getTag() {
                        return tag;
                    }
                
                    public void setTag(String tag) {
                        this.tag = tag;
                    }
                   
                    
                }
                
                下面是類DAO類,命名為NewsRealeseDao.java,對于DAO類,主要用于實現數據庫的連接問題,進行數據庫的鏈接,在連接過程中需要用到各種有關數據庫的技術,在這里我們使用的是Oracle數據庫,其獲取鏈接的方式為如下代碼,其中第一行為驅動程序名,第二行為數據庫地址(orcl為Oracle數據庫中的SID,在安裝Oracle數據庫時需要記住),第三行為具體的連接,及使用URL找到數據庫位置,然后使用密碼wjk139登錄到Scott賬戶
                        //獲取連接  
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                            conn = DriverManager.getConnection(url, "scott", "wjk139");
                ,其他的操作分別為增刪改查的具體代碼,分別對應Servlet中或jsp中需要實例化的代碼,下面就是具體的DAO類代碼:
                package dao;
                
                import com.lut.beans.NewsRealese;
                import static java.lang.System.out;
                import java.sql.Connection;
                import java.sql.DriverManager;
                import java.sql.PreparedStatement;
                import java.sql.ResultSet;
                import java.sql.SQLException;
                import java.sql.Statement;
                import java.util.ArrayList;
                
                public class NewsRealeseDao {
                
                    public ArrayList queryAllNews() throws Exception {
                        Connection conn = null;
                        ArrayList newsRealese = new ArrayList();
                        try {
                            //獲取連接  
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                            conn = DriverManager.getConnection(url, "scott", "wjk139");
                            //運行SQL語句 
                            String sql = "select * from newmessage";//獲取
                            Statement stat = conn.createStatement();
                            ResultSet rs = stat.executeQuery(sql);
                            while (rs.next()) {   //實例化VO
                                NewsRealese news = new NewsRealese();
                                news.setNewsId(rs.getString("newsid"));
                                news.setClassId(rs.getString("CLASSID"));
                                news.setKindId(rs.getString("KINDID"));
                                news.setMyOther(rs.getString("MYOTHER"));
                                news.setHeadTitle(rs.getString("HEADTITLE"));
                                news.setContent(rs.getString("CONTENT"));
                                news.setConnectRealtive(rs.getString("CONNECTREALTIVE"));
                                news.setAuthor(rs.getString("AUTHOR"));
                                news.setEditor(rs.getString("EDITOR"));
                                news.setNewsFrom(rs.getString("NEWSFROM"));
                                news.setTop(rs.getString("TOP"));
                                news.setNewsTime(rs.getString("NEWSTIME"));
                                news.setHits(rs.getString("HITS"));
                                news.setState(rs.getString("STATE"));
                                news.setTag(rs.getString("TAG"));
                                newsRealese.add(news);
                            }
                            rs.close();
                            stat.close();
                        } catch (Exception e1) {
                            e1.printStackTrace();
                        } finally {
                            try {//關閉連接
                                if (conn != null) {
                                    conn.close();
                                    conn = null;
                                }
                            } catch (Exception ex) {
                            }
                            return newsRealese;
                        }
                    }
                    //查詢一個消息
                    public ArrayList queryOneNews(int newsid) throws Exception {
                        Connection conn = null;
                        ArrayList newsRealese = new ArrayList();
                        int temp_id = newsid;
                        try {
                            //獲取連接  
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                            conn = DriverManager.getConnection(url, "scott", "wjk139");//不安全
                            //運行SQL語句 
                            Statement stat = conn.createStatement();
                            String sql = "select * from newmessage where newsid=?";//獲取newsid,使用?代替字符串,以免會發生錯誤
                            PreparedStatement ps = conn.prepareStatement(sql);
                            ps.setInt(1, Integer.valueOf(newsid));
                            ResultSet rs = ps.executeQuery();// 之前已經給了sql字符串,所以executeUpdate是無參的。              
                            while (rs.next()) {   //實例化VO
                                NewsRealese news = new NewsRealese();
                                news.setNewsId(rs.getString("newsid"));
                                news.setClassId(rs.getString("CLASSID"));
                                news.setKindId(rs.getString("KINDID"));
                                news.setMyOther(rs.getString("MYOTHER"));
                                news.setHeadTitle(rs.getString("HEADTITLE"));
                                news.setContent(rs.getString("CONTENT"));
                                news.setConnectRealtive(rs.getString("CONNECTREALTIVE"));
                                news.setAuthor(rs.getString("AUTHOR"));
                                news.setEditor(rs.getString("EDITOR"));
                                news.setNewsFrom(rs.getString("NEWSFROM"));
                                news.setTop(rs.getString("TOP"));
                                news.setNewsTime(rs.getString("NEWSTIME"));
                                news.setHits(rs.getString("HITS"));
                                news.setState(rs.getString("STATE"));
                                news.setTag(rs.getString("TAG"));
                                newsRealese.add(news);
                            }
                            rs.close();
                            stat.close();
                        } catch (Exception e1) {
                            e1.printStackTrace();
                        } finally {
                            try {//關閉連接
                                if (conn != null) {
                                    conn.close();
                                    conn = null;
                                }
                            } catch (Exception ex) {
                            }
                            return newsRealese;
                        }
                    }
                    //刪除數據
                        public String deleteOneNews(int newsid) throws Exception {
                        Connection conn = null;
                        ArrayList newsRealese = new ArrayList();
                        int temp_id = newsid;
                        try {
                            //獲取連接  
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                            conn = DriverManager.getConnection(url, "scott", "wjk139");//不安全
                            //運行SQL語句 
                            Statement stat = conn.createStatement();
                            String sql = "DELETE FROM  newmessage WHERE newsid =?";//獲取newsid,使用?代替字符串,以免會發生錯誤
                            PreparedStatement ps = conn.prepareStatement(sql);
                            ps.setInt(1, Integer.valueOf(newsid));
                            ResultSet rs = ps.executeQuery();// 之前已經給了sql字符串,所以executeUpdate是無參的。              
                            rs.close();
                            stat.close();
                        } catch (Exception e1) {
                            e1.printStackTrace();
                        } finally {
                            try {//關閉連接
                                if (conn != null) {
                                    conn.close();
                                    conn = null;
                                }
                            } catch (Exception ex) {
                            }
                            return newsRealese.toString();
                        }
                    }
                    //插入數據
                    public String insertOneNews(ArrayList addnews_list) throws Exception {
                        Connection conn = null;
                        /* for(int i=0,j=1;i<addnews_list.size();i++,j++)
                         {
                                     
                         System.out.println("j:"+j+"值:"+addnews_list.get(i).toString());
                         }*/
                        try {
                            //獲取連接  
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                            conn = DriverManager.getConnection(url, "scott", "wjk139");//不安全
                            //運行SQL語句 
                            Statement stat = conn.createStatement();
                            String sql = "insert into newmessage(newsId,classId,kindId,myOther,headTitle,content,connectRealtive,author,editor,newsFrom"
                                    + ",top,newsTime,hits,state,tag) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";//獲取newsid,使用?代替字符串,以免會發生錯誤
                            PreparedStatement ps = conn.prepareStatement(sql);
                            ps.setInt(1, Integer.valueOf(addnews_list.get(0).toString()));
                            ps.setInt(2, Integer.valueOf(addnews_list.get(1).toString()));
                            ps.setInt(3, Integer.valueOf(addnews_list.get(2).toString()));
                            ps.setInt(4, Integer.valueOf(addnews_list.get(3).toString()));
                            ps.setString(5, addnews_list.get(4).toString());
                            ps.setString(6, addnews_list.get(5).toString());
                            ps.setString(7, addnews_list.get(6).toString());
                            ps.setString(8, addnews_list.get(7).toString());
                            ps.setString(9, addnews_list.get(8).toString());
                            ps.setString(10, addnews_list.get(9).toString());
                            ps.setInt(11, Integer.valueOf(addnews_list.get(10).toString()));
                            ps.setString(12, addnews_list.get(11).toString());
                            ps.setString(13, addnews_list.get(12).toString());
                            ps.setString(14, addnews_list.get(13).toString());
                            ps.setString(15, addnews_list.get(14).toString());
                            for (int i = 0, j = 1; i < addnews_list.size(); i++, j++) {
                                System.out.println("j:" + j + "值:" + addnews_list.get(i).toString());
                            }
                            int i = ps.executeUpdate();
                            conn.commit();
                            System.out.println("成功添加" + i + "行");
                            stat.close();
                            conn.close();
                            return i + "conn:" + conn;
                        } catch (Exception e1) {
                            e1.printStackTrace();
                        } finally {
                            try {//關閉連接
                                if (conn != null) {
                                    conn.close();
                                    conn = null;
                                }
                            } catch (Exception ex) {
                            }
                        }
                        return conn.toString();
                    }
                    //更新數據
                     public String updateOneNews(ArrayList addnews_list) throws Exception {
                        Connection conn = null;
                        /* for(int i=0,j=1;i<addnews_list.size();i++,j++)
                         {
                                     
                         System.out.println("j:"+j+"值:"+addnews_list.get(i).toString());
                         }*/
                        try {
                            //獲取連接  
                            Class.forName("oracle.jdbc.driver.OracleDriver");
                            String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                            conn = DriverManager.getConnection(url, "scott", "wjk139");//不安全
                            //運行SQL語句 
                            Statement stat = conn.createStatement();
                            //獲取newsid,使用?代替字符串,以免會發生錯誤
                  String sql = "UPDATE newmessage set classId=?,kindId=?,myOther=?,headTitle=?,content=?,"
                          + "connectRealtive=?,author=?,editor=?,newsFrom=?,top=?,newsTime=?,hits=?,state=?,tag=? where newsid=?";  
                            PreparedStatement ps = conn.prepareStatement(sql);
                            
                            ps.setInt(1, Integer.valueOf(addnews_list.get(1).toString()));
                            ps.setInt(2, Integer.valueOf(addnews_list.get(2).toString()));
                            ps.setInt(3, Integer.valueOf(addnews_list.get(3).toString()));
                            ps.setString(4, addnews_list.get(4).toString());
                            ps.setString(5, addnews_list.get(5).toString());
                            ps.setString(6, addnews_list.get(6).toString());
                            ps.setString(7, addnews_list.get(7).toString());
                            ps.setString(8, addnews_list.get(8).toString());
                            ps.setString(9, addnews_list.get(9).toString());
                            ps.setInt(10, Integer.valueOf(addnews_list.get(10).toString()));
                            ps.setString(11, addnews_list.get(11).toString());
                            ps.setString(12, addnews_list.get(12).toString());
                            ps.setString(13, addnews_list.get(13).toString());
                            ps.setString(14, addnews_list.get(14).toString());
                            ps.setInt(15, Integer.valueOf(addnews_list.get(0).toString()));
                            for (int i = 0, j = 1; i < addnews_list.size(); i++, j++) {
                                System.out.println("j:" + j + "值:" + addnews_list.get(i).toString());
                            }
                            int i = ps.executeUpdate();
                            conn.commit();
                            System.out.println("成功更新" + i + "行");
                            stat.close();
                            conn.close();
                            return i + "conn:" + conn;
                        } catch (Exception e1) {
                            e1.printStackTrace();
                        } finally {
                            try {//關閉連接
                                if (conn != null) {
                                    conn.close();
                                    conn = null;
                                }
                            } catch (Exception ex) {
                            }
                        }
                        return conn.toString();
                    }
                    public String ischecked(String user, String pass) throws Exception {
                        Connection conn = null;
                        //獲取連接  
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
                        try {
                            conn = DriverManager.getConnection(url,user, pass);//不安全
                            //建立連接
                            return conn.toString();
                           } 
                        catch (SQLException e) 
                          {
                           e.printStackTrace();
                          }
                          finally 
                        {
                               if (conn != null)
                               {
                                     try {
                                            conn.close();
                                          } catch (SQLException e)
                                          {
                                              e.printStackTrace();
                                           }
                         }
                     }
                     return null;
                   } 
                }
                (2)首頁展示頁面的編寫,命名為index.html,由于可能有網絡的延遲,我們使用漸進的方式跳轉(漸進方式跳轉:window.location.href="newRealese_brief.jsp",從index.html頁面跳轉到ewRealese_brief.jsp頁面),代碼如下所示:
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                   <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>  
                     <title>新聞發布系統--最前沿的時尚信息、最有看點的社會聚焦、最富得浪漫的殿堂</title>
                    </head>
                    <body id="body">
                        正在跳轉...,請等待...
                     <script language="javascript" type="text/javascript">
                           window.location.href="newRealese_brief.jsp"; 
                    </script>
                    </body>
                </html>
                
                在緩沖時,會進行跳轉,跳轉后的頁面為newRealese_brief.jsp,其代碼如下所示:進入新聞展示頁面之后,我們能夠對新聞進行搜素,還能夠查看詳細內容。
                <%@page contentType="text/html" import="java.util.*,java.sql.*,com.lut.beans.NewsRealese,dao.NewsRealeseDao" 
                        pageEncoding="UTF-8" language="java"%>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                        <title>新聞發布系統--最前沿的時尚信息、最有看點的社會聚焦、最富得浪漫的殿堂</title>
                        <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>  
                    </head>
                    <body id="body">
                        <a href="adminLogin.jsp" style="table-layout: right">管理員登錄</a><h1 id="p">最新資訊</h1><br>
                        <%@include file="a_queryNews.jsp"  %>
                        <table  border="0" style="width:100%; height:100%" align="center">
                            <tr>
                                <td style="width: 10%"> </td>
                                <td>
                                    <%
                                        NewsRealeseDao newsRealeseDao = new NewsRealeseDao();
                                        ArrayList newsRealese = newsRealeseDao.queryAllNews();
                                    %> 
                                    <%
                                        for (int i = 0; i < newsRealese.size(); i++) {
                                            NewsRealese newRealese = (NewsRealese) newsRealese.get(i);
                                    %>   
                            <center><table  border="0" width="100%" id="table">
                                    <tr>
                                        <td width="128"><p>此處假設無圖片</p>
                                            <p>此處假設無等級信息</p>
                                        </td>
                                        <td ><table  border="0" width="100%">
                                                <tr>
                                                    <td width="11%" >原創或轉載:</td>
                                                    <td colspan="3"><%=newRealese.getMyOther()%> </td>
                                                    <td width="10%" >新聞標題:</td>
                                                    <td width="44%" ><%=newRealese.getHeadTitle()%> </td>
                                                </tr>
                                                <tr>                  
                                                    <td colspan="6">新聞內容:</td> 
                                            </table>
                                            <table width="100%" border="0"> 
                                                <tr>
                                                    <td>
                                                        <a  target="_blank" href="newRealese_detail.jsp?newsid=<%=newRealese.getNewsId()%>"/>
                                                        <table width="100%" border="0" align="center">
                                                            <tr>
                                                                <td> 
                                                                    <%=newRealese.getContent()%>					     
                                                                </td> 
                                                            </tr>
                                                        </table>             
                                                    </td> 
                                                </tr>  
                                            </table>
                                            <table border="0" width="100%">      
                                                <tr>
                                                    <td width="51" height="30">作者:</td>
                                                    <td width="203"><%=newRealese.getAuthor()%> </td>
                                                    <td width="97">新聞發布時間:</td>
                                                    <td width="167"><%=newRealese.getNewsTime()%> </td>
                                                    <td width="99">新聞點擊次數:</td>
                                                    <td width="191"><%=newRealese.getHits()%> </td>
                                                </tr>         
                                            </table></td>
                                    </tr>
                                    <tr>
                                        <td height="21" colspan="2"><hr></td>
                                    </tr>
                                </table></center>
                                <%
                                    }
                                %>
                        </td>
                        <td> </td>
                    </tr>
                    <tr>
                        <td> </td>
                        <td> </td>
                        <td> </td>
                    </tr>
                </table>
                </body>
                </html>
                
                (3)詳細新聞頁面的設計,命名為newRealese_detail.jsp其代碼如下所示:再詳細新聞頁面上,我們能夠進行數據的詳細情況的了解,在觀看完詳細信息之后,我們能夠進行點擊返回按鈕進行返回操作
                <%@page contentType="text/html" import="java.util.*,java.sql.*" pageEncoding="UTF-8" language="java"%>
                <%@page import="com.lut.beans.NewsRealese" %>
                <%@page import="dao.NewsRealeseDao" %>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>  
                        <title>新聞發布系統--最前沿的時尚信息、最有看點的社會聚焦、最值得浪漫的殿堂</title>
                    </head>
                    <body id="body">
                        <h1>最新資訊</h1><br>
                        <%
                            String newsid=request.getParameter("newsid");
                            int newsid_int=Integer.parseInt(newsid);
                          
                          NewsRealeseDao newsRealeseDao=new NewsRealeseDao();
                          ArrayList newsRealese=newsRealeseDao.queryOneNews(newsid_int);
                        %>    
                      
                        <table  border="1">
                            <tr >
                                <td >新聞編號</td>
                                <td>所屬新聞欄目編號</td>
                                 <td>所屬新聞分類編號</td>
                                <td>原創或轉載</td>
                                <td>新聞標題</td>
                                 <td>新聞內容</td>
                                <td>相關文章</td>
                                <td>作者</td>
                                <td>編輯</td>
                                <td>出處</td>
                                <td>是否置頂</td>
                                <td>新聞發布時間</td>
                                <td>新聞點擊次數</td>
                                <td>新聞狀態</td>
                                <td>新聞標記</td>                                                                                                                                   
                            </tr>
                            <%
                            for(int i=0;i<newsRealese.size();i++)
                            {
                                NewsRealese newRealese=(NewsRealese)newsRealese.get(i);       
                           %>
                            <tr>
                                <td><%=newRealese.getNewsId()  %> </td>
                                <td><%=newRealese.getClassId()  %> </td>
                                <td><%=newRealese.getKindId()  %> </td>
                                <td><%=newRealese.getMyOther()  %> </td>
                                <td><%=newRealese.getHeadTitle()%> </td>
                                <td><%=newRealese.getContent()  %> </td>
                                <td><%=newRealese.getConnectRealtive()%></td>
                                <td><%=newRealese.getAuthor()  %> </td>
                                <td><%=newRealese.getEditor()  %> </td>
                                <td><%=newRealese.getNewsFrom()  %> </td>
                                <td><%=newRealese.getTop()  %> </td>
                                <td><%=newRealese.getNewsTime()  %> </td>
                                <td><%=newRealese.getHits()  %> </td>
                                <td><%=newRealese.getState()  %> </td>
                                <td><%=newRealese.getTag()  %> </td>
                            </tr>
                        
                        </table>
                <table width="100%" border="0" cellspacing="0" cellpadding="4">
                  <tr>
                    <td width="100%" style="text-align: center; vertical-align: top">
                      <table width="90%" border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td>
                            <table width="100%" border="0" cellspacing="1" cellpadding="4" >
                              <tr>
                                <th width="26%" class="TitleColor" style="text-align: right; vertical-align: top" scope="row">新聞標題:  </th>
                                <td width="74%" style="vertical-align: top" class="TitleColor" ><p align="left"><%=newRealese.getHeadTitle()%><p></td>
                              </tr>
                              <tr>
                                <th scope="row" class="TitleColor" style="text-align: right; vertical-align: top">作者:</th>
                                <td style="vertical-align: top"><p align="left"><%=newRealese.getAuthor()  %>    <p>           </td>
                              </tr>
                              <tr>
                                <th scope="row" class="TitleColor" style="text-align: right; vertical-align: top">新聞發布時間: </th>
                                <td style="vertical-align: top" class="TitleColor"><p align="left"><%=newRealese.getNewsTime()  %><p></td>
                              </tr>
                              <tr>
                                <th scope="row" class="TitleColor" style="text-align: right; vertical-align: top">新聞點擊次數:  </th>
                                <td style="vertical-align: top" class="TitleColor"><p align="left"><%=newRealese.getHits()  %><p></td>
                              </tr>
                              <tr>
                                <td colspan="2" class="StoryContentColor"><p align="center"><%=newRealese.getContent()  %><p></td>
                              </tr>
                            </table> 
                          </td>
                        </tr>
                      </table>
                      <p> </p>     
                      <table>
                        <tr>
                               <td >
                                  <a href="newRealese_brief.jsp">返回</a>
                                </td>
                                <td>
                                  <a href="#">發表評論</a>
                                </td>
                          </tr>      
                      </table>   
                    </td>
                  </tr>
                </table>
                <table width="100%" border="0" cellspacing="0" cellpadding="4">
                  <tr style="text-align: right">
                    <td>      <a href="#">點贊</a> <a href="#">舉報</a> <a href="#">投稿,聯系作者</a>     </td>
                  </tr>
                </table>
                                  <%
                            }
                            %>
                </body>
                </html>
                
                (4)管理員登錄界面,命名為adminLogin.jsp頁面,使用連接數據庫的方式進行登錄,在這里我們的管理員名稱為Scott,密碼為wjk139,管理員登錄界面的實現代碼如下所示
                <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
                
                
                <html>
                <head>
                <meta http-equiv="Content-Type" content="text/html; charset=utf-8"  />
                <title>新聞發布系統--最前沿的時尚信息、最有看點的社會聚焦、最值得浪漫的殿堂</title>
                <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>  
                </head>
                   <body id="body">
                 <form method="post" action="checkLogin">
                     <table   border="0" align="center" id="table_vertical" >
                  <caption>管理員登錄 </caption>
                  <tr>
                    <td width="40">Admin</td>
                    <td width="183">
                        <input type="text" name="user"></td>
                  </tr>
                  <tr>
                    <td height="25">Pass</td>
                    <td><input type="password" name="pass"></td>
                   </tr>
                 </table> 
                  <table align="center">
                	<tr>
                	<td>
                    <input type="submit" value="Login">
                    <input type="reset" value="Reset">
                	</td>
                   </tr>  
                   </table>
                </form>
                </body>
                </html>
                
                在登錄的過程中,我們需要進行判斷,命名為checkLogin.java,,通過此類進行判斷登錄是否成功,若成功,則跳轉到管理界面,若失敗,則停留在當前界面,其代碼如下所示:
                /*
                 * To change this license header, choose License Headers in Project Properties.
                 * To change this template file, choose Tools | Templates
                 * and open the template in the editor.
                 */
                
                package servlet;
                
                import com.lut.beans.NewsRealese;
                import dao.NewsRealeseDao;
                import java.io.IOException;
                import java.io.PrintWriter;
                import java.util.logging.Level;
                import java.util.logging.Logger;
                import javax.servlet.ServletException;
                import javax.servlet.http.HttpServlet;
                import javax.servlet.http.HttpServletRequest;
                import javax.servlet.http.HttpServletResponse;
                public class checkLogin extends HttpServlet {
                    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        response.setContentType("text/html;charset=UTF-8");
                        String user=request.getParameter("user");
                        String pass=request.getParameter("pass");
                          NewsRealeseDao newsRealeseDao=new NewsRealeseDao();
                        try {    
                            String newsRealese=newsRealeseDao.ischecked(user,pass);
                             if(newsRealese!=null)
                             {
                                 response.sendRedirect("adminManager.jsp");
                             }
                             else
                             {
                                 response.sendRedirect("adminLogin.jsp");
                                 
                             }        
                       } 
                        catch (Exception ex) 
                        {
                            Logger.getLogger(checkLogin.class.getName()).log(Level.SEVERE, null, ex);
                        }
                   }
                    @Override
                    protected void doGet(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    protected void doPost(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                
                    @Override
                    public String getServletInfo() {
                        return "Short description"+"public String getServletInfo() ";
                    }// </editor-fold>
                }
                

                (5)管理員登陸之后的界面,命名為adminManager.jsp頁面,在管理員界面能夠進行刪除修改增加和查詢操作,其代碼如下所示:
                <%-- 
                    Document   : adminManager
                    Created on : 2016-5-18, 17:10:01
                    Author     : Administrator
                --%>
                <%@page import="java.util.ArrayList"%>
                <%@page import="com.lut.beans.NewsRealese"%>
                <%@page import="dao.NewsRealeseDao"%>
                <%@page contentType="text/html" pageEncoding="UTF-8"%>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                        <title>管理員界面||adminManager.jsp</title>
                        <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>  
                    </head>
                 <body id="body" style=" text-orientation: vertical-right">
                        <h1 id="p">新聞管理</h1><br>
                        <table border="1" style="width:100%; height:100%">
                            <tr>
                                <td width="10%" style="text-align:top">
                                    <table  border="0" style="width: 100%;height: 100%" >
                                        <tr>
                                            <td><div align="center">新聞信息顯示 </div></td>
                                        </tr>
                                        <tr>
                                            <td><img src="./images/dog.jpg" width="100%" height="90%"></td>
                                        </tr>
                                        <tr>
                                            <td><img src="./images/minus.gif" ></td>
                                        </tr>
                                    </table></td>
                                <td width="50%">
                                    <table border="0">
                                        <tr>
                                            <td>
                                                <%        NewsRealeseDao newsRealeseDao = new NewsRealeseDao();
                                                    ArrayList newsRealese = newsRealeseDao.queryAllNews();
                                                %> 
                                                <%
                                                    for (int i = 0; i < newsRealese.size(); i++) {
                                                        NewsRealese newRealese = (NewsRealese) newsRealese.get(i);
                                                %>  
                                                <table  border="0" width="100%" id="table">
                                                    <tr>
                                                        <td width="128"><p>此處假設無圖片</p>
                                                            <p>此處假設無等級信息</p>            </td>
                                                        <td ><table  border="0" width="100%">
                                                                <tr>
                                                                    <td  >原創或轉載:</td>
                                                                    <td ><%=newRealese.getMyOther()%> </td>
                                                                    <td >新聞標題:</td>
                                                                    <td ><%=newRealese.getHeadTitle()%> </td>
                                                                </tr>
                                                                <tr>                  
                                                                    <td colspan="6">新聞內容:</td> 
                                                            </table>
                                                            <table width="100%" border="0"> 
                                                                <tr>
                                                                    <td>
                                                                        <a  target="_blank" href="newRealese_detail.jsp?newsid=<%=newRealese.getNewsId()%>"/>
                                                                        <table width="100%" border="0" align="center">
                                                                            <tr>
                                                                                <td> 
                                                                                    <%=newRealese.getContent()%>						     </td> 
                                                                            </tr>
                                                                        </table>		          </td> 
                                                                </tr>  
                                                            </table>
                                                            <table border="0" width="100%">      
                                                                <tr>
                                                                    <td width="51" height="30">作者:</td>
                                                                    <td width="203"><%=newRealese.getAuthor()%> </td>
                                                                    <td width="97">新聞發布時間:</td>
                                                                    <td width="167"><%=newRealese.getNewsTime()%> </td>
                                                                    <td width="99">新聞點擊次數:</td>
                                                                    <td width="191"><%=newRealese.getHits()%> </td>
                                                                </tr>         
                                                            </table></td>
                                                    </tr>          
                                                    <tr>
                                                        <td height="21" colspan="2">
                                                            <input type="button" name="delete" value="刪除"  align="middle" 
                                                                   onclick="javascrtpt:window.location.href = 'DeleteOneNews?newsid=<%=newRealese.getNewsId()%>'"> 
                                                            <input type="button" name="delete" value="修改"  align="middle"  
                                                                   onclick="javascrtpt:window.location.href = 'a_updateNews.jsp?newsid=<%=newRealese.getNewsId()%>'">
                                                            <hr>			</td>
                                                    </tr>
                                                </table>
                                                <%
                                                    }
                                                %>				  </td>
                                        </tr>
                                    </table>			     </td>
                                <td width="5%" style=" text-orientation: vertical-right">
                
                                    <%@include file="a_queryNews.jsp"  %>
                                </td>
                            </tr>
                            <tr>
                                <td align="center"><a href="a_addNews.jsp" target="_blank">添加新聞</a></td>
                                <td align="center">二</td>
                                <td align="center">三</td>
                            </tr>
                        </table>
                    </body>
                </html>
                
                (6)增加新聞頁面,命名為a_addNews.jsp,能夠進行新聞的增加,在添加完信息之后,我們點擊發布之后就可以成功添加信息,其代碼如下所示,增加新聞時需要對新聞進行編輯,對于長篇幅新聞內容且含有圖片的新聞內容的編寫,在這兒我們使用功能強大的百度編輯器,首先從官網下載:百度編輯器下載,下載之后解壓,如下圖所示結構 基于jsp的新聞發布系統
                圖10 百度富文本編輯器文件夾結構圖 然后只需將整個文件夾拷貝到項目下即可,在使用時引入和修改路徑,在jsp頁面里邊我已經配置好引用,只需修改路徑即可,修改路徑時只需將editor_config.js中查找URL變量配置編輯器在你項目中的路徑。其中./ueditor為項目中的文件夾
                var URL= window.UEDITOR_HOME_URL||"./ueditor/";
                這樣就配置好了編輯器,下面就是增加新聞的jsp頁面,在添加完新聞之后,只需點擊發布即可進行新聞的發布操作,代碼如下所示:
                <%@page contentType="text/html" import="java.util.*,java.sql.*" pageEncoding="UTF-8" language="java"%>
                <%@page import="com.lut.beans.NewsRealese" %>
                <%@page import="dao.NewsRealeseDao" %>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                        <title>添加新聞- 新聞發布系統--最前沿的時尚信息、最有看點的社會聚焦、最富得浪漫的殿tang</title>
                        <!-- 配置文件 -->
                        <script type="text/javascript" src="./ueditor/ueditor.config.js"></script>
                        <!-- 編輯器源碼文件 -->
                        <script type="text/javascript" src="./ueditor/ueditor.all.js"></script>
                        <link rel="stylesheet" type="text/css" href="./udeditor/themes/default/css" />
                
                        <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>
                    </head>
                    <body id="body">
                        <form action="InsertOneNews" method="post">
                            <table  border="0" id="table">
                                <tr>
                                    <td width="5%">left</td>
                                    <td width="90%">    
                                        <table  border="1" id="table">
                                            <tr >
                                                <td >新聞編號</td> <td><input type="text" name="newsid"></td>
                                                <td>所屬新聞欄目編號</td> <td><input type="text" name="classid"></td>
                                            </tr>
                                            <tr>
                                                <td>所屬新聞分類編號</td> <td><input type="text" name="kindid"></td>
                                                <td>原創或轉載</td> <td><input type="text" name="myother"></td>
                                            </tr>
                                            <tr>
                                                <td>新聞標題</td> <td><input type="text" name="headtitle"></td>
                                                <td>相關文章</td> <td><input type="text" name="connectrealtive"></td>
                                            </tr>
                                            <tr>
                                                <td>作者</td> <td><input type="text" name="author"></td>
                                                <td>編輯</td> <td><input type="text" name="editor"></td>
                                            </tr>
                                            <tr>
                                                <td>出處</td> <td><input type="text" name="newsfrom"></td>
                                                <td>是否置頂</td> <td><input type="text" name="top"></td>
                                            </tr>
                                            <tr>
                                                <td>新聞發布時間</td> <td><input type="text" name="newstime"></td>
                                                <td>新聞點擊次數</td> <td><input type="text" name="hits"></td>
                                            </tr>
                                            <tr>
                                                <td>新聞狀態</td> <td><input type="text" name="state"></td>
                                                <td>新聞標記</td> <td><input type="text" name="tag"></td>                                                                      
                                            </tr>
                                            <tr>
                
                                        </table>
                                    </td>
                                    <td width="5%">right</td>
                                </tr>
                                <tr>
                                    <td> </td>
                                    <td>
                                        <div align="center" style="width:80%">  
                                            <textarea id="newsEditor" name="content" style="height: 80%"></textarea>  
                                            <br/>  
                                            <input type="submit" value="發 布">  
                                            <script type="text/javascript">
                                                UE.getEditor('newsEditor');
                                                // var content = UE.getPlainTxt();//content就是編輯器的帶格式的內容
                                                //focus時自動清空初始化時的內容
                
                                            </script>  
                                        </div>
                
                                    </td>
                                    <td> </td>
                                </tr>
                            </table>   
                        </form>
                    </body>
                </html>
                在增加新聞時,需要對Servlet進行配置,如下圖所示所示為配置文件的結構: 基于jsp的新聞發布系統
                插入數據Servlet結構圖 下面是InserOneNews.java代碼,能夠進行對數據的插入功能
                /*
                 * To change this license header, choose License Headers in Project Properties.
                 * To change this template file, choose Tools | Templates
                 * and open the template in the editor.
                 */
                
                package servlet;
                
                import dao.NewsRealeseDao;
                import java.io.IOException;
                import java.io.PrintWriter;
                import java.util.ArrayList;
                import java.util.logging.Level;
                import java.util.logging.Logger;
                import javax.servlet.ServletException;
                import javax.servlet.http.HttpServlet;
                import javax.servlet.http.HttpServletRequest;
                import javax.servlet.http.HttpServletResponse;
                public class InsertOneNews extends HttpServlet {
                    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        response.setContentType("text/html;charset=UTF-8");
                        try (PrintWriter out = response.getWriter()) {
                            ArrayList addnews_list = new ArrayList();
                            NewsRealeseDao newsRealeseDao = new NewsRealeseDao();
                            addnews_list.add(0, request.getParameter("newsid"));
                            addnews_list.add(1, request.getParameter("classid"));
                            addnews_list.add(2, request.getParameter("kindid"));
                            addnews_list.add(3, request.getParameter("myother"));
                            addnews_list.add(4, request.getParameter("headtitle"));
                            addnews_list.add(5, request.getParameter("content"));
                            addnews_list.add(6, request.getParameter("connectrealtive"));
                            addnews_list.add(7, request.getParameter("author"));
                            addnews_list.add(8, request.getParameter("editor"));
                            addnews_list.add(9, request.getParameter("newsfrom"));
                            addnews_list.add(10, request.getParameter("top"));
                            addnews_list.add(11, request.getParameter("newstime"));
                            addnews_list.add(12, request.getParameter("hits"));
                            addnews_list.add(13, request.getParameter("state"));
                            addnews_list.add(14,request.getParameter("tag"));
                   try {
                                 String newsRealese = newsRealeseDao.insertOneNews(addnews_list);
                                 System.out.println("String:"+newsRealese);
                                if (newsRealese!= null) {
                                    response.sendRedirect("adminManager.jsp");
                                } else {
                                    response.sendRedirect("a_addNews.jsp");
                                }
                            } catch (Exception ex) {
                                Logger.getLogger(checkLogin.class.getName()).log(Level.SEVERE, null, ex);
                            }
                        }
                    }
                    @Override
                    protected void doGet(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    protected void doPost(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    public String getServletInfo() {
                        return "Short description";
                    }
                }
                
                至此,我們完整的實現了插入工作 (7)現在完成刪除操作,在Servlet包中建立如下所示代碼,命名為DeleteOneNews.java:
                /*
                 * To change this license header, choose License Headers in Project Properties.
                 * To change this template file, choose Tools | Templates
                 * and open the template in the editor.
                 */
                
                package servlet;
                import dao.NewsRealeseDao;
                import java.io.IOException;
                import java.io.PrintWriter;
                import java.util.ArrayList;
                import java.util.logging.Level;
                import java.util.logging.Logger;
                import javax.servlet.ServletException;
                import javax.servlet.http.HttpServlet;
                import javax.servlet.http.HttpServletRequest;
                import javax.servlet.http.HttpServletResponse;
                public class DeleteOneNews extends HttpServlet {
                    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        response.setContentType("text/html;charset=UTF-8");
                        try (PrintWriter out = response.getWriter()) {
                         String str_id=request.getParameter("newsid");
                         int newsid_int=Integer.valueOf(str_id);
                           NewsRealeseDao newsRealeseDao=new NewsRealeseDao();
                   try {
                                 String newsRealese = newsRealeseDao.deleteOneNews(newsid_int);
                                 System.out.println("String:"+newsRealese);
                                if (newsRealese!= null) {
                                    response.sendRedirect("adminManager.jsp");
                                } else {
                                    response.sendRedirect("a_addNews.jsp");
                                }
                            } catch (Exception ex) {
                                Logger.getLogger(checkLogin.class.getName()).log(Level.SEVERE, null, ex);
                            }
                        }
                        }
                    
                    @Override
                    protected void doGet(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                
                    /**
                     * Handles the HTTP <code>POST</code> method.
                     *
                     * @param request servlet request
                     * @param response servlet response
                     * @throws ServletException if a servlet-specific error occurs
                     * @throws IOException if an I/O error occurs
                     */
                    @Override
                    protected void doPost(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                
                    /**
                     * Returns a short description of the servlet.
                     *
                     * @return a String containing servlet description
                     */
                    @Override
                    public String getServletInfo() {
                        return "Short description";
                    }// </editor-fold>
                
                }
                
                (8)實現查詢操作,命名為a_queryNews.jsp,其代碼如下所示:
                <%-- 
                    Document   : a_queryNews
                    Created on : 2016-5-18, 17:08:40
                    Author     : Administrator
                --%>
                
                <%@page contentType="text/html" pageEncoding="UTF-8"%>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                        <title>查詢頁面</title>
                    </head>
                    <body>
                        <table  style="width:100%;height:100%" border="0">
                            <tr>
                                <td>
                                    <form action="QueryOneNews"  method="post" target="_blank" >
                                    請輸入新聞編號:<input type="text" name="query">
                                                 <input type="submit" value="查詢" ><br>
                                    </form>
                                    <hr></td>
                            </tr>
                            <tr>
                                <td> </td>
                            </tr>
                        </table>
                
                    </body>
                </html>
                
                對于查詢這件事,有成功,有失敗,在這兒我們進行失敗后文件的設置,代碼如下所示,命名為a_queryNewsfailed.jsp,使用超級連接的方式,連接到主頁面
                <%-- 
                    Document   : a_queryNeesfailed
                    Created on : 2016-6-6, 8:43:35
                    Author     : Administrator
                --%>
                
                <%@page contentType="text/html" pageEncoding="UTF-8"%>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                        <title>查詢失敗</title>
                    </head>
                    <body>
                        <h1>沒有找到你要查找的內容,但是你可以進入</h1>
                        <a href="index.html">主頁進行查看</a>
                    </body>
                </html>
                
                實現了以上顯示層的操作之后,下面就是控制層的實現,命名為QueryOneNews.java,其代碼如下所示:
                /*
                 * To change this license header, choose License Headers in Project Properties.
                 * To change this template file, choose Tools | Templates
                 * and open the template in the editor.
                 */
                package servlet;
                import dao.NewsRealeseDao;
                import java.io.IOException;
                import java.io.PrintWriter;
                import java.util.ArrayList;
                import java.util.logging.Level;
                import java.util.logging.Logger;
                import javax.servlet.ServletException;
                import javax.servlet.http.HttpServlet;
                import javax.servlet.http.HttpServletRequest;
                import javax.servlet.http.HttpServletResponse;
                public class QueryOneNews extends HttpServlet {
                    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        response.setContentType("text/html;charset=UTF-8");
                        try (PrintWriter out = response.getWriter()) {
                         String str_id=request.getParameter("query");
                         int newsid_int=Integer.valueOf(str_id);
                           NewsRealeseDao newsRealeseDao=new NewsRealeseDao();
                   try {
                                 ArrayList newsRealese = newsRealeseDao.queryOneNews(newsid_int);
                                 char [] s1=newsRealese.toString().toCharArray();
                                 System.out.println("String+newsRealese:"+newsRealese);
                                 System.out.println("String+newsRealese:"+s1[0]+" -------"+s1[1]);
                                 if(s1[0]=='['&&s1[1]==']')
                                 {
                                      response.sendRedirect("a_queryNewsfailed.jsp");
                                    
                                } 
                                else
                                {
                                   response.sendRedirect("newRealese_detail.jsp?newsid="+str_id); 
                                }    
                            } catch (Exception ex) {
                                Logger.getLogger(checkLogin.class.getName()).log(Level.SEVERE, null, ex);
                            }
                        }
                        }
                    @Override
                    protected void doGet(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    protected void doPost(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    public String getServletInfo() {
                        return "Short description";
                    }
                
                }
                
                (9)下面實現更新數據的操作,命名為a_updateNews.jsp,其代碼如下所示:
                <%@page contentType="text/html" import="java.util.*,java.sql.*" pageEncoding="UTF-8" language="java"%>
                <%@page import="com.lut.beans.NewsRealese" %>
                <%@page import="dao.NewsRealeseDao" %>
                <!DOCTYPE html>
                <html>
                    <head>
                        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                        <title>更改新聞-</title>
                    <!-- 配置文件 -->
                    <script type="text/javascript" src="./ueditor/ueditor.config.js"></script>
                    <!-- 編輯器源碼文件 -->
                    <script type="text/javascript" src="./ueditor/ueditor.all.js"></script>
                    <link rel="stylesheet" type="text/css" href="./udeditor/themes/default/css" />
                    <link type="text/css"  rel="stylesheet"  href="newsRealese.css"/>
                    </head>
                 <body id="body">
                     <%
                         NewsRealeseDao newsRealeseDao=new NewsRealeseDao();
                         String newsid_s=request.getParameter("newsid");
                         int news_int=Integer.valueOf(newsid_s);
                         
                         ArrayList news_list=newsRealeseDao.queryOneNews(news_int);
                     %>
                                <%
                            for(int i=0;i<news_list.size();i++)
                            {
                                NewsRealese newRealese=(NewsRealese)news_list.get(i);       
                           %>
                     <form action="UpdateOneNews" method="post">
                     <table  border="0" id="table" style="width:95%">
                  <tr>
                    <td width="5%">left</td>
                    <td width="90%">    
                        <table  border="1" id="table" style="width:100%">
                            <tr >       
                            <tr>
                                <td >新聞編號</td> <td><input  type="text"  width="100%" name="newsid" value="<%=newRealese.getNewsId()  %>"></td>
                                <td>所屬新聞欄目編號</td> <td><input type="text" width="100%" name="classid" value="<%=newRealese.getClassId()  %>"></td>
                			</tr>
                			<tr>
                                <td>所屬新聞分類編號</td> <td><input type="text" width="100%" name="kindid" value="<%=newRealese.getKindId()  %>"></td>
                                <td>原創或轉載</td> <td><input type="text" width="100%" name="myother" value="<%=newRealese.getMyOther()  %>"></td>
                			</tr>
                			<tr>
                                            <td>新聞標題</td> <td><input type="text" width="100%" name="headtitle" value="<%=newRealese.getHeadTitle()%>"></td>
                                <td>相關文章</td> <td><input type="text" width="100%" name="connectrealtive"  value="<%=newRealese.getConnectRealtive()%>"></td>
                			</tr>
                			<tr>
                                <td>作者</td> <td><input type="text" width="100%" name="author"  value="<%=newRealese.getAuthor()  %>"></td>
                                <td>編輯</td> <td><input type="text" width="100%" name="editor"  value="<%=newRealese.getEditor()  %>"></td>
                			</tr>
                			<tr>
                                <td>出處</td> <td><input type="text" width="100%" name="newsfrom"  value="<%=newRealese.getNewsFrom()  %>"></td>
                		<td>是否置頂</td> <td><input type="text" width="100%" name="top"  value="<%=newRealese.getTop()  %>"></td>
                		    </tr>
                			<tr>
                                <td>新聞發布時間</td> <td><input type="text" width="100%" name="newstime"  value="<%=newRealese.getNewsTime()  %> "></td>
                                <td>新聞點擊次數</td> <td><input type="text" width="100%" name="hits"  value="<%=newRealese.getHits()  %>"></td>
                			</tr>
                			<tr>
                                <td>新聞狀態</td> <td><input type="text" name="state" width="100%"  value="<%=newRealese.getState()  %>"></td>
                                <td>新聞標記</td> <td><input type="text" width="100%" name="tag"  value="<%=newRealese.getTag()  %>"></td>                                                                      
                		    </tr>
                            <tr>
                  </table>
                	</td>
                    <td width="5%">right</td>
                  </tr>
                  <tr>
                    <td> </td>
                    <td>
                	<div align="center" style="width:80%">  
                            <textarea id="newsEditor" name="content" style="height: 80%"><%=newRealese.getContent()  %></textarea>  
                   <br/>  
                   <input type="submit" value="發 布">  
                        <script type="text/javascript">  
                            UE.getEditor('newsEditor');  
                          var content=UE.getPlainTxt();//s就是編輯器的帶格式的內容
                        </script>  
                             </div>	
                	</td>
                    <td> </td>
                  </tr>
                </table>   
                     </form>
                   <%
                            }
                   %>
                </body>
                </html>
                在Servlet中進行如下代碼所示配置:
                /*
                 * To change this license header, choose License Headers in Project Properties.
                 * To change this template file, choose Tools | Templates
                 * and open the template in the editor.
                 */
                
                package servlet;
                
                import dao.NewsRealeseDao;
                import java.io.IOException;
                import java.io.PrintWriter;
                import java.util.ArrayList;
                import java.util.logging.Level;
                import java.util.logging.Logger;
                import javax.servlet.ServletException;
                import javax.servlet.http.HttpServlet;
                import javax.servlet.http.HttpServletRequest;
                import javax.servlet.http.HttpServletResponse;
                public class UpdateOneNews extends HttpServlet {
                    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        response.setContentType("text/html;charset=UTF-8");
                        try (PrintWriter out = response.getWriter()) {
                            ArrayList addnews_list = new ArrayList();
                            NewsRealeseDao newsRealeseDao = new NewsRealeseDao();
                            addnews_list.add(0, request.getParameter("newsid"));
                            addnews_list.add(1, request.getParameter("classid"));
                            addnews_list.add(2, request.getParameter("kindid"));
                            addnews_list.add(3, request.getParameter("myother"));
                            addnews_list.add(4, request.getParameter("headtitle"));
                            addnews_list.add(5, request.getParameter("content"));
                            addnews_list.add(6, request.getParameter("connectrealtive"));
                            addnews_list.add(7, request.getParameter("author"));
                            addnews_list.add(8, request.getParameter("editor"));
                            addnews_list.add(9, request.getParameter("newsfrom"));
                            addnews_list.add(10, request.getParameter("top"));
                            addnews_list.add(11, request.getParameter("newstime"));
                            addnews_list.add(12, request.getParameter("hits"));
                            addnews_list.add(13, request.getParameter("state"));
                            addnews_list.add(14,request.getParameter("tag"));
                   try {
                                 String newsRealese = newsRealeseDao.updateOneNews(addnews_list);
                                 System.out.println("String:"+newsRealese);
                                if (newsRealese!= null) {
                                    response.sendRedirect("adminManager.jsp");
                                } else {
                                    response.sendRedirect("a_addNews.jsp");
                                }
                            } catch (Exception ex) {
                                Logger.getLogger(checkLogin.class.getName()).log(Level.SEVERE, null, ex);
                            }
                        }
                    }
                    @Override
                    protected void doGet(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    protected void doPost(HttpServletRequest request, HttpServletResponse response)
                            throws ServletException, IOException {
                        processRequest(request, response);
                    }
                    @Override
                    public String getServletInfo() {
                        return "Short description";
                    }
                }
                

                到這兒,我們已經實現了對增刪改查功能的實現,當然,基本的新聞發布功能已經實現













                1
                0
                    基于jsp的新聞發布系統轉載http://www.hxslwl.com/jiaocheng/Webqianduan/32158.html

                Web前端閱讀排行

                最新文章

                久久人人97超碰人人澡,久久人人97超碰人人澡苹果,久久人人97超碰,国产福利第一视频在线播放,大陆国产国语对白视频,亚洲香蕉网久久综合影院