package com.ucai.admin;

import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.BorderFactory;
import javax.swing.ImageIcon;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.Color;
import java.awt.Font;
import java.awt.HeadlessException;
import java.awt.SystemColor;
import java.sql.SQLException;

import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.JButton;
import javax.swing.UIManager;
import javax.swing.JPanel;
import javax.swing.border.BevelBorder;

import com.ucai.dbcp.JDBCTemplate;
import com.ucai.jdbc.BankJdbc;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

public class db_longin {

	JFrame frame;
	private JTextField t1;
	private JTextField t2;
	private JTextField t3;
	private JTextField t4;

	/**
	 * Launch the application.
	 */

	/**
	 * Create the application.
	 * @throws SQLException 
	 */
	public db_longin() throws SQLException {
		initialize();
	}

	/**
	 * Initialize the contents of the frame.
	 * @throws SQLException 
	 */
	private void initialize() throws SQLException {
		frame = new JFrame();
		frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		frame.getContentPane().setBackground(UIManager.getColor("CheckBox.light"));
		frame.setBounds(100, 100, 389, 453);
		frame.getContentPane().setLayout(null);
		
		JLabel jl2 = new JLabel("工号");
		jl2.setHorizontalAlignment(SwingConstants.CENTER);
		jl2.setBackground(Color.GRAY);
		jl2.setFont(new Font("仿宋", Font.BOLD, 18));
		jl2.setBounds(28, 196, 65, 38);
		frame.getContentPane().add(jl2);
		
		JScrollPane jp ;
		jp=BankJdbc.tabel3();
		jp.setBounds(28, 13, 330, 100);
		frame.getContentPane().add(jp);
		
		t1 = new JTextField();
		t1.setBounds(28, 247, 65, 40);
		frame.getContentPane().add(t1);
		t1.setColumns(10);
		
		t2 = new JTextField();
		t2.setBounds(107, 247, 62, 40);
		frame.getContentPane().add(t2);
		t2.setColumns(10);
		
		t3 = new JTextField();
		t3.setBounds(180, 247, 65, 40);
		frame.getContentPane().add(t3);
		t3.setColumns(10);
		
		t4 = new JTextField();
		t4.setBounds(262, 247, 86, 40);
		frame.getContentPane().add(t4);
		t4.setColumns(10);
		
		JLabel jl3 = new JLabel("姓名");
		jl3.setHorizontalAlignment(SwingConstants.CENTER);
		jl3.setFont(new Font("仿宋", Font.BOLD, 18));
		jl3.setBackground(Color.GRAY);
		jl3.setBounds(107, 196, 65, 38);
		frame.getContentPane().add(jl3);
		
		JLabel jl4 = new JLabel("密码");
		jl4.setHorizontalAlignment(SwingConstants.CENTER);
		jl4.setFont(new Font("仿宋", Font.BOLD, 18));
		jl4.setBackground(Color.GRAY);
		jl4.setBounds(180, 196, 65, 38);
		frame.getContentPane().add(jl4);
		
		JLabel jl5 = new JLabel("业务类型");
		jl5.setHorizontalAlignment(SwingConstants.CENTER);
		jl5.setFont(new Font("仿宋", Font.BOLD, 18));
		jl5.setBackground(Color.GRAY);
		jl5.setBounds(262, 196, 86, 38);
		frame.getContentPane().add(jl5);
		
		JButton jb1 = new JButton("主菜单");
		jb1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				new AdminUI();
				frame.dispose();
			}
		});
		jb1.setBackground(UIManager.getColor("Button.disabledForeground"));
		jb1.setFont(new Font("微软雅黑", Font.BOLD, 16));
		jb1.setBounds(12, 344, 91, 49);
		frame.getContentPane().add(jb1);
		
		JButton jb2 = new JButton("删 除");
		jb2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				if(t1.getText().equals("")){
					JOptionPane.showMessageDialog(frame, "请输入工号进行删除");
				}else{
						try {
							if(BankJdbc.delete(t1.getText())){
								JOptionPane.showMessageDialog(frame, "删除成功");
							}else{
								JOptionPane.showMessageDialog(frame, "删除失败");
							}
						} catch (HeadlessException | SQLException e1) {
							e1.printStackTrace();
					}
				}
			}
		});
		jb2.setFont(new Font("微软雅黑", Font.BOLD, 16));
		jb2.setBounds(118, 344, 71, 49);
		frame.getContentPane().add(jb2);
		
		JButton jb3 = new JButton("添 加");
		jb3.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {

				
			}
		});
		jb3.setFont(new Font("微软雅黑", Font.BOLD, 16));
		jb3.setBounds(203, 344, 71, 49);
		frame.getContentPane().add(jb3);
		
		JButton jb4 = new JButton("刷 新");
		jb4.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
		
			}
		});
		jb4.setFont(new Font("微软雅黑", Font.BOLD, 16));
		jb4.setBounds(288, 344, 71, 49);
		frame.getContentPane().add(jb4);
		
		JPanel panel = new JPanel();
		panel.setBorder(new BevelBorder(BevelBorder.LOWERED, null, null, null, null));
		panel.setBackground(UIManager.getColor("Button.shadow"));
		panel.setBounds(14, 144, 347, 177);
		panel.setBorder(BorderFactory.createTitledBorder("修改员工信息")); 
		frame.getContentPane().add(panel);
	}
}