package?com.hk.base;
import?java.sql.*;

public?class?Business{
	//加載驅動，創建連接，釋放資源
	private?static?final?String?driver?=?“com.mysql.jdbc.Driver“;
	private?static?final?String?url=“jdbc:mysql://127.0.0.1:3306/zk“;
	private?static?final?String?username=“root“;
	private?static?final?String?pwd=“root“;


	static{
		try{
			Class.forName（driver）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}

	public?static?Connection?getConnection（）{
		Connection?con?=?null;
		try{
			con?=?DriverManager.getConnection（urlusernamepwd）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
		return?con;
	}

	public?static?void?release（ResultSet?rsStatement?stmtConnection?con）{

		try{if（rs!=null）rs.close（）;}catch（Exception?e）{e.printStackTrace（）;}
		try{if（stmt!=null）stmt.close（）;}catch（Exception?e）{e.printStackTrace（）;}
		try{if（con!=null）con.close（）;}catch（Exception?e）{e.printStackTrace（）;}
				if（rs==null）System.out.println（“rs==null“+“util“）;
	}
	public?static?void?release（object?o）{
	try{
		if（o?instanceof?ResultSet）{
			（（ResultSet）o）.close（）;
		}else?if（o?instanceof?Statement）{
			（（Statement）o）.close（）;
		}else?if（o?instanceof?Connection）{
			（（Connection）o）.close（）;
		}
	}catch（Exception?e）{
		e.printStackTrace（）;
	}
	}
	public?static?void?printRs（ResultSet?rs）{
		if（rs==null）?return;
	try{
		ResultSetmetaData?md?=?rs.getmetaData（）;
		int?colmun?=?md.getColumnCount（）;
		StringBuffer?sb?=?new?StringBuffer（）;
		for（int?i=1;?i<=colmun;?i++）{
			sb.append（md.getColumnName（i）+“\t“）;
		}
		sb.append（“\n“）;
			while（rs.next（））{
				for（int?i=1;?i<=colmun;?i++）{
					sb.append（rs.getString（i）+“\t“）;
				}
				sb.append（“\n“）;
			}
			System.out.println（sb.toString（））;
	}catch（Exception?e）{
		e.printStackTrace（）;
	}
	}
}

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

?????文件???????3143??2010-11-13?17:04??num_02\database\hk.sql

?????文件???????1902??2010-11-09?13:15??num_02\JavaPrj_2\.classpath

?????文件????????435??2010-06-03?13:51??num_02\JavaPrj_2\.myhibernatedata

?????文件?????????66??2010-06-03?13:51??num_02\JavaPrj_2\.myumldata

?????文件????????719??2010-11-07?20:58??num_02\JavaPrj_2\.project

?????文件???????1193??2010-11-13?17:05??num_02\JavaPrj_2\src\hibernate.cfg.xml

?????文件????????863??2010-11-09?14:21??num_02\JavaPrj_2\src\com\hk\tool\Cal.java

?????文件????????306??2010-11-09?14:21??num_02\JavaPrj_2\src\com\hk\tool\IllegalDateFormatException.java

?????文件???????5035??2010-11-09?14:21??num_02\JavaPrj_2\src\com\hk\tool\MyDate.java

?????文件???????3100??2010-11-13?14:35??num_02\JavaPrj_2\src\com\hk\server\AddBranch.java

?????文件???????3879??2010-11-09?14:21??num_02\JavaPrj_2\src\com\hk\server\AddFlight.java

?????文件???????6378??2010-11-13?10:35??num_02\JavaPrj_2\src\com\hk\server\AddFlightPlan.java

?????文件???????2895??2010-11-11?19:40??num_02\JavaPrj_2\src\com\hk\server\AddPlaneModel.java

?????文件???????1845??2010-11-09?14:16??num_02\JavaPrj_2\src\com\hk\server\ArrayListTableModel.java

?????文件???????4147??2010-11-13?16:19??num_02\JavaPrj_2\src\com\hk\server\Controller.java

?????文件???????1261??2010-11-09?14:16??num_02\JavaPrj_2\src\com\hk\server\FlightSchedularTableModel.java

?????文件???????2350??2010-11-13?14:56??num_02\JavaPrj_2\src\com\hk\server\RemoveBranch.java

?????文件???????1595??2010-11-13?10:38??num_02\JavaPrj_2\src\com\hk\server\RemoveFlightPlan.java

?????文件????????685??2010-11-13?10:44??num_02\JavaPrj_2\src\com\hk\server\SearchAllBranchs.java

?????文件????????700??2010-11-09?14:21??num_02\JavaPrj_2\src\com\hk\server\SearchAllOrder.java

?????文件???????2875??2010-11-13?10:47??num_02\JavaPrj_2\src\com\hk\server\SearchFlightPlan.java

?????文件???????3537??2010-11-10?08:33??num_02\JavaPrj_2\src\com\hk\server\SearchOrderFromBranch.java

?????文件???????1119??2010-11-13?10:47??num_02\JavaPrj_2\src\com\hk\server\SearchPanel.java

?????文件???????3172??2010-11-13?14:34??num_02\JavaPrj_2\src\com\hk\server\ServerMainClass.java

?????文件???????3700??2010-11-13?14:55??num_02\JavaPrj_2\src\com\hk\server\ServerMainframe.java

?????文件????????405??2010-11-09?14:15??num_02\JavaPrj_2\src\com\hk\server\ServerThread.java

?????文件?????????15??2010-11-09?23:35??num_02\JavaPrj_2\src\com\hk\server\server.properties

?????文件???????1065??2010-11-09?14:02??num_02\JavaPrj_2\src\com\hk\model\CabinClass.java

?????文件???????1051??2010-11-10?03:49??num_02\JavaPrj_2\src\com\hk\model\Flight.hbn.xml

?????文件???????3019??2010-11-09?14:02??num_02\JavaPrj_2\src\com\hk\model\Flight.java

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