package?DBCon;

import?java.sql.*;
public?class?DBCon?{
	public?static?Connection?conn=null;
	public?Statement?stmt=null;
	public?ResultSet?rs=null;
	private?static?String?dbDriver=“com.mysql.jdbc.Driver“;
	private?static?String?dbUrl=“jdbc:mysql://localhost:3306/petshospital?user=root&password=root&useUnicode=true&characterEncoding=GB2312“;
	private?static?String?dbUser=“root“;
	private?static?String?dbPassword=““;


	//打開(kāi)數(shù)據(jù)庫(kù)連接
	public?static?Connection?getConnection（）
	{
		Connection?conn=null;
		try
		{
			Class.forName（dbDriver）;
			conn=DriverManager.getConnection（dbUrldbUserdbPassword）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
????	if?（conn?==?null）?
????	{
??????		System.err.println（“警告:數(shù)據(jù)庫(kù)連接失敗!“）;
????	}		
		return?conn;
	}
	//讀取結(jié)果集
	public?ResultSet?doQuery（String?sql）
	{
		try
		{
			conn=DBCon.getConnection（）;
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			rs=stmt.executeQuery（sql）;
		}
		catch（SQLException?e）
		{
			e.printStackTrace（）;
		}
		return?rs;
	}
	//更新數(shù)據(jù)
	public?int?doUpdate（String?sql）
	{
		int?result=0;
		try
		{
			conn=DBCon.getConnection（）;
			stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			result=stmt.executeUpdate（sql）;
		}
		catch（SQLException?e）
		{
			result=0;
		}
		return?result;
	}
	//關(guān)閉數(shù)據(jù)庫(kù)連接
	public?void?closeConnection（）
	{
		try
		{
			if?（rs!=null）
				rs.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		try
		{
			if?（stmt!=null）
				stmt.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
		try
		{
			if?（conn!=null）
				conn.close（）;
		}
		catch（Exception?e）
		{
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????954??2010-11-29?19:05??ph\.classpath

?????文件???????1035??2010-11-29?18:51??ph\.project

?????文件????????454??2010-11-29?18:51??ph\.settings\.jsdtscope

?????文件????????336??2010-11-29?18:51??ph\.settings\org.eclipse.jdt.core.prefs

?????文件????????436??2010-11-29?18:51??ph\.settings\org.eclipse.wst.common.component

?????文件????????320??2010-11-29?18:51??ph\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2010-11-29?18:51??ph\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-11-29?18:51??ph\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2514??2010-12-01?22:00??ph\build\classes\DBCon\DBCon.class

?????文件???????1483??2010-12-01?22:00??ph\build\classes\userBean\checks.class

?????文件???????1999??2010-12-01?22:00??ph\build\classes\userBean\emply.class

?????文件???????1103??2010-12-01?22:00??ph\build\classes\userBean\master.class

?????文件???????2047??2010-12-01?22:00??ph\build\classes\userBean\medica.class

?????文件???????1486??2010-12-01?22:00??ph\build\classes\userBean\ordergoods.class

?????文件????????904??2010-12-01?22:00??ph\build\classes\userBean\pen.class

?????文件???????1499??2010-12-01?22:00??ph\build\classes\userBean\pet.class

?????文件???????4411??2010-12-01?22:00??ph\build\classes\userBeancl\clerkcl.class

?????文件????????430??2010-12-01?22:00??ph\build\classes\userBeancl\doctorcl.class

?????文件???????1531??2010-12-01?22:00??ph\build\classes\userBeancl\logincl.class

?????文件???????2559??2010-12-01?22:00??ph\build\classes\userBeancl\managercl.class

?????文件???????4029??2010-12-01?22:00??ph\build\classes\userBeancl\seccl.class

?????文件???????1534??2010-12-01?22:00??ph\build\classes\userBeancl\staffcl.class

?????文件??????13188??2010-12-01?22:00??ph\build\classes\userServlet\clerk.class

?????文件???????8618??2010-12-01?22:00??ph\build\classes\userServlet\doctor.class

?????文件???????3674??2010-12-01?22:00??ph\build\classes\userServlet\image.class

?????文件???????3697??2010-12-02?19:34??ph\build\classes\userServlet\login.class

?????文件???????6607??2010-12-03?10:02??ph\build\classes\userServlet\manager.class

?????文件???????8429??2010-12-01?22:00??ph\build\classes\userServlet\sec.class

?????文件???????4857??2010-12-02?09:39??ph\build\classes\userServlet\staff.class

?????文件???????1829??2010-11-30?20:50??ph\src\DBCon\DBCon.java

............此處省略131個(gè)文件信息