package?DBConnection;
import?java.sql.*;
import?java.util.*;
import?java.text.*;
public?class?DBConnection{
Connection?conn=null;
Statement?stmt=null;
ResultSet?rs=null;
public?DBConnection（）
{
}
public?void?getConn（）
{
?try{
?Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
?String?url=“jdbc:odbc:hospital“;
?String?username=““;
?String?password=““;
?conn=DriverManager.getConnection（urlusernamepassword）;
?}
?catch（Exception?e）
{
	System.out.println（“數據庫連接失敗“）;
	?e.printStackTrace（）;
}

}
public?ResultSet?select（String?sql）
{
????try
????{
????	stmt=conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
		rs=stmt.executeQuery（sql）;
????}
????catch?（Exception?e）
????{
????e.printStackTrace（）;
????}
	return?rs;
}

public?int?insert（String?sql）
{
?int?num=0;
?try
?{
?	stmt=conn.createStatement（）;
	stmt.executeUpdate（sql）;
?}
?catch?（Exception?e）
?{
	?e.printStackTrace（）;
?}
?return?num;
}
?public?int?update（String?sql）
	?{
?int?num=0;
?try
?{
?	stmt=conn.createStatement（）;
	stmt.executeUpdate（sql）;
?}
?catch?（Exception?e）
?{
	?e.printStackTrace（）;
?}
?return?num;
}
public?int?delete（String?sql）
	?{
?int?num=0;
?try
?{
?	stmt=conn.createStatement（）;
	stmt.executeUpdate（sql）;
?}
?catch?（Exception?e）
?{
	?e.printStackTrace（）;
?}
?return?num;
}
public???String???getDateNow（）???
??????????{???
??????????????????SimpleDateFormat???dateFormat=new?????SimpleDateFormat（“yyyy-MM-dd???HH:mm:ss“）;???
??????????????????Calendar???c=Calendar.getInstance（）;???
??????????????????return???dateFormat.format（c.getTime（））;???
??????????}

public?int?getRowCount（String?strSql）?{
????????
		int?intCount?=?0;
????????try?{
????????????stmt?=conn.createStatement（）;
????????????rs?=?stmt.executeQuery（“SELECT?COUNT（*）?FROM?“?+?strSql）;
????????????if?（rs.next（））?{
???????????????intCount?=rs.getInt（1）;
????????????}?else?{
????????????????intCount?=?-1;
????????????}
????????}?catch?（Exception?e）?{
????????????intCount?=?-2;
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????????return?intCount;
}
public?void?close（）
{
try
{
	if（rs!=null）
		rs.close（）;
	????rs=null;
	if（stmt!=null）
		stmt.close（）;
????????stmt=null;
????if（conn!=null）
		conn.close（）;
	????conn=null;
}
catch?（Exception?e）
{
?e.printStackTrace（）;
}
?finally
{
???conn=null;??
}
}
}

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

?????文件????????851??2010-01-08?19:46??hospital\error.jsp

?????文件?????169984??2010-01-08?19:46??hospital\hospital門診收費系統（畢業論文）.doc

?????文件???????5677??2010-01-08?19:46??hospital\top.jsp

?????文件???????2064??2010-01-08?19:46??hospital\userLogin.jsp

?????文件????????179??2010-01-08?19:46??hospital\WEB-INF\web.xml

?????文件???????2804??2010-01-08?21:05??hospital\WEB-INF\classes\DBConnection\DBConnection.class

?????文件???????2470??2010-01-08?19:46??hospital\WEB-INF\classes\DBConnection\DBConnection.java

?????文件???????5927??2010-01-08?19:46??hospital\patient\patienttop.jsp

?????文件???????1158??2010-01-08?19:46??hospital\patient\patient_delete.jsp

?????文件????????619??2010-01-08?19:46??hospital\patient\patient_login.jsp

?????文件???????2147??2010-01-08?19:46??hospital\patient\patient_regist.jsp

?????文件???????1579??2010-01-08?19:47??hospital\patient\patient_registfinished.jsp

?????文件???????1445??2010-01-08?19:47??hospital\patient\patient_updatefinished.jsp

?????文件???????1611??2010-01-08?19:47??hospital\patient\select_patient.jsp

?????文件???????2159??2010-01-27?17:05??hospital\patient\patient_update.jsp

?????文件???????1606??2010-01-08?19:47??hospital\medicine\add_medicine.jsp

?????文件???????1182??2010-01-08?19:47??hospital\medicine\add_stored.jsp

?????文件???????1258??2010-01-08?19:47??hospital\medicine\add_storedfinish.jsp

?????文件???????1436??2010-01-08?19:47??hospital\medicine\medicine_addfinished.jsp

?????文件???????2922??2010-01-08?19:47??hospital\medicine\select_medicine.jsp

?????文件???????1879??2010-01-08?19:47??hospital\list\adminlist.jsp

?????文件???????2548??2010-01-08?19:47??hospital\list\adminlist_update.jsp

?????文件???????1260??2010-01-08?19:47??hospital\list\adminlist_updatefinish.jsp

?????文件???????1472??2010-01-08?19:47??hospital\list\buymedicine.jsp

?????文件???????1052??2010-01-08?19:47??hospital\list\list_delete.jsp

?????文件???????3531??2010-01-08?19:47??hospital\list\medicineBuyCar.jsp

?????文件???????2141??2010-01-08?19:47??hospital\list\medicineBuyCarAdd.jsp

?????文件????????796??2010-01-08?19:47??hospital\list\medicineBuyCarClear.jsp

?????文件???????2067??2010-01-08?19:47??hospital\list\medicineBuyCarSave.jsp

?????文件???????2229??2010-01-08?19:47??hospital\list\medicineOrder.jsp

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