package?com.dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.toolsbean.DB;
import?com.valuebean.AreaBean;

public?class?AreaDao?{
	private?DB?mydb=null;
	
	public?AreaDao（）{
		mydb=new?DB（）;
	}
	public?List?getAreas（）{
		String?sql=“select?a.*t.num?from?tb_area?as?a?left?join?（select?voter_ipcount（id）?as?num?from?tb_voter?group?by?voter_ip）?t?on?（t.voter_ip?between?a.area_ipStart?and?a.area_ipEnd）“;
		List?options=getList（sqlnull）;		
		return?options;
	}
	public?List?getAreasForDay（）{
		String?sql=“select?a.*t.num?from?tb_area?as?a?left?join?（select?voter_ipcount（id）?as?num?from?tb_voter?where?day（voter_votetime）=day（getdate（））?group?by?voter_ip）?t?on?（t.voter_ip?between?a.area_ipStart?a

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

?????文件?????671232??2008-11-17?09:10??投票統計模塊\程序使用說明.doc

?????文件????????444??2008-09-26?09:49??投票統計模塊\sl\01\fail.jsp

?????文件????????149??2008-10-10?13:28??投票統計模塊\sl\01\index.jsp

?????文件???????2561??2008-10-09?13:36??投票統計模塊\sl\01\main.jsp

?????文件????????417??2008-09-12?13:08??投票統計模塊\sl\01\showresult.jsp

?????文件????????323??2008-09-12?13:08??投票統計模塊\sl\01\success.jsp

?????文件???????2010??2008-09-12?13:08??投票統計模塊\sl\01\toresult.jsp

?????文件????????267??2008-09-26?09:35??投票統計模塊\sl\01\welcome.jsp

?????文件?????????36??2008-09-04?14:26??投票統計模塊\sl\01\meta-INF\MANIFEST.MF

?????文件???????1751??2008-09-06?17:04??投票統計模塊\sl\01\WEB-INF\web.xml

?????文件???????2696??2008-09-06?17:02??投票統計模塊\sl\01\WEB-INF\classes\com\dao\AreaDao.class

?????文件???????3356??2008-09-12?13:02??投票統計模塊\sl\01\WEB-INF\classes\com\dao\OptionDao.class

?????文件???????1613??2008-09-06?17:02??投票統計模塊\sl\01\WEB-INF\classes\com\dao\VoterDao.class

?????文件???????1829??2008-09-12?13:02??投票統計模塊\sl\01\WEB-INF\classes\com\filter\SubmitFilter.class

?????文件???????4964??2008-10-10?10:18??投票統計模塊\sl\01\WEB-INF\classes\com\filter\VoteLimitFilter.class

?????文件???????1350??2008-09-12?13:02??投票統計模塊\sl\01\WEB-INF\classes\com\servlet\IndexServlet.class

?????文件??????12789??2008-09-26?09:39??投票統計模塊\sl\01\WEB-INF\classes\com\servlet\VoteServlet.class

?????文件???????2849??2008-09-12?13:02??投票統計模塊\sl\01\WEB-INF\classes\com\toolsbean\DB.class

?????文件???????1193??2008-10-10?13:20??投票統計模塊\sl\01\WEB-INF\classes\com\toolsbean\StringHandler.class

?????文件???????1173??2008-09-12?14:51??投票統計模塊\sl\01\WEB-INF\classes\com\valuebean\AreaBean.class

?????文件???????1153??2008-09-12?13:02??投票統計模塊\sl\01\WEB-INF\classes\com\valuebean\OptionBean.class

?????文件???????1167??2008-08-28?11:25??投票統計模塊\sl\01\css\style.css

?????文件????1048576??2008-11-17?11:40??投票統計模塊\sl\01\database\db_vote_Data.MDF

?????文件????1048576??2008-11-17?11:40??投票統計模塊\sl\01\database\db_vote_Log.LDF

?????文件??????23918??2008-09-26?09:02??投票統計模塊\sl\01\images\end.jpg

?????文件???????1858??2008-09-26?09:02??投票統計模塊\sl\01\images\leftbg.jpg

?????文件???????7813??2008-09-26?09:15??投票統計模塊\sl\01\images\lefttopbg.jpg

?????文件????????769??2008-09-26?09:23??投票統計模塊\sl\01\images\line.jpg

?????文件??????74274??2008-09-26?09:27??投票統計模塊\sl\01\images\mainbg.jpg

?????文件??????31997??2008-09-26?09:42??投票統計模塊\sl\01\images\message.jpg

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