基于jsp實(shí)現(xiàn)新聞管理系統(tǒng) 附完整源碼

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;
 }
 
 
}

//獲取連接 
 Class.forName("oracle.jdbc.driver.OracleDriver"); 
 String url = "jdbc:oracle:thin:@localhost:1521:orcl"; 
conn = DriverManager.getConnection(url, "scott", "wjk139"); 

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");
 //運(yùn)行SQL語(yǔ)句 
 String sql = "select * from newmessage";//獲取
 Statement stat = conn.createStatement();
 ResultSet rs = stat.executeQuery(sql);
 while (rs.next()) { //實(shí)例化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 {//關(guān)閉連接
 if (conn != null) {
 conn.close();
 conn = null;
 }
 } catch (Exception ex) {
 }
 return newsRealese;
 }
 }
 //查詢一個(gè)消息
 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");//不安全
 //運(yùn)行SQL語(yǔ)句 
 Statement stat = conn.createStatement();
 String sql = "select * from newmessage where newsid=?";//獲取newsid，使用？代替字符串，以免會(huì)發(fā)生錯(cuò)誤
 PreparedStatement ps = conn.prepareStatement(sql);
 ps.setInt(1, Integer.valueOf(newsid));
 ResultSet rs = ps.executeQuery();// 之前已經(jīng)給了sql字符串，所以executeUpdate是無(wú)參的。 
 while (rs.next()) { //實(shí)例化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 {//關(guān)閉連接
 if (conn != null) {
 conn.close();
 conn = null;
 }
 } catch (Exception ex) {
 }
 return newsRealese;
 }
 }
 //刪除數(shù)據(jù)
 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");//不安全
 //運(yùn)行SQL語(yǔ)句 
 Statement stat = conn.createStatement();
 String sql = "DELETE FROM newmessage WHERE newsid =?";//獲取newsid，使用？代替字符串，以免會(huì)發(fā)生錯(cuò)誤
 PreparedStatement ps = conn.prepareStatement(sql);
 ps.setInt(1, Integer.valueOf(newsid));
 ResultSet rs = ps.executeQuery();// 之前已經(jīng)給了sql字符串，所以executeUpdate是無(wú)參的。 
 rs.close();
 stat.close();
 } catch (Exception e1) {
 e1.printStackTrace();
 } finally {
 try {//關(guān)閉連接
 if (conn != null) {
 conn.close();
 conn = null;
 }
 } catch (Exception ex) {
 }
 return newsRealese.toString();
 }
 }
 //插入數(shù)據(jù)
 public String insertOneNews(ArrayList addnews_list) throws Exception {
 Connection conn = null;
 /* for(int i=0,j=1;iaddnews_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");//不安全
 //運(yùn)行SQL語(yǔ)句 
 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，使用？代替字符串，以免會(huì)發(fā)生錯(cuò)誤
 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 {//關(guān)閉連接
 if (conn != null) {
 conn.close();
 conn = null;
 }
 } catch (Exception ex) {
 }
 }
 return conn.toString();
 }
 //更新數(shù)據(jù)
 public String updateOneNews(ArrayList addnews_list) throws Exception {
 Connection conn = null;
 /* for(int i=0,j=1;iaddnews_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");//不安全
 //運(yùn)行SQL語(yǔ)句 
 Statement stat = conn.createStatement();
 //獲取newsid，使用？代替字符串，以免會(huì)發(fā)生錯(cuò)誤
 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 {//關(guān)閉連接
 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;
 } 
}

!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>新聞發(fā)布系統(tǒng)--最前沿的時(shí)尚信息、最有看點(diǎn)的社會(huì)聚焦、最富得浪漫的殿堂/title>
 /head>
 body id="body">
 正在跳轉(zhuǎn)...,請(qǐng)等待...
 script language="javascript" type="text/javascript">
 window.location.href="newRealese_brief.jsp"; 
 /script>
 /body>
/html>

%@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>新聞發(fā)布系統(tǒng)--最前沿的時(shí)尚信息、最有看點(diǎn)的社會(huì)聚焦、最富得浪漫的殿堂/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%">nbsp;/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>此處假設(shè)無(wú)圖片/p>
 p>此處假設(shè)無(wú)等級(jí)信息/p>
 /td>
 td >table border="0" width="100%">
 tr>
 td width="11%" >原創(chuàng)或轉(zhuǎn)載:/td>
 td colspan="3">%=newRealese.getMyOther()%> /td>
 td width="10%" >新聞標(biāo)題:/td>
 td width="44%" >%=newRealese.getHeadTitle()%> /td>
 /tr>
 tr> 
 td colspan="6">新聞內(nèi)容:/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">新聞發(fā)布時(shí)間:/td>
 td width="167">%=newRealese.getNewsTime()%> /td>
 td width="99">新聞點(diǎn)擊次數(shù):/td>
 td width="191">%=newRealese.getHits()%> /td>
 /tr> 
 /table>/td>
 /tr>
 tr>
 td height="21" colspan="2">hr>/td>
 /tr>
 /table>/center>
 %
 }
 %>
 /td>
 td>nbsp;/td>
 /tr>
 tr>
 td>nbsp;/td>
 td>nbsp;/td>
 td>nbsp;/td>
 /tr>
/table>
/body>
/html>

%@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>新聞發(fā)布系統(tǒng)--最前沿的時(shí)尚信息、最有看點(diǎn)的社會(huì)聚焦、最值得浪漫的殿堂/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 >新聞編號(hào)/td>
 td>所屬新聞欄目編號(hào)/td>
 td>所屬新聞分類編號(hào)/td>
 td>原創(chuàng)或轉(zhuǎn)載/td>
 td>新聞標(biāo)題/td>
 td>新聞內(nèi)容/td>
 td>相關(guān)文章/td>
 td>作者/td>
 td>編輯/td>
 td>出處/td>
 td>是否置頂/td>
 td>新聞發(fā)布時(shí)間/td>
 td>新聞點(diǎn)擊次數(shù)/td>
 td>新聞狀態(tài)/td>
 td>新聞標(biāo)記/td>  
 /tr>
 %
 for(int i=0;inewsRealese.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">新聞標(biāo)題: /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">新聞發(fā)布時(shí)間: /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">新聞點(diǎn)擊次數(shù): /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>nbsp;/p> 
 table>
 tr>
 td >
 a href="newRealese_brief.jsp">返回/a>
 /td>
 td>
 a href="#">發(fā)表評(píng)論/a>
 /td>
 /tr> 
 /table> 
 /td>
 /tr>
/table>
table width="100%" border="0" cellspacing="0" cellpadding="4">
 tr style="text-align: right">
 td> a href="#">點(diǎn)贊/a> a href="#">舉報(bào)/a> a href="#">投稿，聯(lián)系作者/a>nbsp; /td>
 /tr>
/table>
 %
 }
 %>
/body>
/html>

%@ 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>新聞發(fā)布系統(tǒng)--最前沿的時(shí)尚信息、最有看點(diǎn)的社會(huì)聚焦、最值得浪漫的殿堂/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>

/*
 * 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>
}

%-- 
 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>此處假設(shè)無(wú)圖片/p>
 p>此處假設(shè)無(wú)等級(jí)信息/p> /td>
 td >table border="0" width="100%">
 tr>
 td >原創(chuàng)或轉(zhuǎn)載:/td>
 td >%=newRealese.getMyOther()%> /td>
 td >新聞標(biāo)題:/td>
 td >%=newRealese.getHeadTitle()%> /td>
 /tr>
 tr> 
 td colspan="6">新聞內(nèi)容:/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">新聞發(fā)布時(shí)間:/td>
 td width="167">%=newRealese.getNewsTime()%> /td>
 td width="99">新聞點(diǎn)擊次數(shù):/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>

%@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>添加新聞- 新聞發(fā)布系統(tǒng)--最前沿的時(shí)尚信息、最有看點(diǎn)的社會(huì)聚焦、最富得浪漫的殿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 >新聞編號(hào)/td> td>input type="text" name="newsid">/td>
 td>所屬新聞欄目編號(hào)/td> td>input type="text" name="classid">/td>
 /tr>
 tr>
 td>所屬新聞分類編號(hào)/td> td>input type="text" name="kindid">/td>
 td>原創(chuàng)或轉(zhuǎn)載/td> td>input type="text" name="myother">/td>
 /tr>
 tr>
 td>新聞標(biāo)題/td> td>input type="text" name="headtitle">/td>
 td>相關(guān)文章/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>新聞發(fā)布時(shí)間/td> td>input type="text" name="newstime">/td>
 td>新聞點(diǎn)擊次數(shù)/td> td>input type="text" name="hits">/td>
 /tr>
 tr>
 td>新聞狀態(tài)/td> td>input type="text" name="state">/td>
 td>新聞標(biāo)記/td> td>input type="text" name="tag">/td> 
 /tr>
 tr>

 /table>
 /td>
 td width="5%">right/td>
 /tr>
 tr>
 td>nbsp;/td>
 td>
 div align="center" style="width:80%"> 
 textarea id="newsEditor" name="content" style="height: 80%">/textarea> 
 br/> 
 input type="submit" value="發(fā) 布"> 
 script type="text/javascript">
 UE.getEditor('newsEditor');
 // var content = UE.getPlainTxt();//content就是編輯器的帶格式的內(nèi)容
 //focus時(shí)自動(dòng)清空初始化時(shí)的內(nèi)容

 /script> 
 /div>

 /td>
 td>nbsp;/td>
 /tr>
 /table> 
 /form>
 /body>
/html>

/*
 * 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";
 }
}

/*
 * 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>

}

%-- 
 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>查詢頁(yè)面/title>
 /head>
 body>
 table style="width:100%;height:100%" border="0">
 tr>
 td>
 form action="QueryOneNews" method="post" target="_blank" >
 請(qǐng)輸入新聞編號(hào)：input type="text" name="query">
 input type="submit" value="查詢" >br>
 /form>
 hr>/td>
 /tr>
 tr>
 td>nbsp;/td>
 /tr>
 /table>

 /body>
/html>

%-- 
 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>沒(méi)有找到你要查找的內(nèi)容，但是你可以進(jìn)入/h1>
 a href="index.html">主頁(yè)進(jìn)行查看/a>
 /body>
/html>

/*
 * 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";
 }

}

%@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;inews_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 >新聞編號(hào)/td> td>input type="text" width="100%" name="newsid" value="%=newRealese.getNewsId() %>">/td>
 td>所屬新聞欄目編號(hào)/td> td>input type="text" width="100%" name="classid" value="%=newRealese.getClassId() %>">/td>
 /tr>
 tr>
 td>所屬新聞分類編號(hào)/td> td>input type="text" width="100%" name="kindid" value="%=newRealese.getKindId() %>">/td>
 td>原創(chuàng)或轉(zhuǎn)載/td> td>input type="text" width="100%" name="myother" value="%=newRealese.getMyOther() %>">/td>
 /tr>
 tr>
 td>新聞標(biāo)題/td> td>input type="text" width="100%" name="headtitle" value="%=newRealese.getHeadTitle()%>">/td>
 td>相關(guān)文章/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>新聞發(fā)布時(shí)間/td> td>input type="text" width="100%" name="newstime" value="%=newRealese.getNewsTime() %> ">/td>
 td>新聞點(diǎn)擊次數(shù)/td> td>input type="text" width="100%" name="hits" value="%=newRealese.getHits() %>">/td>
 /tr>
 tr>
 td>新聞狀態(tài)/td> td>input type="text" name="state" width="100%" value="%=newRealese.getState() %>">/td>
 td>新聞標(biāo)記/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>nbsp;/td>
 td>
 div align="center" style="width:80%"> 
 textarea id="newsEditor" name="content" style="height: 80%">%=newRealese.getContent() %>/textarea> 
 br/> 
 input type="submit" value="發(fā) 布"> 
 script type="text/javascript"> 
 UE.getEditor('newsEditor'); 
 var content=UE.getPlainTxt();//s就是編輯器的帶格式的內(nèi)容
 /script> 
 /div> 
 /td>
 td>nbsp;/td>
 /tr>
/table> 
 /form>
 %
 }
 %>
/body>
/html>

/*
 * 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";
 }
}