package?cn.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;

public?class?ConMysql?{

	public?ConMysql（）?{
	}

	static?{
		//?加載驅動程序
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			System.out.println（“驅動加載失敗“）;
		}
	}
	//?數據庫連接字符串
	private?static?String?url?=?“jdbc:mysql://59.188.79.122:3306/benben1314“;
	//?用戶名
	private?static?String?userName?=?“benben1314“;
	//?密碼
	private?static?String?passWord?=?“benben1314“;
	//?連接對象
	static?Connection?con?=?null;
	//?語句對象
	static?PreparedStatement?ps?=?null;

	//?數據庫連接方法
	public?static?void?prepareConnection（）?{
		try?{
			if?（con?==?null?||?con.isClosed（））?{
				con?=?DriverManager.getConnection（url?userName?passWord）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			throw?new?RuntimeException（“連接異常:“?+?e.getMessage（））;
		}
	}

	//?關閉方法
	public?static?void?close（）?{
		try?{
			if?（ps?!=?null）?{
				ps.close（）;
			}
			if?（con?!=?null）?{
				con.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			throw?new?RuntimeException（“關閉連接異常:“?+?e.getMessage（））;
		}
	}

	//?操作回滾
	public?static?void?rollback（）?{
		try?{
			con.rollback（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			throw?new?RuntimeException（“回滾失敗:“?+?e.getMessage（））;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-06-23?21:01??PetController\
?????文件?????????529??2013-04-04?17:06??PetController\.classpath
?????目錄???????????0??2013-04-04?17:06??PetController\.myeclipse\
?????文件?????????312??2013-04-04?17:06??PetController\.mymetadata
?????文件????????1756??2013-04-04?18:22??PetController\.project
?????目錄???????????0??2013-06-23?21:01??PetController\.settings\
?????文件?????????500??2013-04-04?17:06??PetController\.settings\.jsdtscope
?????文件??????????90??2013-05-28?22:55??PetController\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2013-04-04?17:06??PetController\.settings\org.eclipse.jdt.core.prefs
?????文件?????????477??2013-04-04?17:06??PetController\.settings\org.eclipse.wst.common.component
?????文件?????????252??2013-04-04?17:06??PetController\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-04-04?17:06??PetController\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-04-04?17:06??PetController\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????2784??2013-05-28?22:54??PetController\petinfo.sql
?????目錄???????????0??2013-06-23?21:01??PetController\src\
?????目錄???????????0??2013-06-23?21:01??PetController\src\cn\
?????目錄???????????0??2013-06-23?21:01??PetController\src\cn\dao\
?????文件????????1669??2013-05-28?22:49??PetController\src\cn\dao\ConMysql.java
?????文件????????6282??2013-04-22?12:35??PetController\src\cn\dao\DocManage.java
?????文件??????????50??2013-04-04?21:20??PetController\src\cn\dao\PetManage.java
?????文件????????2289??2013-04-22?08:56??PetController\src\cn\dao\UserBean.java
?????文件????????3802??2013-04-11?23:14??PetController\src\cn\dao\UserManage.java
?????目錄???????????0??2013-06-23?21:01??PetController\src\docservlets\
?????文件????????2654??2013-04-22?10:29??PetController\src\docservlets\docadd.java
?????文件????????3166??2013-04-22?11:34??PetController\src\docservlets\docdel.java
?????文件????????2933??2013-04-22?09:21??PetController\src\docservlets\docquery.java
?????文件????????2920??2013-04-22?12:37??PetController\src\docservlets\docupdate.java
?????目錄???????????0??2013-06-23?21:01??PetController\src\servlets\
?????文件????????2492??2013-04-10?16:14??PetController\src\servlets\addUserSer.java
?????文件????????1975??2013-04-10?14:36??PetController\src\servlets\loginFilter.java
?????文件????????1659??2013-04-22?09:22??PetController\src\servlets\loginservlet.java
............此處省略49個文件信息