視圖部分 
 
/RSSreader/WebContent/rsscontent.jsp： 
 
%@page contentType="text/html"%> 
 
%@page pageEncoding="UTF-8" import="java.text.SimpleDateFormat"%> 
 
html> 
 
script language=javascript> 
 
function setCheck(){ 
 
 var newWindow=document.getElementById("newWindow").value; 
 
 if(newWindow==0) 
 
 { 
 
  document.getElementById("check").checked=true; 
 
 } 
 
 else 
 
 { 
 
 document.getElementById("check").checked=false; 
 
 } 
 
} 
 
 
 
function check(){ 
 
var check=document.getElementById("check").checked; 
 
var feed=document.getElementById("feed").value; 
 
var url="rsscontent.jsp?feed="+feed; 
 
if(check) 
 
 { 
 
 document.cookie="newWindow=0"; 
 
 } 
 
else 
 
 { 
 
 document.cookie="newWindow=1"; 
 
 } 
 
self.location=url; 
 
} 
 
/script> 
 
 
 
body onload="setCheck()"> 
 
 
 
% 
 
String pageTitle=""; 
 
String urlStr = request.getParameter("feed"); 
 
String target=""; 
 
 
 
Cookie cookies[]=request.getCookies(); //讀出用戶硬盤上的Cookie，并將所有的Cookie放到一個(gè)cookie對象數(shù)組里面 
 
Cookie sCookie=null; 
 
for(int i=0;icookies.length;i++){ //用一個(gè)循環(huán)語句遍歷剛才建立的Cookie對象數(shù)組 
 
sCookie=cookies[i]; //取出數(shù)組中的一個(gè)Cookie對象 
 
if(sCookie!=null){ 
 
  
 
if(("newWindow").equals(sCookie.getName())){ 
 
  pageContext.setAttribute("newWindow",sCookie.getValue()); 
 
  System.out.println(pageContext.getAttribute("newWindow")); 
 
  } 
 
} 
 
} 
 
if(pageContext.getAttribute("newWindow")!=null) 
 
{ 
 
if(pageContext.getAttribute("newWindow").equals("0")){ 
 
 target="_blank"; 
 
} 
 
else{ 
 
 target="_self"; 
 
} 
 
} 
 
 
 
try{ 
 
/* java.util.Properties systemSettings = System.getProperties(); 
 
systemSettings.put("http.proxyHost", "mywebcache.com"); 
 
systemSettings.put("http.proxyPort", "8080"); 
 
System.setProperties(systemSettings); */ 
 
if (!urlStr.startsWith("http://")) 
 
  urlStr = "http://"+request.getParameter("feed"); 
 
//String urlStr = "http://feed.cnblogs.com/blog/u/249598/rss"; 
 
System.out.println(urlStr); 
 
java.net.URLConnection feedUrl = new java.net.URL(urlStr).openConnection(); 
 
feedUrl.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)"); 
 
com.sun.syndication.io.SyndFeedInput input = new com.sun.syndication.io.SyndFeedInput(); 
 
com.sun.syndication.feed.synd.SyndFeed feed = input.build(new com.sun.syndication.io.XmlReader(feedUrl)); 
 
pageTitle=feed.getTitle(); 
 
 
 
%> 
 
div align="center"> 
 
h1>%=pageTitle%>/h1> 
 
 
 
input type="hidden" id="feed" value=%=urlStr %>> 
 
input type="hidden" id="newWindow" value=%=pageContext.getAttribute("newWindow")%>> 
 
input type=checkbox name="check" id="check" onclick="check()">在新窗口中打開(部分網(wǎng)頁不支持在框架中顯示，請嘗試勾選此項(xiàng))/input> 
 
table border=1 cellpadding=3 cellspacing="0"> 
 
tr> 
 
th>序號(hào)/th> 
 
th>標(biāo)題/th> 
 
th>發(fā)布時(shí)間/th> 
 
/tr> 
 
% 
 
String date="無"; 
 
java.util.List list = feed.getEntries(); 
 
for (int i=0; i list.size(); i++) { 
 
com.sun.syndication.feed.synd.SyndEntry entry = (com.sun.syndication.feed.synd.SyndEntry)list.get(i); 
 
SimpleDateFormat sdf = new SimpleDateFormat(); 
 
sdf.applyPattern("yyyy年MM月dd日 HH:mm"); 
 
if(entry.getPublishedDate()!=null) 
 
{ 
 
 date=sdf.format(entry.getPublishedDate()); 
 
} 
 
%> 
 
tr> 
 
td>%=i+1%>/td> 
 
td>a id="entry" href="%=entry.getLink()%>" target=%=target %>>%=entry.getTitle()%>/a>/td> 
 
td>%=date %>/td> 
 
/tr> 
 
% 
 
} 
 
} catch (Exception e) { 
 
 // TODO Auto-generated catch block 
 
 response.sendRedirect("tips.jsp?type=rssContentfail"); 
 
 e.printStackTrace(); 
 
} 
 
