/*
?*?Generated?by?MyEclipse?Struts
?*?Template?path:?templates/java/JavaClass.vtl
?*/
package?action;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?model.Dbconnect;
import?model.pjxx;

import?org.apache.struts.action.Action;
import?org.apache.struts.action.ActionForm;
import?org.apache.struts.action.ActionForward;
import?org.apache.struts.action.ActionMapping;


public?class?AllselectAction?extends?Action?{

	public?ActionForward?execute（ActionMapping?mapping?ActionForm?form
			HttpServletRequest?request?HttpServletResponse?response）?{
		
		ArrayList?list=new?ArrayList（）;
????????try{?
????????Connection?conn?=??Dbconnect.getConnection（）;
????????String?sql=?“select?*?from?pj“;
????????PreparedStatement?prestat=conn.prepareStatement（sql）;
?????
????????ResultSet?rs=prestat.executeQuery（）;
????????
???????
????????
????????
???????if（prestat.execute（））{
???????
????	???
????	???rs?=?prestat.getResultSet（）;
???????
????	?????while（rs.next（））{
????????	
????????	????String?a=rs.getString（1）;
????????	????String?b=rs.getString（2）;
????????	????String?c=rs.getString（3）;
????????	????String?d=rs.getString（4）;
????????	????String?e=rs.getString（5）;
????????	????String?f=rs.getString（6）;
????????	????String?g=rs.getString（7）;
????????	
????????	????pjxx?vo=new?pjxx（abcdefg）;
????????	????list.add（vo）;
????????	????
????	?????}????
????	?}
????????	????
????????	????

????????????????request.setAttribute（“info1“list）;
????????????????
????????????????if（!list.isEmpty（））{
????????????????	
????????????????	return?mapping.findForward（“success“）;
????????????????}
????????????????else
????????????????	return?mapping.findForward（“error“）;
????????	???
????????	??
???????/*?}*/
???????
??????}
?????catch?（SQLException?e）?{
		//?TODO?Auto-generated?catch?block
		???????e.printStackTrace（）;
		???????return?mapping.findForward（“error“）;

		???????
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-09?12:08??JPXT\
?????文件?????????713??2018-03-28?11:42??JPXT\.classpath
?????目錄???????????0??2017-12-17?10:05??JPXT\.myeclipse\
?????文件?????????285??2018-04-11?10:38??JPXT\.mymetadata
?????文件?????????262??2017-12-17?11:00??JPXT\.mystrutsdata
?????文件????????1830??2018-03-28?11:42??JPXT\.project
?????目錄???????????0??2018-03-28?11:42??JPXT\.settings\
?????文件?????????500??2018-03-28?11:42??JPXT\.settings\.jsdtscope
?????文件?????????334??2018-03-28?11:42??JPXT\.settings\org.eclipse.jdt.core.prefs
?????文件?????????450??2018-03-28?11:42??JPXT\.settings\org.eclipse.wst.common.component
?????文件?????????252??2018-03-28?11:42??JPXT\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-03-28?11:42??JPXT\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-03-28?11:42??JPXT\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????446464??2018-04-09?12:08??JPXT\mysql-connector-java-3.1.12-bin.jar
?????目錄???????????0??2017-12-21?20:23??JPXT\src\
?????目錄???????????0??2018-04-09?11:48??JPXT\src\action\
?????文件????????2171??2017-12-21?11:51??JPXT\src\action\AllselectAction.java
?????文件????????2820??2018-04-09?11:48??JPXT\src\action\CollectAction.java
?????文件????????1340??2018-04-09?11:48??JPXT\src\action\correct.java
?????文件????????3190??2017-12-21?11:08??JPXT\src\action\CorrectAction.java
?????文件????????1526??2017-12-19?20:34??JPXT\src\action\DeleteAction.java
?????文件????????1249??2018-04-09?11:48??JPXT\src\action\insert.java
?????文件????????3761??2018-04-09?11:48??JPXT\src\action\LoginAction.java
?????文件?????????995??2018-04-09?11:48??JPXT\src\action\loginadmin.java
?????文件????????1008??2018-04-09?11:48??JPXT\src\action\loginstudent.java
?????文件????????2047??2017-12-21?10:45??JPXT\src\action\RegisterAction.java
?????文件????????2660??2017-12-19?19:32??JPXT\src\action\SelectAction.java
?????文件?????????626??2017-12-21?10:00??JPXT\src\action\tiaozhuanAction.java
?????目錄???????????0??2017-12-21?20:23??JPXT\src\com\
?????目錄???????????0??2017-12-21?20:23??JPXT\src\com\yourcompany\
?????目錄???????????0??2017-12-21?20:23??JPXT\src\com\yourcompany\struts\
............此處省略66個文件信息