package?dao;

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

public?class?baseDao?{
	private?static?final?String?DRIVER=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?final?String?UID=“jdbc:sqlserver://localhost:1433;databaseName=restrant“;
	private?static?final?String?NAME=“sa“;
	private?static?final?String?PWD=“tcaccp“;
	
	public?static?Connection?getConnection（）
	{
		Connection?con=null;
		try?{
			Class.forName（DRIVER）;
			con=DriverManager.getConnection（UIDNAMEPWD）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?con;
	}
	public?static?void?CloseAll（Connection?conPreparedStatement?psResultSet?rs）
	{
		try?{
			if（rs?!=null）
			{
				rs.close（）;
			}
			if（ps?!=null）
			{
				ps.close（）;
			}
			if（con?!=null）
			{
				con.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}

}

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

?????文件????????548??2010-09-06?08:19??訂餐項目\訂餐項目\restrant\.classpath

?????文件????????297??2010-09-06?08:18??訂餐項目\訂餐項目\restrant\.mymetadata

?????文件???????1414??2010-08-19?09:40??訂餐項目\訂餐項目\restrant\.project

?????文件????????500??2010-08-19?09:40??訂餐項目\訂餐項目\restrant\.settings\.jsdtscope

?????文件?????????49??2010-08-19?09:40??訂餐項目\訂餐項目\restrant\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-08-19?09:40??訂餐項目\訂餐項目\restrant\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1186??2010-08-11?17:15??訂餐項目\訂餐項目\restrant\src\dao\baseDao.java

?????文件???????1048??2010-08-28?16:01??訂餐項目\訂餐項目\restrant\src\dao\FoodInfoDao.java

?????文件???????1015??2010-09-03?12:34??訂餐項目\訂餐項目\restrant\src\dao\FoodOrderInfoDao.java

?????文件????????964??2010-08-18?22:47??訂餐項目\訂餐項目\restrant\src\dao\UserInfoDao.java

?????文件???????1078??2010-08-26?09:00??訂餐項目\訂餐項目\restrant\src\entity\FoodInfo.java

?????文件????????372??2010-08-28?16:53??訂餐項目\訂餐項目\restrant\src\entity\FoodItem.java

?????文件???????1275??2010-09-03?12:28??訂餐項目\訂餐項目\restrant\src\entity\FoodOrderInfo.java

?????文件????????523??2010-08-18?22:28??訂餐項目\訂餐項目\restrant\src\entity\UserInfo.java

?????文件???????1188??2010-09-22?11:51??訂餐項目\訂餐項目\restrant\src\filter\TestFilter.java

?????文件???????2320??2010-08-26?09:33??訂餐項目\訂餐項目\restrant\src\myservlet\Idservlet.java

?????文件???????1966??2010-09-22?11:53??訂餐項目\訂餐項目\restrant\src\myservlet\Loginservlet.java

?????文件???????2035??2010-09-06?08:40??訂餐項目\訂餐項目\restrant\src\myservlet\OrderServlet2.java

?????文件???????1724??2010-08-26?09:16??訂餐項目\訂餐項目\restrant\src\myservlet\ServletA.java

?????文件???????9154??2010-09-03?12:08??訂餐項目\訂餐項目\restrant\WebRoot\checkA.jsp

?????文件???????9779??2010-09-06?08:20??訂餐項目\訂餐項目\restrant\WebRoot\checkLogin.jsp

?????文件???????8983??2010-09-06?08:23??訂餐項目\訂餐項目\restrant\WebRoot\checkOut.jsp

?????文件???????1057??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\css\styles.css

?????文件???????9119??2010-08-26?08:38??訂餐項目\訂餐項目\restrant\WebRoot\details.jsp

?????文件????????575??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\images\0.gif

?????文件????????129??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\images\001.gif

?????文件??????10955??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\images\001.jpg

?????文件?????????65??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\images\002.gif

?????文件??????17318??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\images\002.jpg

?????文件?????????52??2010-08-17?17:08??訂餐項目\訂餐項目\restrant\WebRoot\images\003.gif

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