%> 
 
/table> 
 
/div> 
 
br> 
 
/body> 
 
head> 
 
meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
 
title>%=pageTitle%>/title> 
 
/head> 
 
/html> 
 
/RSSreader/WebContent/addGroup.jsp： 
 
%@ page language="java" contentType="text/html; charset=utf-8" 
 
pageEncoding="utf-8" import="com.JDBConnection,java.sql.ResultSet,com.dataHelper,java.util.ArrayList"%> 
 
!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
 
html> 
 
head> 
 
meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 
 
title>添加分組/title> 
 
link href="css/tab.css" type="text/css" rel="stylesheet" /> 
 
script type="text/javascript" src="js/jquery.js">/script> 
 
/head> 
 
% 
 
String lastAdd = request.getParameter("lastAdd"); 
 
String from = request.getParameter("from"); 
 
String tip=""; 
 
String backurl=""; 
 
String backname=""; 
 
if(lastAdd!=null){ 
 
  String name =new String(request.getParameter("name").getBytes("ISO8859_1"), "utf-8"); 
 
  if(lastAdd.equals("ture")){ 
 
   tip="成功添加分組："+name;  
 
  } 
 
  if(lastAdd.equals("false")){ 
 
   tip="添加分組失敗";  
 
  }  
 
 } 
 
  
 
%> 
 
body onunload="javascript:;window.opener.location.reload()"> 
 
div id="wrapper"> 
 
div align="center"> 
 
div>a href="addRss.jsp">添加源/a> | 添加分組/div> 
 
form name="form_addGroup" method="post" action="dealAddGroup"> 
 
  table border="0" align="center"> 
 
 tr> 
 
 td height="30">組名：/td> 
 
 td height="30"> 
 
 input type="text" size="40" name="gname"> 
 
 input type="hidden" name="uid" value="%=session.getAttribute("uid")%>"> 
 
 /td> 
 
 /tr> 
 
 tr> 
 
 td> /td> 
 
 td>%=tip %>/td> 
 
 /tr> 
 
tr> 
 
 td height="30"> /td> 
 
 td height="30" align="right">input type="submit" name="Submit" value="添加">/td> 
 
 /tr> 
 
 /table> 
 
  /form> 
 
/div> 
 
/div> 
 
/body> 
 
/html> 
 
/RSSreader/WebContent/addRss.jsp： 
 
%@ page language="java" contentType="text/html; charset=utf-8" 
 
pageEncoding="utf-8" import="com.JDBConnection,java.sql.ResultSet,com.dataHelper,java.util.ArrayList"%> 
 
!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
 
html> 
 
head> 
 
meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 
 
title>添加RSS源/title> 
 
link href="css/tab.css" type="text/css" rel="stylesheet" /> 
 
script type="text/javascript" src="js/jquery.js">/script> 
 
/head> 
 
% 
 
String lastAdd = request.getParameter("lastAdd"); 
 
String title =""; 
 
String url =""; 
 
String tip=""; 
 
String Sgid=""; 
 
 
 
if(request.getParameter("title")!=null) 
 
{ 
 
  title=new String(request.getParameter("title").getBytes("ISO8859_1"), "utf-8"); 
 
} 
 
if(request.getParameter("url")!=null) 
 
{ 
 
  url=request.getParameter("url"); 
 
} 
 
if(request.getParameter("group")!=null) 
 
{ 
 
  Sgid=request.getParameter("group"); 
 
} 
 
if(lastAdd!=null){ 
 
  String name =new String(request.getParameter("name").getBytes("ISO8859_1"), "utf-8"); 
 
  if(lastAdd.equals("ture")){ 
 
   tip="成功添加RSS源："+name;  
 
  } 
 
  if(lastAdd.equals("false")){ 
 
   tip="添加RSS源失敗";  
 
  }  
 
 } 
 
%> 
 
 
 
body onload="document.all.group.value = %=Sgid%>" onunload="javascript:;window.opener.location.reload()"> 
 
div id="wrapper"> 
 
div align="center"> 
 
div>添加源 | a href="addGroup.jsp">添加分組/a>/div> 
 
