public class LoginFrame extends JFrame {
	private JPanel contentPane;
	private JTextField textField;
	private JPasswordField passwordField;
	private JTextField textField_1;
	private CaptchaUtils cpt;
	private BufferedImage image1;
	private String code;
	private JLabel label_6;
	//創(chuàng)建deskservice對(duì)象
	private DeskService deskService=new DeskServiceImpl();
 
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					LoginFrame frame = new LoginFrame();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}
	
	public LoginFrame() {
		setBackground(Color.GREEN);
		setTitle("KING'S  LANDING");
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setBounds(500, 250, 624, 524);
 
		contentPane = new JPanel(){
	   		 protected void paintComponent(Graphics g){
				 super.paintComponent(g);
				 ImageIcon images=new ImageIcon("images/624524.jpg");
				 g.drawImage(images.getImage(),0,0,null);
			 }
		 };	
		
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		JLabel label_1 = new JLabel("\u7528\u6237\u540D");
		label_1.setBackground(Color.WHITE);
		label_1.setForeground(Color.WHITE);
		label_1.setFont(new Font("微軟雅黑", Font.PLAIN, 15));
		label_1.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/yonghu.png")));
		textField = new JTextField();
		textField.setBackground(Color.WHITE);
		textField.setColumns(10);
	        label_6=new JLabel();
	        label_6.addMouseListener(new MouseAdapter() {
	        	@Override
	        	public void mouseClicked(MouseEvent e) {
	        		cpt=new CaptchaUtils();
	    			//獲取畫布
	    			image1=cpt.getBuffImg();
	    			//獲取隨機(jī)數(shù)
	    			 code=cpt.getCode();
	    			ImageIcon icon=new ImageIcon(image1,"jpeg");
	    			label_6.setIcon(icon);
	        	}
	        });
 
			/**
			 * 驗(yàn)證碼
			 */
			cpt=new CaptchaUtils();
			//獲取畫布
			image1=cpt.getBuffImg();
			//獲取隨機(jī)數(shù)
			 code=cpt.getCode();
			ImageIcon icon=new ImageIcon(image1,"jpeg");
			label_6.setIcon(icon);
		
		JLabel label_2 = new JLabel("\u5BC6\u7801");
		label_2.setForeground(Color.WHITE);
		label_2.setFont(new Font("微軟雅黑", Font.PLAIN, 15));
		label_2.setIcon(new ImageIcon(LoginFrame.class.getResource("/images/mima.png")));
		
		JButton button = new JButton("\u767B\u5F55");
		//設(shè)置按鈕的透明
		button.setContentAreaFilled(false);
		//給按鈕上的字設(shè)置顏色
		button.setForeground(Color.WHITE);
		button.setBackground(Color.WHITE);
		button.setFont(new Font("微軟雅黑", Font.PLAIN, 20));
		button.addMouseListener(new MouseAdapter() {
			@Override
			public void mouseClicked(MouseEvent e) {
				//獲取輸入的用戶名和密碼
				String name=textField.getText();
				char[]array=passwordField.getPassword();
				String password=new String(array);
				System.out.println("name:"+name);
				System.out.println("password:"+password);
				//用戶輸入的驗(yàn)證碼
				String codeFrame=textField_1.getText();
				if(!(code.equalsIgnoreCase((codeFrame)))){
					JOptionPane.showMessageDialog(null, "驗(yàn)證碼錯(cuò)誤,請(qǐng)重新輸入！");
					return;
				}
				DeskDaoImpl deskDao=new DeskDaoImpl();
				Desk desk=new Desk(name,password);
				int code=deskDao.LoginDesk(desk);
				//判斷是否是管理員登錄
				if(code==1){
					//登錄成功
					new HomeFrame().setVisible(true);
					//符合 則跳轉(zhuǎn)到管理員的后臺(tái)管理界面
					dispose();
					return ;
				}
				else{
					boolean bool=deskService.LoginDeskService(desk);
					if(!bool){
						JOptionPane.showMessageDialog(null, "賬號(hào)或密碼錯(cuò)誤,請(qǐng)重新輸入！");
						return;
					}
					//登錄成功
					new HomeFrame().setVisible(true);
					dispose();
				}
		});
		
}

CREATE TABLE `NewTable` (
`d_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '前臺(tái)id' ,
`d_name`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '姓名' ,
`d_password`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '密碼' ,
INDEX `d_id` (`d_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=112
ROW_FORMAT=COMPACT
;
 

CREATE TABLE `NewTable` (
`g_roomid`  int(11) NULL DEFAULT NULL COMMENT '房間id' ,
`g_id`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '顧客編號(hào)' ,
`g_name`  varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '姓名' ,
`g_sex`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '性別' ,
`g_age`  int(11) NULL DEFAULT NULL COMMENT '年齡' ,
`g_days`  int(11) NULL DEFAULT NULL COMMENT '入住天數(shù)' ,
`g_time`  datetime NULL DEFAULT NULL COMMENT '入住日期' 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
ROW_FORMAT=COMPACT
;
 

CREATE TABLE `NewTable` (
`r_id`  int(11) NOT NULL AUTO_INCREMENT COMMENT 'roo  id' ,
`r_type`  varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'room 類型' ,
`r_price`  double NULL DEFAULT NULL COMMENT 'room價(jià)格' ,
`r_local`  varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'room位置' ,
`r_state`  varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'room狀態(tài)' ,
INDEX `r_id` (`r_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=106
ROW_FORMAT=COMPACT
;