package?com.restrant.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.List;

public?class?baseDao?{
	public?baseDao（）?{
		try?{
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}

	private?Connection?conn;
	private?Statement?stm;
	private?PreparedStatement?pstm;
	private?ResultSet?rs;

	public?Connection?getConn（）?{
		try?{
			if?（conn?==?null?||?conn.isClosed（））?{
				conn?=?DriverManager.getConnection（
						“jdbc:sqlserver://127.0.0.1:1433;databasename=restrant“
						“sa“?“sa“）;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
			System.out.println（“getConnection（）錯誤“）;
		}
		return?conn;
	}

	public?int?executeUpdate（String?sql）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數(shù)據(jù)庫連接失敗!“）;
			return?-1;
		}
		stm?=?conn.createStatement（）;
		return?stm.executeUpdate（sql）;
	}

	public?int?executeUpdate（String?sql?object[]?obj）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數(shù)據(jù)庫連接失敗!“）;
			return?-1;
		}
		pstm?=?conn.prepareStatement（sql）;
		if?（obj?!=?null）?{
			for?（int?i?=?0;?i?				pstm.setobject（i?+?1?obj[i]）;
			}
		}
		return?pstm.executeUpdate（）;
	}

	public?int?executeUpdate（String?sql?List?args）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數(shù)據(jù)庫連接失敗!“）;
			return?-1;
		}
		pstm?=?conn.prepareStatement（sql）;
		if?（args?!=?null）?{
			for?（int?i?=?0;?i?				pstm.setobject（i?+?1?args.get（i））;
			}
		}
		return?pstm.executeUpdate（）;
	}
	
	public?ResultSet?executeQuery（String?sql）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數(shù)據(jù)庫連接失敗!“）;
			return?null;
		}
		stm?=?conn.createStatement（）;
		rs?=?stm.executeQuery（sql）;
		return?rs;
	}

	public?ResultSet?executeQuery（String?sql?object[]?obj）?throws?SQLException?{
		if?（getConn（）?==?null）?{
			System.out.println（“與數(shù)據(jù)庫連接失敗!“）;
			return?null;
		}
		pstm?=?conn.prepareStatement（sql）;
		if?（obj?!=?null）?{
			for?（int?i?=?0;?i?				pstm.setobject（i?+?1?obj[i]）;
			}
		}
		rs?=?pstm.executeQuery（）;
		return?rs;
	}

	public?void?closeResultSet（）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
	}

	public?void?closeConnection（）?{
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	public?void?closeStatement（）?{
		if?（stm?!=?null）?{
			try?{
				stm.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}

		if?（pstm?!=?null）?{
			try?{
				pstm.close（）;
			}?catch?（SQLException?

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

?????文件????????440??2010-04-12?09:04??MyRestrant\.classpath

?????文件????????303??2011-05-04?08:20??MyRestrant\.mymetadata

?????文件???????1416??2011-04-12?15:38??MyRestrant\.project

?????文件????????500??2011-04-12?15:38??MyRestrant\.settings\.jsdtscope

?????文件????????316??2011-05-04?11:33??MyRestrant\.settings\org.eclipse.core.resources.prefs

?????文件?????????49??2011-04-12?15:38??MyRestrant\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-04-12?15:38??MyRestrant\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????2031616??2011-05-04?12:22??MyRestrant\data\restrant_Data.MDF

?????文件????3932160??2011-05-04?12:22??MyRestrant\data\restrant_Log.LDF

?????文件???????3138??2009-04-12?12:44??MyRestrant\src\com\restrant\dao\baseDao.java

?????文件???????3275??2010-04-12?09:38??MyRestrant\src\com\restrant\dao\FoodDao.java

?????文件????????680??2009-04-12?12:04??MyRestrant\src\com\restrant\dao\FoodOderDao.java

?????文件???????1621??2009-04-12?12:34??MyRestrant\src\com\restrant\dao\UserDao.java

?????文件????????497??2009-04-12?10:53??MyRestrant\src\com\restrant\entity\CartItemBean.java

?????文件???????1006??2010-04-12?08:54??MyRestrant\src\com\restrant\entity\FoodInfo.java

?????文件???????1305??2009-04-12?11:45??MyRestrant\src\com\restrant\entity\FoodOderBean.java

?????文件???????1167??2010-04-12?08:54??MyRestrant\src\com\restrant\entity\FoodOrderInfo.java

?????文件????????894??2010-04-12?08:54??MyRestrant\src\com\restrant\entity\SellDetails.java

?????文件????????388??2010-04-12?08:54??MyRestrant\src\com\restrant\entity\UserInfo.java

?????文件???????1853??2009-04-12?11:21??MyRestrant\src\com\restrant\servlet\AddFoodToCart.java

?????文件????????709??2011-04-12?16:32??MyRestrant\src\com\restrant\servlet\DeleteFoodServlet.java

?????文件????????835??2010-04-12?09:53??MyRestrant\src\com\restrant\servlet\FoodServlet.java

?????文件???????1481??2009-04-12?12:12??MyRestrant\src\com\restrant\servlet\OrderServlet.java

?????文件????????937??2009-04-12?12:36??MyRestrant\src\com\restrant\servlet\RegisterServlet.java

?????文件???????2510??2009-04-12?12:41??MyRestrant\src\com\restrant\servlet\UserServlet.java

?????文件???????5039??2011-05-04?11:43??MyRestrant\WebRoot\checkOut.jsp

?????文件???????5195??2011-05-04?11:45??MyRestrant\WebRoot\details.jsp

?????文件????????575??2010-04-12?09:18??MyRestrant\WebRoot\images\0.gif

?????文件????????129??2010-04-12?09:18??MyRestrant\WebRoot\images\001.gif

?????文件??????10955??2010-04-12?09:18??MyRestrant\WebRoot\images\001.jpg

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