form name="form_addRss" method="post" action="dealAddRss"> 
 
  input type="hidden" name="from" value="addRss"> 
 
  table border="0" align="center"> 
 
 tr> 
 
 td height="30">Feed地址：/td> 
 
 td height="30">input type="text" size="40" name="url" value=%=url %>>/td> 
 
 /tr> 
 
 tr> 
 
 td height="30">標(biāo)題：/td> 
 
 td height="30"> 
 
  input type="text" name="title" value=%=title%>>  
 
  input align="right" type=button name="getTitle" value=" 從feed中提取" onclick="form_addRss.action='getFeedTitle';form_addRss.submit()"> 
 
 /td> 
 
 /tr> 
 
 tr> 
 
   td>分組:/td> 
 
   td> 
 
   select name="group"> 
 
   % 
 
    
 
    int gid; 
 
    String gname; 
 
    int uid; 
 
    Object memo; 
 
    int i; 
 
    
 
   dataHelper dhp=new dataHelper(); 
 
   ArrayListdataHelper.Group> groupList =dhp.getGroup((Integer)session.getAttribute("uid")); 
 
   for(i=0;igroupList.size();i++) 
 
   { 
 
    dataHelper.Group group=groupList.get(i); 
 
   %> 
 
    
 
   option value="%=group.getGid()%>">%=group.getGname()%>/option> 
 
    
 
   % 
 
   } 
 
   %> 
 
   /select> 
 
   /td> 
 
 /tr> 
 
 tr> 
 
 td> /td> 
 
 td>%=tip %>/td> 
 
 /tr> 
 
 tr> 
 
 td height="30"> /td> 
 
 td height="30" align="right">input type="submit" name="Submit" value="添加" onclick="form_addRss.action='dealAddRss'">/td> 
 
 /tr> 
 
 /table> 
 
  /form> 
 
/div> 
 
div align="center"> 
 
 
 
 /div> 
 
 /div> 
 
/body> 
 
/html> 
 
/RSSreader/WebContent/delete.jsp： 
 
%@ page language="java" contentType="text/html; charset=utf-8" 
 
pageEncoding="utf-8" import="com.JDBConnection,java.sql.ResultSet"%> 
 
!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
 
html> 
 
head> 
 
meta http-equiv="Content-Type" content="text/html; utf-8"> 
 
title>editGroup/title> 
 
/head> 
 
body> 
 
div align="center"> 
 
% 
 
String name=(String)session.getAttribute("name"); 
 
String nickname=""; 
 
if(name==null) 
 
{ 
 
  response.sendRedirect("index.jsp"); 
 
} 
 
%> 
 
 
 
% 
 
 String gid =request.getParameter("gid"); 
 
 String lid =request.getParameter("lid"); 
 
 String type =request.getParameter("type"); 
 
 String url=""; 
 
 //DELETE FROM 表名稱 WHERE 列名稱 = 值 
 
 String sSql=""; 
 
 if(type!=null){ 
 
   if(type.equals("g")){ 
 
    sSql="delete from rssGroup where gid="+gid; 
 
    url="manage.jsp"; 
 
   } 
 
   if(type.equals("r")){ 
 
    sSql="delete from rssList where lid="+lid; 
 
    url="rssListOfGroup.jsp?gid="+gid; 
 
   }  
 
  } 
 
 System.out.println("rssListOfGroup.Sql:"+sSql); 
 
 JDBConnection JDBC=new JDBConnection(); 
 
 if(JDBC.executeUpdate(sSql)){ 
 
  out.print("刪除成功"); 
 
 } 
 
 else{ 
 
  out.print("刪除失敗"); 
 
   
 
 } 
 
%> 
 
 
 
/div> 
 
br> 
 
div align="center"> 
 
a href=%=url %>>返回/a> 
 
/div> 
 
/body> 
 
/html> 
 
JAVA部分 
 
/RSSreader/src/com/JDBConnection.java 
 
package com; 
 
 
 
import java.sql.*; 
 
 
 
