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);
}
}