/**
?*@（#）adminDAO.java?2012-5-9?
?*?All?right?reserved.
?*/
package?com.zr.JSF_crud.model.DAO;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?com.zr.JSF_crud.Servlet.AdminBean;
import?com.zr.JSF_crud.model.DTO.adminDTO;
import?com.zr.JSF_crud.util.C3p0_DataSource;



/**
?*copyRght?Xiao_榮
?*/
public?class?adminDAOMySqlImpl?{

	public?int?login（adminDTO?admin）?{
		Connection?con?=?null;
		Statement?stmt?=?null;
		ResultSet?rs?=?null;
		int?i?=?0;
		try?{
			//?//類加載，反射機制
			//?Class.forName（driver）;
			//?con?=?DriverManager.getConnection（url?username?password）;
			//?數(shù)據(jù)庫連接池
			con?=?C3p0_DataSource.getConnection（）;
			String?sql?=?“select?*?from?admin?where?adminname=‘“
					+?admin.getAdminname（）?+?“‘?and?pass=‘“?+?admin.getPass（）
					+?“‘“;
			stmt?=?con.createStatement（）;
			rs?=?stmt.executeQuery（sql）;
			while?（rs.next（））?{
				i?=?1;
			}
		}?catch?（Exception?sqlex1）?{
			sqlex1.printStackTrace（）;
		}?finally?{
			if?（con?!=?null）?{
				try?{
					con.close（）;
				}?catch?（SQLException?sqlex2）?{
					sqlex2.printStackTrace（）;
				}
			}
		}
		return?i;
	}

	//?CreateByDTO------------------------------------------------
	public?void?createAdmin（adminDTO?admin）?{
		Connection?conn?=?null;
		Statement?stmt?=?null;
		try?{
			//?數(shù)據(jù)庫連接池
			conn?=?C3p0_DataSource.getConnection（）;
			String?sql?=?“insert?into?admin?（adminnamepass）?values?（“?+?“‘“
					+?admin.getAdminname（）?+?“‘“?+?““?+?“‘“?+?admin.getPass（）
					+?“‘“?+?“）“;
			stmt?=?conn.createStatement（）;
			stmt.execute（sql）;
		}?catch?（Exception?sqlex1）?{
			sqlex1.printStackTrace（）;
		}?finally?{
			if?（conn?!=?null）?{
				try?{
					conn.close（）;
				}?catch?（SQLException?sqlex2）?{
					sqlex2.printStackTrace（）;
				}
			}
		}
	}

	//?RemoveByPrimaryKey------------------------------------------------
	public?void?removeByPrimaryKey（int?id）?{
		Connection?con?=?null;
		Statement?stmt?=?null;
		try?{
			//?數(shù)據(jù)庫連接池
			con?=?C3p0_DataSource.getConnection（）;
			String?sql?=?“delete?from?admin?where?id?=“?+?id;
			stmt?=?con.createStatement（）;
			stmt.execute（sql）;

		}?catch?（Exception?sqlex1）?{
			sqlex1.printStackTrace（）;
		}?finally?{
			if?（con?!=?null）?{
				try?{
					con.close（）;
				}?catch?（SQLException?sqlex2）?{
					sqlex2.printStackTrace（）;
				}
			}
		}
	}

	//?UpdateByDTO------------------------------------------------
	public?void?updateAdmin（adminDTO?adminDTO）?{
		Connection?conn?=?null;
		Statement?stmt?=?null;
		try?{
			System.out.println（“---------000----------“）;
			//?數(shù)據(jù)庫連接池
			conn?=?C3p0_DataSource.getConnection（）;
			String?sql?=?“update?admin?set?adminname=‘“?+?adminDTO.getAdminname（）
					+?“‘pass=‘“?+?adminDTO.getPass（）?+?“‘?where?id=“
					+?adminDTO.getId（）;
			System.out.println（“--------

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

?????文件???????1106??2012-05-28?22:46??JSF_crud\.classpath

?????文件????????297??2012-05-28?22:32??JSF_crud\.mymetadata

?????文件???????1281??2012-05-28?22:58??JSF_crud\.project

?????文件????????629??2012-05-28?22:43??JSF_crud\.settings\org.eclipse.jdt.core.prefs

?????文件???????2164??2012-08-06?14:40??JSF_crud\logindb.sql

?????文件???????5046??2012-06-04?23:23??JSF_crud\src\com\zr\JSF_crud\model\DAO\adminDAOMySqlImpl.java

?????文件????????633??2012-06-04?23:14??JSF_crud\src\com\zr\JSF_crud\model\DTO\adminDTO.java

?????文件???????1210??2012-06-04?23:15??JSF_crud\src\com\zr\JSF_crud\Service\adminService.java

?????文件???????3988??2012-06-05?21:52??JSF_crud\src\com\zr\JSF_crud\Servlet\AdminBean.java

?????文件???????2004??2012-05-28?22:41??JSF_crud\src\com\zr\JSF_crud\util\C3p0_DataSource.java

?????文件????????523??2012-04-13?09:56??JSF_crud\src\jdbc.properties

?????文件????????834??2012-05-28?22:32??JSF_crud\WebRoot\index.jsp

?????文件?????????36??2012-05-28?22:32??JSF_crud\WebRoot\meta-INF\MANIFEST.MF

?????文件????????742??2012-06-04?21:17??JSF_crud\WebRoot\pages\add.jsp

?????文件????????784??2012-06-04?23:28??JSF_crud\WebRoot\pages\edit.jsp

?????文件????????669??2012-05-28?23:00??JSF_crud\WebRoot\pages\login.jsp

?????文件???????2017??2012-06-05?22:08??JSF_crud\WebRoot\pages\welcome.jsp

?????文件???????5245??2012-07-09?09:05??JSF_crud\WebRoot\WEB-INF\classes\com\zr\JSF_crud\model\DAO\adminDAOMySqlImpl.class

?????文件????????941??2012-07-09?09:05??JSF_crud\WebRoot\WEB-INF\classes\com\zr\JSF_crud\model\DTO\adminDTO.class

?????文件???????1277??2012-07-09?09:05??JSF_crud\WebRoot\WEB-INF\classes\com\zr\JSF_crud\Service\adminService.class

?????文件???????4614??2012-07-09?09:05??JSF_crud\WebRoot\WEB-INF\classes\com\zr\JSF_crud\Servlet\AdminBean.class

?????文件???????2529??2012-07-09?09:05??JSF_crud\WebRoot\WEB-INF\classes\com\zr\JSF_crud\util\C3p0_DataSource.class

?????文件????????523??2012-04-13?09:56??JSF_crud\WebRoot\WEB-INF\classes\jdbc.properties

?????文件???????1441??2012-06-05?21:09??JSF_crud\WebRoot\WEB-INF\faces-config.xml

?????文件?????610790??2011-09-19?10:18??JSF_crud\WebRoot\WEB-INF\lib\c3p0-0.9.1.2.jar

?????文件?????118757??2010-12-02?14:03??JSF_crud\WebRoot\WEB-INF\lib\commons-beanutils.jar

?????文件?????170902??2010-12-02?14:03??JSF_crud\WebRoot\WEB-INF\lib\commons-collections.jar

?????文件?????109131??2010-12-02?14:03??JSF_crud\WebRoot\WEB-INF\lib\commons-digester.jar

?????文件??????31638??2010-12-02?14:03??JSF_crud\WebRoot\WEB-INF\lib\commons-logging.jar

?????文件?????364344??2010-12-02?14:03??JSF_crud\WebRoot\WEB-INF\lib\jsf-api.jar

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