public class JDBConnection { 
 
private final String url = "jdbc:sqlserver://localhost:1433;DatabaseName=RSSreader"; 
 
private final String userName = "sa"; 
 
private final String password = "123456"; 
 
private Connection con = null; 
 
//通過構(gòu)造方法加載數(shù)據(jù)庫驅(qū)動(dòng) 
 
static { 
 
try { 
 
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
 
} catch (Exception ex) { 
 
System.out.println("數(shù)據(jù)庫加載失敗"); 
 
} 
 
} 
 
//創(chuàng)建數(shù)據(jù)庫連接 
 
public boolean creatConnection() { 
 
try { 
 
con = DriverManager.getConnection(url, userName, password); 
 
con.setAutoCommit(true); 
 
 
 
} catch (SQLException e) { 
 
System.out.println(e.getMessage()); 
 
System.out.println("creatConnectionError!"); 
 
} 
 
return true; 
 
} 
 
 
 
public void close(Connection con,Statement stmt,PreparedStatement pst,ResultSet rs){ 
 
if(rs!=null){ 
 
try { 
 
rs.close(); 
 
} catch (SQLException e) { 
 
// TODO Auto-generated catch block 
 
e.printStackTrace(); 
 
} 
 
} 
 
 
 
if(stmt!=null){ 
 
try { 
 
stmt.close(); 
 
} catch (SQLException e) { 
 
// TODO Auto-generated catch block 
 
e.printStackTrace(); 
 
} 
 
} 
 
if(pst!=null){ 
 
try { 
 
pst.close(); 
 
} catch (SQLException e) { 
 
// TODO Auto-generated catch block 
 
e.printStackTrace(); 
 
} 
 
} 
 
 
 
if(con!=null){ 
 
try { 
 
con.close(); 
 
} catch (SQLException e) { 
 
// TODO Auto-generated catch block 
 
e.printStackTrace(); 
 
} 
 
} 
 
} 
 
public void closeConnection(){ 
 
if(con!=null){ 
 
try { 
 
con.close(); 
 
} catch (SQLException e) { 
 
// TODO Auto-generated catch block 
 
e.printStackTrace(); 
 
} 
 
} 
 
} 
 
//對數(shù)據(jù)庫的增加、修改和刪除的操作 
 
public boolean executeUpdate(String sql) { 
 
if (con == null) { 
 
creatConnection(); 
 
} 
 
try { 
 
Statement stmt = con.createStatement(); 
 
int iCount = stmt.executeUpdate(sql); 
 
System.out.println("操作成功，所影響的記錄數(shù)為" + String.valueOf(iCount)); 
 
this.close(con, stmt,null, null); 
 
return true; 
 
} catch (SQLException e) { 
 
System.out.println(e.getMessage()); 
 
   return false; 
 
 
 
} 
 
} 
 
//對數(shù)據(jù)庫的查詢操作 
 
public ResultSet executeQuery(String sql) { 
 
ResultSet rs; 
 
 
 
try { 
 
if (con == null) { 
 
creatConnection(); 
 
} 
 
Statement stmt = con.createStatement(); 
 
try { 
 
rs = stmt.executeQuery(sql); 
 
 
 
} catch (SQLException e) { 
 
System.out.println(e.getMessage()); 
 
return null; 
 
} 
 
} catch (SQLException e) { 
 
System.out.println(e.getMessage()); 
 
System.out.println("executeQueryError!"); 
 
return null; 
 
} 
 
return rs; 
 
} 
 
} 
 
/RSSreader/src/com/SqlFilter.java 
 
package com; 
 
import java.io.IOException; 
 
import java.util.Enumeration; 
 
import javax.servlet.Filter; 
 
import javax.servlet.FilterChain; 
 
import javax.servlet.FilterConfig; 
 
import javax.servlet.ServletException; 
 
import javax.servlet.ServletRequest; 
 
import javax.servlet.ServletResponse; 
 
import javax.servlet.http.HttpServletRequest; 
 
import javax.servlet.http.HttpServletResponse; 
 
 
 
//過濾sql關(guān)鍵字的Filter 
 
public class SqlFilter implements Filter { 
 
 
 
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { 
 
 
 
HttpServletRequest req = (HttpServletRequest) request; 
 
HttpServletResponse res = (HttpServletResponse) response; 
 
//獲得所有請求參數(shù)名 
 
Enumeration params = req.getParameterNames(); 
 
 
 
String sql = ""; 
 
while (params.hasMoreElements()) { 
 
//得到參數(shù)名 
 
String name = params.nextElement().toString(); 
 
//System.out.println("name===========================" + name + "--"); 
 
//得到參數(shù)對應(yīng)值 
 
String[] value = req.getParameterValues(name); 
 
for (int i = 0; i  value.length; i++) { 
 
sql = sql + value[i]; 
 
} 
 
} 
 
System.out.println("被匹配字符串："+sql); 
 
if (sqlValidate(sql)) { 
 
res.sendRedirect("error.jsp"); 
 
} else { 
 
chain.doFilter(req, res); 
 
} 
 
} 
 
 
 
//效驗(yàn) 
 
protected static boolean sqlValidate(String str) { 
 
str = str.toLowerCase();//統(tǒng)一轉(zhuǎn)為小寫 
 
//String badStr = "and|exec"; 
 
String badStr = "'|and|exec|execute|insert|select|delete|update|count|drop|chr|mid|master|truncate|char|declare|sitename|net user|xp_cmdshell|or|like"; 
 
/*String badStr = "'|and|exec|execute|insert|create|drop|table|from|grant|use|group_concat|column_name|" + 
 
"information_schema.columns|table_schema|union|where|select|delete|update|order|by|count|*|" + 
 
"chr|mid|master|truncate|char|declare|or|;|-|--|+|,|like|//|/|%|#"; */ //過濾掉的sql關(guān)鍵字，可以手動(dòng)添加 
 
String[] badStrs = badStr.split("\\|"); 
 
for (int i = 0; i  badStrs.length; i++) { 
 
if (str.indexOf(badStrs[i]) !=-1) { 
 
 System.out.println("匹配到："+badStrs[i]); 
 
 return true; 
 
} 
 
} 
 
return false; 
 
} 
 
 
 
public void init(FilterConfig filterConfig) throws ServletException { 
 
//throw new UnsupportedOperationException("Not supported yet."); 
 
} 
 
 
 
public void destroy() { 
 
//throw new UnsupportedOperationException("Not supported yet."); 
 
} 
 
} 
 
 
 
