package?com.dinner.baseSql;


import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.Statement;

public?class?baseSql
{
	/**
	?*?連接oracle
	?*?@return?Connection?conn
	?*?@throws?Exception
	?*/
	public?Connection?getConnection（）?throws?Exception
	{//oracle.jdbc.driver.OracleDriver
		//設置包
		Class.forName（“com.mysql.jdbc.Driver“）;
		//“jdbc:oracle:thin:@localhost:1521:XE“
		String?URL???????=??“jdbc:mysql://localhost:3306/dinner“;
		String?username??=??“root“;
		String?password??=??“123456“;
		Connection?conn??=???DriverManager.getConnection（URL?username?password）;
		return?conn;

	}
	/**
	?*?查詢操作
	?*?@param?conn
	?*?@param?sql
	?*?@return
	?*?@throws?Exception
	?*/
	public?ResultSet?getQuery（Connection?conn?String?sql）?throws?Exception
	{
	
		ResultSet?res??=?null;
		if（conn!=null&&!conn.isClosed（））{
			Statement?state?=?conn.createStatement（）;
			res?=??state.executeQuery（sql）;
		}
		return?res;
	}
	/**
	?*?更新操作??增?刪?改
	?*?@param?connection
	?*?@param?sql
	?*?@return?count??sql結果的行數
	?*?@throws?Exception
	?*/
	public??int?getUpdate（?Connection?connection?String?sql）?throws?Exception
	{
		int?count??=?0;
		if（?connection!=null&&?!connection.isClosed（）?）{
			Statement?statement?=?connection.createStatement（）;
			count??=?statement.executeUpdate（sql）;???????
		}
		return?count;
	}?
	/**
	?*?關閉連接
	?*?@param?conn
	?*?@throws?Exception
	?*/
	public?void?ConnectionClose（Connection?conn）?throws?Exception
	{
		if（conn!=null&&?!conn.isClosed（））{
			conn.close（）;
			conn?=?null;?
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-08-02?16:06??餐飲管理系統\
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\
?????文件????????1320??2018-07-30?14:19??餐飲管理系統\dinner\.classpath
?????文件????????1331??2018-07-23?09:33??餐飲管理系統\dinner\.project
?????目錄???????????0??2018-08-02?16:06??餐飲管理系統\dinner\.settings\
?????文件?????????522??2018-07-22?18:33??餐飲管理系統\dinner\.settings\.jsdtscope
?????文件?????????364??2018-07-22?18:33??餐飲管理系統\dinner\.settings\org.eclipse.jdt.core.prefs
?????文件?????????477??2018-07-22?18:33??餐飲管理系統\dinner\.settings\org.eclipse.wst.common.component
?????文件?????????414??2018-07-22?18:33??餐飲管理系統\dinner\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-07-22?18:33??餐飲管理系統\dinner\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-07-22?18:33??餐飲管理系統\dinner\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\
?????文件????????3314??2018-07-24?20:26??餐飲管理系統\dinner\WebRoot\Login.jsp
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\meta-INF\
?????文件??????????39??2018-07-22?18:33??餐飲管理系統\dinner\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\WEB-INF\
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\Until\
?????文件????????2052??2018-07-30?15:47??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\Until\DBUtil.class
?????文件?????????105??2018-07-23?13:33??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\Until\jdbc.properties
?????目錄???????????0??2018-08-02?16:07??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\
?????文件????????2505??2018-07-30?15:47??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\Cuisine.class
?????文件????????1265??2018-07-30?15:47??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\Desk.class
?????文件????????3060??2018-08-01?14:25??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\Form.class
?????文件????????1563??2018-08-01?11:52??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\Item.class
?????文件????????1328??2018-07-31?23:05??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\MenuPaging.class
?????文件????????1258??2018-07-30?21:52??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\Menutype.class
?????文件????????2595??2018-07-30?20:42??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\Page.class
?????文件????????1622??2018-07-30?15:47??餐飲管理系統\dinner\WebRoot\WEB-INF\classes\com\dinner\User\User.class
............此處省略195個文件信息