/**
?*?@（#）Jieguo.java
?*
?*
?*?@author?
?*?@version?1.00?2008/7/17
?*/


package?jieguo;
import?java.io.*;
import?java.sql.*;
import?javax.servlet.*;
import?javax.servlet.http.*;

public?class?Jieguo?extends?HttpServlet?{
	public?void?init（ServletConfig?config）?throws?ServletException{
		super.init（config）;
		try{??Class.forName（“com.mysql.jdbc.Driver“）;
??????????}
???????catch（Exception?e）{?
???????	e.printStackTrace（）;
???????	}
	}
	public?void?doPost（HttpServletRequest?requestHttpServletResponse?response）?throws?ServletExceptionIOException{
		response.setContentType（“text/html;charset=GBK“）;
		PrintWriter?out=response.getWriter（）;
		out.print（““）;
			out.println（““）;
			out.print（““+“投票顯示結果“+“

“）;
		try{
			HttpSession?session=request.getSession（true）;
			session.setAttribute（“toupiao“?“OK“）;
			StringBuffer?str=new?StringBuffer（）;
			String?sql=“select?*?from?houxuanren?order?by?piaoshu?desc?“;
			String?url?=?“jdbc:mysql://127.0.0.1:3306/toupiao“;
			Connection?con=DriverManager.getConnection（url“root““root“）;
			Statement?sta=con.createStatement（）;
			ResultSet?rs=sta.executeQuery（sql）;
?????????????out.println（““）;
?????????????out.println（“
“+“序號“+““）;
?????????????out.println（“
“+“頭像“+“
“）;
?????????????out.println（“
“+“姓名“+““）;
?????????????out.println（“
“+“票數“+““）;
?????????????while（rs.next（））
?????????????{??
????????????????out.print（““）;
???????????????????out.print（“
“+rs.getString（1）+““）;
???????????????????out.print（““）;
???????????????????out.print（“
“+rs.getString（3）+“
“）;
???????????????????out.print（“
“+rs.getString（4）+“
“）;
????????????????out.print（““）;
?????????????}
????????????out.print（““）;
????????????con.close（）;
		}catch（Exception?e）{
			System.out.println（e）;
			}
		out.print（““）;
		out.print（““）;
	/*	RequestDispatcher?dispatacher=request.getRequestDispatcher（“test3.jsp“）;
		dispatacher.forward（requestresponse）;*/
	}
	public?void?doGet（HttpServletRequest?requestHttpServletResponse?response）?throws?ServletExceptionIOException{
		doPost（requestresponse）;
	}
}

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

?????文件????????930??2008-07-17?12:24??toupiao\jiegou.jsp

?????文件????????917??2008-07-17?17:10??toupiao\toupiao1.jsp

?????文件???????1114??2008-07-17?17:45??toupiao\chenggong.jsp

?????文件???????4752??2008-12-06?21:31??toupiao\toupiao2.jsp

?????文件????????494??2008-12-06?21:38??toupiao\數據庫.txt

?????文件????????831??2008-07-17?12:40??toupiao\WEB-INF\web.xml

?????文件???????2556??2008-07-17?15:33??toupiao\WEB-INF\classes\Jieguo.java

?????文件???????1538??2008-07-17?17:19??toupiao\WEB-INF\classes\Toupiao.java

?????文件???????2355??2008-07-17?17:19??toupiao\WEB-INF\classes\toupiao\Toupiao.class

?????文件???????3251??2008-07-17?15:34??toupiao\WEB-INF\classes\jieguo\Jieguo.class

?????文件?????474964??2005-12-22?05:24??toupiao\WEB-INF\lib\mysql-connector-java-5.0.0-beta-bin.jar

?????文件???????7557??2008-06-16?19:17??toupiao\image\2.jpg

?????文件???????4595??2008-06-16?19:17??toupiao\image\3.jpg

?????文件???????3570??2008-06-16?19:18??toupiao\image\5.jpg

?????文件???????3719??2008-06-16?19:06??toupiao\image\6.jpg

?????文件???????5350??2008-06-16?19:18??toupiao\image\4.jpg

?????文件???????4905??2008-06-16?19:17??toupiao\image\7.jpg

?????文件???????6914??2008-06-16?19:11??toupiao\image\8.jpg

????..A.SH.?????47616??2008-12-06?21:30??toupiao\image\Thumbs.db

?????文件???????3719??2008-06-16?19:06??toupiao\image\1.jpg

?????目錄??????????0??2008-12-06?21:39??toupiao\WEB-INF\classes\toupiao

?????目錄??????????0??2008-12-06?21:39??toupiao\WEB-INF\classes\jieguo

?????目錄??????????0??2008-12-06?21:39??toupiao\WEB-INF\classes

?????目錄??????????0??2008-12-06?21:39??toupiao\WEB-INF\lib

?????目錄??????????0??2008-12-06?21:39??toupiao\WEB-INF

?????目錄??????????0??2008-12-06?21:39??toupiao\image

?????目錄??????????0??2008-12-06?21:39??toupiao

-----------?---------??----------?-----??----

???????????????581647????????????????????27



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