/RSSreader/src/dataCtrl/addGroup.java 
 
package dataCtrl; 
 
 
 
import com.JDBConnection; 
 
 
 
public class addGroup { 
 
 private String gname; 
 
 private String uid; 
 
 
 
 public String getGname() { 
 
  return gname; 
 
 } 
 
 public void setGname(String gname) { 
 
  this.gname = gname; 
 
 } 
 
  
 
 public String getUid() { 
 
  return uid; 
 
 } 
 
 public void setUid(String uid) { 
 
  this.uid = uid; 
 
 } 
 
 
 
 public boolean doAddGroup(){ 
 
  String sSql = "insert into rssGroup(gname,uid) values('"+gname+"',"+uid+")"; 
 
  System.out.println(sSql); 
 
  JDBConnection JDBC=new JDBConnection(); 
 
  return JDBC.executeUpdate(sSql);  
 
 } 
 
} 
 
/RSSreader/src/dataCtrl/addRss.java 
 
package dataCtrl; 
 
 
 
import java.sql.*; 
 
import com.JDBConnection; 
 
import javafx.beans.property.adapter.JavaBeanProperty; 
 
 
 
public class addRss { 
 
 private String title; 
 
 private String url; 
 
 private String gid; 
 
 public String getTitle() { 
 
  return title; 
 
 } 
 
 public void setTitle(String title) { 
 
  this.title = title; 
 
 } 
 
 public String getUrl() { 
 
  return url; 
 
 } 
 
 public void setUrl(String url) { 
 
  this.url = url; 
 
 } 
 
 public String getGid() { 
 
  return gid; 
 
 } 
 
 public void setGid(String gid) { 
 
  this.gid = gid; 
 
 } 
 
  
 
 public boolean doAddRss() throws SQLException{ 
 
  //INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....); 
 
  String sSql = "insert into rssList(title,url,gid) values('"+title+"','"+url+"',"+gid+")"; 
 
  System.out.println(sSql); 
 
  JDBConnection JDBC=new JDBConnection(); 
 
  return JDBC.executeUpdate(sSql); 
 
 } 
 
} 
 
/RSSreader/src/dataCtrl/dealaddGroup.java 
 
package dataCtrl; 
 
 
 
import java.io.IOException; 
 
import java.sql.SQLException; 
 
import javax.servlet.ServletException; 
 
import javax.servlet.annotation.WebServlet; 
 
import javax.servlet.http.HttpServlet; 
 
import javax.servlet.http.HttpServletRequest; 
 
import javax.servlet.http.HttpServletResponse; 
 
 
 
/** 
 
* Servlet implementation class dealaddGroup 
 
*/ 
 
@WebServlet("/dealaddGroup") 
 
public class dealaddGroup extends HttpServlet { 
 
 private static final long serialVersionUID = 1L; 
 
 
 
/** 
 
* @see HttpServlet#HttpServlet() 
 
*/ 
 
public dealaddGroup() { 
 
super(); 
 
// TODO Auto-generated constructor stub 
 
} 
 
 
 
 /** 
 
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  response.getWriter().append("Served at: ").append(request.getContextPath()); 
 
 } 
 
 
 
 /** 
 
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
   
 
  String gname=request.getParameter("gname"); 
 
  String sgname =new String(gname.getBytes("ISO8859_1"), "utf-8"); 
 
  String uid=request.getParameter("uid"); 
 
  addGroup adgp=new addGroup(); 
 
  adgp.setGname(sgname); 
 
  adgp.setUid(uid); 
 
  if(adgp.doAddGroup()){ 
 
 request.getRequestDispatcher("/addGroup.jsp?name="+gname+"lastAdd=ture").forward(request,response); 
 
   //response.sendRedirect("index.jsp"); 
 
  } 
 
  else{ 
 
 request.getRequestDispatcher("/addGroup.jsp?name="+gname+"lastAdd=false").forward(request,response); 
 
  } 
 
  doGet(request, response); 
 
 } 
 
} 
 
/RSSreader/src/dataCtrl/dealAddRss.java 
 
package dataCtrl; 
 
 
 
import java.io.IOException; 
 
import java.sql.SQLException; 
 
import javax.servlet.ServletException; 
 
import javax.servlet.annotation.WebServlet; 
 
import javax.servlet.http.HttpServlet; 
 
import javax.servlet.http.HttpServletRequest; 
 
import javax.servlet.http.HttpServletResponse; 
 
 
 
/** 
 
* Servlet implementation class dealAddRss1 
 
*/ 
 
@WebServlet("/dealAddRss1") 
 
public class dealAddRss extends HttpServlet { 
 
 private static final long serialVersionUID = 1L; 
 
 
 
/** 
 
* @see HttpServlet#HttpServlet() 
 
*/ 
 
public dealAddRss() { 
 
super(); 
 
// TODO Auto-generated constructor stub 
 
} 
 
 
 
