package bookmanager;
import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.sql.*;

public class userAdd extends JFrame implements ActionListener
{
	public userAdd()
	{
		setTitle("添加用戶");
		setSize(200,200);
		gl=new GridLayout(5,2,20,20);
		JPanel panel=new JPanel();
		panel.setLayout(gl);
		userlbl=new JLabel("用戶名");
		passwordlbl=new JLabel("密碼(如果是借閱用戶則密碼為1)");
		confirmlbl=new JLabel("確認密碼");
		powerlbl=new JLabel("登陸權限");
		usertex=new JTextField("");
		passwordtex=new JPasswordField("");
		confirmtex=new JPasswordField("");
		String[] str={"管理員","借閱操作員","書籍管理員","借閱用戶"};
		powercob=new JComboBox(str);
		addbtn=new JButton("確認");
		cancelbtn=new JButton("取消");
		panel.add(userlbl);
		panel.add(usertex);
		panel.add(passwordlbl);
		panel.add(passwordtex);
		panel.add(confirmlbl);
		panel.add(confirmtex);
		panel.add(powerlbl);
		panel.add(powercob);
		panel.add(addbtn);
		panel.add(cancelbtn);
		getContentPane().add(panel);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			if(usertex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"用戶名不能為空!");
			return;
		}
		String  s=new String(passwordtex.getPassword()).trim();
		if(s.equals(""))
		{
			JOptionPane.showMessageDialog(null,"密碼名不能為空!");
			return;
		}
		String confirm=new String(confirmtex.getPassword()).trim();
		if(confirm.equals("")||!(confirm.equals(s)))
		{
			JOptionPane.showMessageDialog(null,"密碼不一樣");
			confirmtex.setText("");
			usertex.setText("");
			passwordtex.setText("");
			return;
		}
		String power=(String)powercob.getSelectedItem();
		if(power.equals("借閱用戶"))
		{
			String strsql;
			strsql=("insert into user(username) values ('"+usertex.getText().trim()+"')");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql);
			//判斷結果是否正確
			if(!success){
				JOptionPane.showMessageDialog(null,"添加用戶不成功，請從新再添加");
			}
			else{
				JOptionPane.showMessageDialog(null,"添加成功");
			}
			this.dispose();
		}
		else
		{
			String strsql=("insert into admin(username,password,power) values ('"+usertex.getText().trim()+"','"+s+"','"+power+"')");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql);
			//判斷結果是否正確
			if(!success){
				JOptionPane.showMessageDialog(null,"添加用戶不成功，請從新再添加");
			}
			else{
				JOptionPane.showMessageDialog(null,"添加成功");
			}
			this.dispose();
		}
		if(source==cancelbtn)
		{
			this.dispose();
			return;
		}
	}
		/*
			String user=usertex.getText();
			ch=passwordtex.getPassword();
			String password=new String(ch);
			if(user.trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"用戶名不能為空!");
			return;
		}
		if(password.trim().equals(""))
		{
			JOptionPane.showMessageDialog(null,"密碼名不能為空!");
			return;
		}
			if(user.equals("admin")&&password.equals("admin"))
			{
				myBook.setEnabled("管理員");
			}
			if(user.equals("borrowcontrol")&&password.equals("borrowcontrol"))
			{
				myBook.setEnabled("借閱操作員");
			}
			if(user.equals("bookcontrol")&&password.equals("bookcontrol"))
			{
				myBook.setEnabled("書籍管理員");
			}
			this.dispose();
		}*/
		if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
		}
	
	private JLabel userlbl;
	private JLabel passwordlbl;
	private JLabel confirmlbl;
	private JLabel powerlbl;
	private JTextField usertex;
	private JPasswordField passwordtex;
	private JPasswordField confirmtex;
	private JComboBox powercob;
	private JButton addbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private ResultSet rs;
	private DBManager db=new DBManager();
}