package com.ucai.admin;
import java.awt.Color;
import java.awt.Container;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.SQLException;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTextField;
import com.ucai.dbcp.JDBCTemplate;
import com.ucai.jdbc.BankJdbc;
import com.ucai.thread.Time;
import com.ucai.tool.Set;
public class SubFrame implements ActionListener{
private static JFrame jf;
private JScrollPane jp;
private JTextField t1;
private JTextField t2;
private JTextField t3;
private JTextField t4;
private JButton jb1;
private JButton jb2;
private JButton jb3;
private JButton jb4;
private JTextField t11;
private JTextField t22;
private JTextField t33;
private JTextField t44;
private JButton jb11;
private JButton jb22;
private JButton jb33;
private JButton jb44;
private Container c;
public SubFrame(String str){
jf = new JFrame(str);
c=new Container();
c=Set.setBack(jf, "image/tabelback.jpg");
if(str.equals("用户管理")){
JLabel jl1=new JLabel("输入修改的信息",JLabel.CENTER);
JLabel jl2=new JLabel("工号 姓名 密码 业务类型",JLabel.CENTER);
JLabel jl3=new JLabel("2017-9-9",JLabel.CENTER);//***************时间放置
Time time = new Time(jl3);
time.start();
t1 = new JTextField(10);
t2 = new JTextField(10);
t3 = new JTextField(10);
t4 = new JTextField(10);
jb1 = new JButton("添 加");
jb2 = new JButton("主菜单");
jb3 = new JButton("删 除");
jb4 = new JButton("刷 新");//注意此处俩个字之间带空格
jb1.setBounds(240, 370, 80, 30);
jb2.setBounds(30, 350, 80, 50);
jb3.setBounds(130, 370, 80, 30);
jb4.setBounds(350, 370, 80, 30);
t1.setBounds(30, 300, 90, 30);
t2.setBounds(140, 300, 90, 30);
t3.setBounds(240, 300, 90, 30);
t4.setBounds(340, 300, 90, 30);
jl1.setBounds(30, 200, 90, 30);
jl2.setBounds(30, 250, 400, 30);
jl3.setFont(new Font("黑体",1,36));
jl3.setForeground(Color.red);
jl3.setBounds(60, 400, 400, 60);
jl1.setOpaque(true);
jl2.setOpaque(true);
jl3.setOpaque(false);
c.add(jl1);
c.add(jl2);
c.add(jl3);
c.add(jb1);
c.add(jb2);
c.add(jb3);
c.add(jb4);
c.add(t1);
c.add(t2);
c.add(t3);
c.add(t4);
jb1.addActionListener(this);
jb2.addActionListener(this);
jb3.addActionListener(this);
jb4.addActionListener(this);
try {
jp=BankJdbc.tabel3();
c.add(jp);
jp.setBounds(30, 90, 400, 100);
} catch (SQLException e) {
e.printStackTrace();
}
}else if(str.equals("办理情况")){
JLabel jl7=new JLabel("办理情况",JLabel.CENTER);
JLabel jlt=new JLabel("2017-9-9",JLabel.CENTER);//*******************时间放置
jlt.setFont(new Font("黑体",1,36));
jlt.setForeground(Color.red);
jlt.setBounds(60, 400, 400, 60);
jl7.setBounds(30, 30, 90, 30);
Time time = new Time(jlt);
time.start();
try {
jp=BankJdbc.tabel1();
} catch (SQLException e) {
e.printStackTrace();
}
c.add(jlt);
c.add(jp);
jp.setBounds(15, 40, 520, 100);
}
else if(str.equals("窗口办理")){
JLabel jl11=new JLabel("输入修改的信息",JLabel.CENTER);
JLabel jl22=new JLabel("窗口 姓名 业务类型 最大量",JLabel.CENTER);
JLabel jlt=new JLabel("2017-9-9",JLabel.CENTER);//*******************时间放置
jlt.setFont(new Font("黑体",1,36));
jlt.setForeground(Color.red);
jlt.setBounds(60, 400, 400, 60);
//jl7.setBounds(30, 30, 90, 30);
Time time = new Time(jlt);
time.start();
try {
jp=BankJdbc.tabel8();
} catch (SQLException e) {
e.printStackTrace();
}
c.add(jlt);
t11 = new JTextField(10);
t22 = new JTextField(10);
t33 = new JTextField(10);
t44 = new JTextField(10);
jb11 = new JButton("添加");
jb22 = new JButton("主菜单");
jb33 = new JButton("删除");
jb44 = new JButton("刷新");//注意此处俩个字之间带空格
jb11.setBounds(240, 340, 80, 30);
jb22.setBounds(30, 320, 80, 50);
jb33.setBounds(130, 340, 80, 30);
jb44.setBounds(350, 340, 80, 30);
t11.setBounds(30, 270, 90, 30);
t22.setBounds(140, 270, 90, 30);
t33.setBounds(240, 270, 90, 30);
t44.setBounds(340, 270, 90, 30);
jl11.setBounds(30, 170, 90, 30);
jl22.setBounds(30, 220, 400, 30);
jl11.setOpaque(true);
jl22.setOpaque(true);
c.add(jl11);
c.add(jl22);
c.add(jb11);
c.add(jb22);
c.add(jb33);
c.add(jb44);
c.add(t11);
c.add(t22);
c.add(t33);
c.add(t44);
jb11.addActionListener(this);
jb22.addActionListener(this);
jb33.addActionListener(this);
jb44.addActionListener(this);
try {
jp=BankJdbc.tabel8();
c.add(jp);
jp.setBounds(30, 50, 400, 100);
} catch (SQLException e) {
e.printStackTrace();
}
}
else if(str.equals("数据统计")){
JLabel jl8=new JLabel("数据统计",JLabel.CENTER);
JLabel jlt=new JLabel("2017-9-9",JLabel.CENTER);//*******************时间放置
jlt.setFont(new Font("黑体",1,36));
jlt.setForeground(Color.red);
jlt.setBounds(60, 400, 400, 60);
Time time = new Time(jlt);
time.start();
jl8.setBounds(30, 30, 90, 30);
try {
jp=BankJdbc.tabel5();
} catch (SQLException e) {
e.printStackTrace();
}
c.add(jlt);
c.add(jp);
jp.setBounds(15, 40, 520, 168);
}
else if(str.equals("业务管理")){
JLabel jl9=new JLabel("业务管理",JLabel.CENTER);
JLabel jlt=new JLabel("2017-9-9",JLabel.CENTER);//*******************时间放置
jlt.setFont(new Font("黑体",1,36));
jlt.setForeground(Color.red);
Time time = new Time(jlt);
time.start();
jlt.setBounds(60, 400, 400, 60);
jl9.setBounds(30, 30, 90, 30);
try {
jp=BankJdbc.tabel6();
} catch (SQLException e) {
e.printStackTrace();
}
c.add(jlt);
c.add(jp);
jp.setBounds(30, 40, 520, 168);
}else if(str.equals("日志查询")){
JLabel jl8=new JLabel("日志查询",JLabel.CENTER);
JLabel jlt=new JLabel("2017-9-9",JLabel.CENTER);//*******************时间放置
Time time = new Time(jlt);
time.start();
jlt.setFont(new Font("黑体",1,36));
jlt.setForeground(Color.red);
jlt.setBounds(60, 400, 400, 60);
jl8.setBounds(30, 30, 90, 30);
try {
jp=BankJdbc.tabel4();
} catch (SQLException e) {
e.printStackTrace();
}
c.add(jlt);
c.add(jp);
jp.setBounds(15, 40, 520, 100);
}
jf.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
jf.setLocationRelativeTo(null);
jf.setVisible(true);
jf.addWindowListener(new WindowAdapter() {
@Override
public void windowClosing(WindowEvent e) {
new AdminUI();
}
});
}
public static void UI(String str){//刷新方法
jf.dispose();
new SubFrame(str);
}
@Override
public void actionPerformed(ActionEvent e) {
switch (e.getActionCommand()) {
case "主菜单":
jf.dispose();
new AdminUI();
break;
case "添 加":
if(t1.getText().equals("")||t2.getText().equals("")||t3.getText().equals("")||t4.getText().equals(""))
{JOptionPane.showMessageDialog(jf, "信息不能为空");
}else{
if(t4.getText().equals("vip业务")||t4.getText().equals("普通业务")||t4.getText().equals("对公业务")){
String sqls[]={"insert into db_login (jobnum,name,password,operation) values (?,?,?,?)"};
Object[][] pe={{t1.getText(),t2.getText(),t3.getText(),t4.getText()}};
if(JDBCTemplate.update(sqls, pe)){
JOptionPane.showMessageDialog(jf, "添加成功");
}else{
JOptionPane.showMessageDialog(jf, "添加失败，请核对核对信息");
}
}else{
JOptionPane.showMessageDialog(jf, "请输入正确的业务");
}
}
break;
case "添加":
if(t1.getText().equals("")||t2.getText().equals("")||t3.getText().equals("")||t4.getText().equals(""))
{JOptionPane.showMessageDialog(jf, "信息不能为空");
}else{
if(t4.getText().equals("vip业务")||t4.getText().equals("普通业务")||t4.getText().equals("对公业务")){
String sqls[]={"insert into db_login (jobnum,name,password,operation) values (?,?,?,?)"};
Object[][] pe={{t1.getText(),t2.getText(),t3.getText(),t4.getText()}};
if(JDBCTemplate.update(sqls, pe)){
JOptionPane.showMessageDialog(jf, "添加成功");
}else{
JOptionPane.showMessageDialog(jf, "添加失败，请核对核对信息");
}
}else{
JOptionPane.showMessageDialog(jf, "请输入正确的业务");
}
}
break;
case "删 除":
if(t1.getText().equals("")){
JOptionPane.showMessageDialog(jf, "请输入工号进行删除");
}else{
try {
if(BankJdbc.delete(t1.getText())){
jp=BankJdbc.tabel3();
c.add(jp);
jf.validate();
JOptionPane.showMessageDialog(jf, "删除成功");
}else{
JOptionPane.showMessageDialog(jf, "删除失败");
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
break;
case "删除":
if(t11.getText().equals("")){
JOptionPane.showMessageDialog(jf, "请输入工号进行删除");
}else{
try {
if(BankJdbc.delete(t11.getText())){
jp=BankJdbc.tabel3();
c.add(jp);
jf.validate();
JOptionPane.showMessageDialog(jf, "删除成功");
}else{
JOptionPane.showMessageDialog(jf, "删除失败");
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
break;
case "刷 新":
SubFrame.UI("用户管理");
break;
case "刷新":
SubFrame.UI("窗口办理");
break;
default:
break;
}
}
}
最近下载更多
最近浏览更多