 /** 
 
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  response.getWriter().append("Served at: ").append(request.getContextPath()); 
 
 } 
 
 
 
 /** 
 
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  //response.setContentType("text/html;charset=utf-8"); 
 
   
 
  String title=request.getParameter("title"); 
 
  String stitle =new String(title.getBytes("ISO8859_1"), "utf-8"); 
 
  String url =request.getParameter("url"); 
 
  String gid=request.getParameter("group"); 
 
  addRss adrs=new addRss(); 
 
  adrs.setTitle(stitle); 
 
  adrs.setUrl(url); 
 
  adrs.setGid(gid); 
 
  try { 
 
   if(adrs.doAddRss()){ 
 
    request.getRequestDispatcher("/addRss.jsp?name="+title+"lastAdd=ture").forward(request,response); 
 
    //response.sendRedirect("index.jsp"); 
 
   } 
 
   else{ 
 
    request.getRequestDispatcher("/addRss.jsp?name="+title+"lastAdd=false").forward(request,response); 
 
     
 
   } 
 
  } catch (SQLException e) { 
 
   // TODO Auto-generated catch block 
 
   e.printStackTrace(); 
 
  } 
 
  doGet(request, response); 
 
 } 
 
} 
 
/RSSreader/src/dataCtrl/getFeedTitle.java 
 
package dataCtrl; 
 
 
 
import java.io.IOException; 
 
import javax.servlet.ServletException; 
 
import javax.servlet.annotation.WebServlet; 
 
import javax.servlet.http.HttpServlet; 
 
import javax.servlet.http.HttpServletRequest; 
 
import javax.servlet.http.HttpServletResponse; 
 
import com.sun.syndication.io.FeedException; 
 
 
 
/** 
 
* Servlet implementation class getFeedTitle 
 
*/ 
 
@WebServlet("/getFeedTitle") 
 
public class getFeedTitle extends HttpServlet { 
 
 private static final long serialVersionUID = 1L; 
 
 
 
/** 
 
* @see HttpServlet#HttpServlet() 
 
*/ 
 
public getFeedTitle() { 
 
super(); 
 
// TODO Auto-generated constructor stub 
 
} 
 
 
 
 /** 
 
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  response.getWriter().append("Served at: ").append(request.getContextPath()); 
 
 } 
 
 
 
 /** 
 
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  String urlStr =request.getParameter("url"); 
 
  String title=""; 
 
  String gid=request.getParameter("group"); 
 
  String lid=request.getParameter("lid"); 
 
  String Lastgid=request.getParameter("Lastgid"); 
 
  String from=request.getParameter("from"); 
 
  if (!urlStr.startsWith("http://")) 
 
    urlStr = "http://"+request.getParameter("feed"); 
 
  //String urlStr = "http://feed.cnblogs.com/blog/u/249598/rss"; 
 
  System.out.print(urlStr); 
 
  java.net.URLConnection feedUrl = new java.net.URL(urlStr).openConnection(); 
 
  feedUrl.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)"); 
 
  com.sun.syndication.io.SyndFeedInput input = new com.sun.syndication.io.SyndFeedInput(); 
 
  com.sun.syndication.feed.synd.SyndFeed feed; 
 
  try { 
 
   feed = input.build(new com.sun.syndication.io.XmlReader(feedUrl)); 
 
   title=feed.getTitle(); 
 
  } catch (IllegalArgumentException | FeedException e) { 
 
   // TODO Auto-generated catch block 
 
   e.printStackTrace(); 
 
  } 
 
  if(from.equals("addRss")){ 
 
  response.sendRedirect("addRss.jsp?title="+title+"url="+urlStr+"group="+gid+"Lastgid="+Lastgid+"lid="+lid); 
 
  } 
 
  if(from.equals("editRss")){ 
 
   response.sendRedirect("editRss.jsp?title="+title+"url="+urlStr+"group="+gid+"Lastgid="+Lastgid+"lid="+lid); 
 
   } 
 
  doGet(request, response); 
 
 } 
 
 
 
} 
 
/RSSreader/src/loginCtrl/checkUser.java 
 
package loginCtrl; 
 
 
 
import java.sql.ResultSet; 
 
import java.sql.SQLException; 
 
import com.JDBConnection; 
 
 
 
public class checkUser { 
 
  
 
 private int uid=0; 
 
 private String name=" "; 
 
 private String pwd=" "; 
 
  
 
 public int getUid() { 
 
  return uid; 
 
 } 
 
 public void setUid(int uid) { 
 
  this.uid = uid; 
 
 } 
 
 public String getName() { 
 
  return name; 
 
 } 
 
 public void setName(String name) { 
 
  this.name = name; 
 
 } 
 
 public String getPwd() { 
 
  return pwd; 
 
 } 
 
 public void setPwd(String pwd) { 
 
  this.pwd = pwd; 
 
 } 
 
 public boolean check() { 
 
  String sPwd=""; 
 
   
 
  String sSql = "select * from users where uname='"+name+"'"; 
 
  System.out.println(sSql); 
 
  try { 
 
   JDBConnection JDBC=new JDBConnection(); 
 
   ResultSet rs =JDBC.executeQuery(sSql); 
 
   System.out.println(rs.isBeforeFirst()); 
 
   if(rs.next()) 
 
   { 
 
    System.out.println("?"); 
 
    sPwd=rs.getString("upwd"); 
 
    uid=rs.getInt("uid"); 
 
    //System.out.println(sPwd); 
 
    JDBC.closeConnection(); 
 
   } 
 
   } catch (SQLException e) { 
 
    // TODO Auto-generated catch block 
 
    System.out.println(e.getMessage()); 
 
    System.out.println("ConnectError!"); 
 
   } 
 
  System.out.println(name+"-"+pwd+"-"+sPwd); 
 
  if(pwd.equals(sPwd)) 
 
  { 
 
   return true; 
 
  } 
 
  else 
 
  { 
 
   return false; 
 
  } 
 
 } 
 
} 
 
/RSSreader/src/loginCtrl/dealsignup.java 
 
package loginCtrl; 
 
 
 
import java.io.IOException; 
 
import java.sql.Connection; 
 
 
 
import javax.servlet.ServletException; 
 
import javax.servlet.annotation.WebServlet; 
 
import javax.servlet.http.HttpServlet; 
 
import javax.servlet.http.HttpServletRequest; 
 
import javax.servlet.http.HttpServletResponse; 
 
import javax.servlet.http.HttpSession; 
 
 
 
/** 
 
* Servlet implementation class dealsignup 
 
*/ 
 
@WebServlet("/dealsignup") 
 
public class dealsignup extends HttpServlet { 
 
