package?connect_DB;

import?java.sql.*;

public?class?ConnectMySql?{
	public?static?String?DRIVER=“com.mysql.jdbc.Driver“;//驅動
	public?static?String?URL=“jdbc:mysql://localhost:3306/hotel?useUnicode=true&characterEncoding=utf-8&useSSL=false“;//地址
	public?static?String?USERNAME=“hotel“;//用戶名
	public?static?String?PASSWORD=“hotel“;//密碼
	static{
		try{
			Class.forName（DRIVER）;//初始化驅動
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
	public?static?Connection?getconnect（）{//建立連接
		Connection?con=null;
		try{
			if（con==null）{
			con=DriverManager.getConnection（URL?USERNAME?PASSWORD）;}
			System.out.println（“connect?DB“）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
		return?con;
	}
	public?static?void?closeconnect（Connection?con）{//關閉連接
		try{
			if（con!=null）{
				con.close（）;
				System.out.println（“close?DB“）;
			}
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}
	//查詢
	public?static?ResultSet?query（Connection?conString?sql）{
		ResultSet?rs?=?null;
		try?{
			Statement?stat=con.createStatement（）;
			rs=stat.executeQuery（sql）;
			System.out.println（“execute:“+sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?rs;
	}
	//修改:插入、更新、刪除
	public?static?int?modify（Connection?conString?sql）{
		int?r?=?-1;
		try?{
			Statement?stat=con.createStatement（）;
			r=stat.executeUpdate（sql）;
			System.out.println（“execute:“+sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?r;
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-01-09?15:42??HotelClient\
?????文件?????????446??2017-10-05?19:42??HotelClient\.classpath
?????文件?????????387??2017-08-13?20:16??HotelClient\.project
?????目錄???????????0??2018-01-09?15:42??HotelClient\.settings\
?????文件?????????598??2017-08-09?13:14??HotelClient\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-01-09?15:42??HotelClient\bin\
?????目錄???????????0??2018-01-09?15:42??HotelClient\bin\CustomerCheck\
?????文件????????1095??2017-10-05?19:42??HotelClient\bin\CustomerCheck\CCheckin$1.class
?????文件????????7889??2017-10-05?19:42??HotelClient\bin\CustomerCheck\CCheckin.class
?????目錄???????????0??2018-01-09?15:42??HotelClient\bin\CustomerManage\
?????文件?????????966??2017-10-05?19:42??HotelClient\bin\CustomerManage\CMframe$1.class
?????文件????????4942??2017-10-05?19:42??HotelClient\bin\CustomerManage\CMframe.class
?????目錄???????????0??2018-01-09?15:42??HotelClient\bin\Main\
?????文件????????2947??2017-10-05?19:42??HotelClient\bin\Main\ButtonPanel$BPListener.class
?????文件????????1409??2017-10-05?19:42??HotelClient\bin\Main\ButtonPanel$shijian.class
?????文件????????1474??2017-10-05?19:42??HotelClient\bin\Main\ButtonPanel$shuaxin.class
?????文件????????3534??2017-10-05?19:42??HotelClient\bin\Main\ButtonPanel.class
?????文件????????7569??2017-10-06?09:35??HotelClient\bin\Main\CCheckout.class
?????文件?????????712??2017-10-05?19:42??HotelClient\bin\Main\ExcRoomframe$1.class
?????文件????????3508??2017-10-05?19:42??HotelClient\bin\Main\ExcRoomframe.class
?????文件?????????685??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog$1.class
?????文件?????????742??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog$2.class
?????文件?????????959??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog$3.class
?????文件?????????742??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog$4.class
?????文件????????1439??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog$LDThread.class
?????文件????????1239??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog$LDclose.class
?????文件????????8681??2017-10-05?19:42??HotelClient\bin\Main\LoginDialog.class
?????文件????????1403??2017-10-05?19:42??HotelClient\bin\Main\Mainframe$shuaxin.class
?????文件????????2345??2017-10-05?19:42??HotelClient\bin\Main\Mainframe.class
?????文件?????????959??2017-10-05?19:42??HotelClient\bin\Main\Orderframe$1.class
?????文件????????4936??2017-10-05?19:42??HotelClient\bin\Main\Orderframe.class
............此處省略74個文件信息