package?com.news.back.news_Channel.news_ChannelDAO;

import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.Statement;
import?java.util.ArrayList;

import?com.news.back.news_Channel.news_ChannelVO.NewsChannelVO;
import?com.news.dbTools.DBConnectionManager;

public?class?NewsChannelDAO?{

	private?Connection?conn?=?null;//得到conn
	private?Statement?stm?=?null;//執行sql語句
	private?ResultSet?rs?=?null;//返回記錄集
	private?NewsChannelVO?newschannelvo?=?null;
	private?DBConnectionManager?dbtools?=?null;
	
	public?NewsChannelDAO（）{
		
	}
	
	public?NewsChannelDAO（NewsChannelVO?newschannelvo）{
		this.newschannelvo?=?newschannelvo;
	}
	
	
	//頻道添加
	public?int?news_Channel_Insert（）{
		try?{
			String?sql?=?“select?*?from?News_Channel?where?NewsChannel_Name?=?‘“+newschannelvo.getNewsChannel_Name（）+“‘“;
			DBConnectionManager.getInstance（）;
			dbtools?=?new?DBConnectionManager（）;
			conn?=?dbtools.getConnection（）;
			stm?=?conn.createStatement（）;
			rs?=?stm.executeQuery（sql）;
			if?（rs.next（））?{
				return?2;
			}?else?{
				String?sqll?=?“insert?into?News_Channel?values（‘“+newschannelvo.getNewsChannel_Name（）+“‘）“;
				stm.executeUpdate（sqll）;
				return?1;
			}
			
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?0;
		}?finally?{
			try?{
				rs.close（）;
				stm.close（）;
				dbtools.freeConnection（conn）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	
	//查詢頻道列表
	public?ArrayList?news_Channel_List（）{
		try?{
			ArrayList?list?=?new?ArrayList（）;
			DBConnectionManager.getInstance（）;
			dbtools?=?new?DBConnectionManager（）;
			String?sql?=?“select?top?6?*?from?News_Channel?order?by?NewsChannel_Id?asc“;
			conn?=?dbtools.getConnection（）;
			stm?=?conn.createStatement（）;
			rs?=?stm.executeQuery（sql）;
			
			while?（rs.next（））?{
				NewsChannelVO?newschannelvo?=?new?NewsChannelVO（）;
				newschannelvo.setNewsChannel_Id（rs.getInt（“NewsChannel_Id“））;
				newschannelvo.setNewsChannel_Name（rs.getString（“NewsChannel_Name“））;
				list.add（newschannelvo）;
			}
			return?list;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?null;
		}?finally?{
			try?{
				rs.close（）;
				stm.close（）;
				dbtools.freeConnection（conn）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	//用作下拉列表的動態顯示
	public?ArrayList?news_Channel_List_Sel（）{
		try?{
			ArrayList?list?=?new?ArrayList（）;
			DBConnectionManager.getInstance（）;
			dbtools?=?new?DBConnectionManager（）;
			String?sql?=?“select?*?from?News_Channel?order?by?NewsChannel_Id?asc“;
			conn?=?dbtools.getConnection（）;
			stm?=?conn.createStatement（）;
			rs?=?stm.executeQuery（sql）;
			
			while?（rs.next（））?{
				NewsChannelVO?newschannelvo?=?new?NewsChannelVO（）;
				newschannelvo.setNewsChannel_Id（rs.getInt（“NewsChannel_Id“））;
				newschannelvo.setNewsChannel_Name（rs.getString（“News

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????1179648??2008-12-18?14:59??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\data\News.mdf

?????文件???????7963??2008-12-17?13:01??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\data\News.sql

?????文件????1048576??2008-12-18?14:59??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\data\News_log.LDF

?????文件?????193024??2008-11-27?12:50??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\doc\數據庫詳細設計.doc

?????文件?????449024??2008-12-16?17:54??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\doc\需求規格說明書_新聞發布管理系統.doc

?????文件?????324608??2008-11-25?14:02??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\doc\項目詳細設計說明書.doc

?????文件???????1222??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\.project

?????文件????????630??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\.classpath

?????文件????????285??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\.mymetadata

?????文件???????4781??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Channel\news_ChannelDAO\NewsChannelDAO.java

?????文件???????3280??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Channel\news_ChannelUC\NewsChannelServlet.java

?????文件????????518??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Channel\news_ChannelVO\NewsChannelVO.java

?????文件??????20429??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Info\news_InfoDAO\News_InfoDAO.java

?????文件??????11601??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Info\news_InfoUC\News_Info_Servlet.java

?????文件????????861??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Info\news_InfoVO\NewsInfoPageVO.java

?????文件???????1924??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Info\news_InfoVO\News_InfoVO.java

?????文件???????8437??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Sort\news_SortDAO\NewsSortDAO.java

?????文件???????7204??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Sort\news_SortUC\NewsSortServlet.java

?????文件????????864??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Sort\news_SortVO\NewsSortPageVO.java

?????文件????????894??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\news_Sort\news_SortVO\NewsSortVO.java

?????文件???????4721??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\user\userDAO\UserDAO.java

?????文件???????5093??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\user\userUC\User_Servlet.java

?????文件????????745??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\back\user\userVO\UserVO.java

?????文件???????2672??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\dbTools\DBConnectionManager.java

?????文件???????3342??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\dbTools\DBConnectionPool.java

?????文件????????239??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\dbTools\init.properties

?????文件???????8951??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\deals\DataType.java

?????文件????????771??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\filterDemo\FilterEncoding.java

?????文件???????8078??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\font\Idea\IdeaDAO\IdeaDAO.java

?????文件???????9943??2008-12-18?14:52??Java_02_風馳新聞發布管理系統_陳庚茂_HB0700616\project\news\src\com\news\font\Idea\IdeaUC\Idea_Servlet.java

............此處省略860個文件信息