 private static final long serialVersionUID = 1L; 
 
 
 
/** 
 
* @see HttpServlet#HttpServlet() 
 
*/ 
 
public dealsignup() { 
 
super(); 
 
// TODO Auto-generated constructor stub 
 
} 
 
 
 
 /** 
 
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  response.getWriter().append("Served at: ").append(request.getContextPath()); 
 
 } 
 
 
 
 /** 
 
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
   
 
  response.setContentType("text/html;charset=utf-8"); 
 
   
 
  String name =request.getParameter("account"); 
 
  String url =request.getParameter("url"); 
 
  String nickname =request.getParameter("nickname"); 
 
  if (nickname==null||nickname=="") 
 
   nickname=null; 
 
  else 
 
   nickname=new String(request.getParameter("nickname").getBytes("ISO8859_1"), "utf-8"); 
 
   
 
 
 
  String pwd= request.getParameter("password"); 
 
  String enpwd= request.getParameter("ensurepassword"); 
 
  signup snp=new loginCtrl.signup(); 
 
  System.out.println("dealsingnup:"+name+"-"+nickname+"-"+pwd+"-"+enpwd); 
 
   
 
  if(!pwd.equals(enpwd)) 
 
  { 
 
   response.sendRedirect("tips.jsp?type=signupwithwrongpwd"); 
 
   System.out.println("兩次密碼不一致"); 
 
  } 
 
  else 
 
  { 
 
   snp.setName(name); 
 
   snp.setNickname(nickname); 
 
   snp.setPwd(pwd); 
 
    
 
   Connection conn=snp.connect(); 
 
   if(snp.signupcheck(conn)) 
 
   { 
 
    if(snp.dosignup(conn)) 
 
    { 
 
     response.sendRedirect("tips.jsp?type=signupsuccessstr="+name); 
 
     System.out.println("注冊成功"); 
 
    } 
 
    else 
 
    { 
 
     response.sendRedirect("tips.jsp?type=sinupfail"); 
 
     System.out.println("未知錯(cuò)誤"); 
 
    } 
 
   } 
 
   else 
 
   { 
 
    response.sendRedirect("tips.jsp?type=usernamevalid"); 
 
    System.out.println("用戶名已被注冊"); 
 
   } 
 
   snp.closeConnection(conn); 
 
  } 
 
  doGet(request, response); 
 
 } 
 
} 
 
/RSSreader/src/loginCtrl/loginCheck.java 
 
package loginCtrl; 
 
 
 
import java.io.IOException; 
 
import java.sql.ResultSet; 
 
import javax.servlet.ServletException; 
 
import javax.servlet.annotation.WebServlet; 
 
import javax.servlet.http.HttpServlet; 
 
import javax.servlet.http.HttpServletRequest; 
 
import javax.servlet.http.HttpServletResponse; 
 
import javax.servlet.http.HttpSession; 
 
import com.JDBConnection; 
 
 
 
/** 
 
* Servlet implementation class loginCheck 
 
*/ 
 
@WebServlet("/loginCheck") 
 
public class loginCheck extends HttpServlet { 
 
 private static final long serialVersionUID = 1L; 
 
 
 
/** 
 
* @see HttpServlet#HttpServlet() 
 
*/ 
 
public loginCheck() { 
 
super(); 
 
// TODO Auto-generated constructor stub 
 
} 
 
 
 
 /** 
 
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
  response.getWriter().append("Served at: ").append(request.getContextPath()); 
 
 } 
 
 
 
 /** 
 
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 
 
  */ 
 
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
 
  // TODO Auto-generated method stub 
 
 
 
  String name =request.getParameter("account"); 
 
  String pwd= request.getParameter("password"); 
 
  checkUser uc=new loginCtrl.checkUser(); 
 
  System.out.println(name+"-"+pwd); 
 
  uc.setName(name); 
 
  uc.setPwd(pwd); 
 
  if(uc.check()) 
 
  { 
 
   HttpSession session=request.getSession(); 
 
   session.setAttribute("name", name); 
 
   session.setAttribute("uid", uc.getUid()); 
 
   response.sendRedirect("index.jsp"); 
 
  } 
 
  else 
 
  { 
 
   response.sendRedirect("tips.jsp?type=logfail"); 
 
  } 
 
  doGet(request, response); 
 
 } 
 
} 
 
/RSSreader/src/loginCtrl/signup.java 
 
package loginCtrl; 
 
 
 
import java.sql.*; 
 
 
 
public class signup { 
 
  
 
 private String name=" "; 
 
 private String nickname=""; 
 
 private String pwd=" "; 
 
 private Connection conn; 
 
  
 
 public String getName() { 
 
  return name; 
 
 } 
 
 public void setName(String name) { 
 
  this.name = name; 
 
 } 
 
 public String getNickname() { 
 
  return nickname; 
 
 } 
 
 public void setNickname(String nickname) { 
 
  this.nickname = nickname; 
 
 } 
 
 public String getPwd() { 
 
  return pwd; 
 
 } 
 
 public void setPwd(String pwd) { 
 
  this.pwd = pwd; 
 
 } 
 
  
 
 public Connection connect() { 
 
  try 
 
  { 
 
   String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";//SQL數(shù)據(jù)庫引擎 
 
   String connectDB= "jdbc:sqlserver://localhost:1433;DatabaseName=RSSreader";//數(shù)據(jù)源 
 
   try 
 
   { 
 
    Class.forName(JDriver);//加載數(shù)據(jù)庫引擎，返回給定字符串名的類 
 
   }catch(ClassNotFoundException e) 
 
   { 
 
   //e.printStackTrace(); 
 
    System.out.println("加載數(shù)據(jù)庫引擎失敗："+e); 
 
    System.exit(0); 
 
   } 
 
   System.out.println("數(shù)據(jù)庫驅(qū)動(dòng)成功"); 
 
   
 
   String user="sa"; 
 
   String password="123456"; 
 
   conn=DriverManager.getConnection(connectDB,user,password);//連接數(shù)據(jù)庫對象 
 
   System.out.println("連接數(shù)據(jù)庫成功"); 
 
  } 
 
  catch(Exception e) 
 
  { 
 
   System.out.println("鏈接數(shù)據(jù)庫失敗："+e); 
 
  } 
 
  return conn; 
 
 } 
 
 public boolean signupcheck(Connection conn) 
 
 { 
 
  try{ 
 
  Statement stmt=conn.createStatement(); 
 
  ResultSet rs=stmt.executeQuery("select * from users where uname='"+name+"'"); 
 
  if(!rs.next()) 
 
   return true; 
 
  } 
 
  catch(Exception e) 
 
  { 
 
   System.out.println("查詢失敗"+e); 
 
   return false; 
 
  } 
 
  return false; 
 
 } 
 
  
 
 public boolean dosignup(Connection conn) { 
 
  try 
 
  {  
 
    
 
    PreparedStatement ps = conn.prepareStatement("insert into users (uname,nickname,upwd) values(?,?,?)"); 
 
    ps.setString(1, name); 
 
    ps.setString(2, nickname); 
 
    ps.setString(3, pwd); 
 
    int num =ps.executeUpdate(); 
 
    System.out.println(num); 
 
     
 
    if (num==0) 
 
     return false; 
 
    ps.close(); 
 
  } 
 
  catch(Exception e) 
 
  { 
 
   System.out.println("添加失敗"+e); 
 
   return false; 
 
  } 
 
  return true;  
 
 } 
 
 public boolean closeConnection(Connection conn) 
 
 { 
 
  try 
 
  { 
 
   System.out.println("關(guān)閉鏈接成功"); 
 
  conn.close(); 
 
  } 
 
  catch(Exception e) 
 
  { 
 
   System.out.println("關(guān)閉鏈接失敗"+e); 
 
   return false;  
 
  } 
 
  return true; 
 
 } 
 
}