📄 moneymanager.java
字号:
p2.add(inputb1);
p2.add(inputb2);
p2.add(inputb3);
p2.setBorder(BorderFactory.createTitledBorder(""));
p2.setBackground(Color.DARK_GRAY);
inputf.setLayout(new BorderLayout());
inputf.setSize(280,280);
inputf.setLocation(400,200);
inputf.add(p1,BorderLayout.CENTER);
inputf.add(p2,BorderLayout.SOUTH);
inputf.setVisible(true);
}
void select()
{
selectf=new JFrame("查询");
JLabel selectl1=new JLabel("日期");
JLabel selectl2=new JLabel("至");
selectt1=new JTextField(20);
selectt2=new JTextField(20);
selectb1=new JButton("查询");selectb1.addActionListener(this);
selectb2=new JButton("取消");selectb2.addActionListener(this);
cc=new CheckboxGroup();
cc1=new Checkbox("收入",true,cc);
cc2=new Checkbox("支出",false,cc);
cch1=new Choice();
cch1.insert("全部",1);
cch1.insert("工资",2);
cch1.insert("奖金",3);
cch1.insert("礼金",4);
cch1.insert("亲属赠金",5);
cch1.insert("经营所得",6);
cch1.insert("租赁收入",7);
cch1.insert("利息收入",8);
cch1.insert("倒卖物品",9);
cch1.insert("中奖奖金",10);
cch1.insert("债务收入",11);
cch1.insert("补助津贴",12);
cch2=new Choice();
cch2.insert("全部",1);
cch2.insert("交通费",2);
cch2.insert("教育费",3);
cch2.insert("生活费",4);
cch2.insert("通信费",5);
cch2.insert("休闲娱乐",6);
cch2.insert("医疗保健",7);
cch2.insert("慈善送礼",8);
cch2.insert("债务",9);
cch2.insert("维修保养",10);
JPanel p1=new JPanel();
JLabel selectl4=new JLabel("(请选择)");
JLabel selectl5=new JLabel("(请选择)");
selectl1.setBounds(new Rectangle(20,15,40,19));
selectl1.setFont(new java.awt.Font("Dialog",0,13));
selectt1.setBounds(new Rectangle(60,15,70,19));
selectl2.setBounds(new Rectangle(130,15,20,19));
selectl2.setFont(new java.awt.Font("Dialog",0,13));
selectt2.setBounds(new Rectangle(150,15,70,19));
JLabel l1=new JLabel("(20070101)");
JLabel l2=new JLabel("(20070304)");
l1.setBounds(new Rectangle(60,35,70,19));
l1.setFont(new java.awt.Font("Dialog",0,13));
l2.setBounds(new Rectangle(150,35,70,19));
l2.setFont(new java.awt.Font("Dialog",0,13));
cc1.setBounds(new Rectangle(20,60,40,19));
cc1.setFont(new java.awt.Font("Dialog",0,13));
cch1.setBounds(new Rectangle(65,60,120,19));
selectl4.setBounds(new Rectangle(185,60,50,19));
selectl4.setFont(new java.awt.Font("Dialog",0,13));
cc2.setBounds(new Rectangle(20,85,40,19));
cc2.setFont(new java.awt.Font("Dialog",0,13));
cch2.setBounds(new Rectangle(65,85,120,19));
selectl5.setBounds(new Rectangle(185,85,50,19));
selectl5.setFont(new java.awt.Font("Dialog",0,13));
selectb1.setBounds(new Rectangle(50,120,60,19));
selectb1.setFont(new java.awt.Font("Dialog",0,13));
selectb2.setBounds(new Rectangle(140,120,60,19));
selectb2.setFont(new java.awt.Font("Dialog",0,13));
selectf.setLayout(null);
selectf.add(selectl1);selectf.add(selectt1);selectf.add(selectl2);selectf.add(selectt2);
selectf.add(l1);selectf.add(l2);
selectf.add(cc1);selectf.add(cch1);selectf.add(selectl4);
selectf.add(cc2);selectf.add(cch2);selectf.add(selectl5);
selectf.add(selectb1);
selectf.add(selectb2);
selectf.setSize(270,200);
selectf.setLocation(300,300);
selectf.setVisible(true);
}
void myTable()
{
tablef=new JFrame();
n=new Object[100][6];
String[] m={"序号","金额","日期","分类","说明","收支"};
tableb1=new JButton("OK");tableb1.addActionListener(this);
table=new JTable(n,m);
table.setShowHorizontalLines(false);
table.setShowVerticalLines(false);
table.setEnabled(false);
s=new JScrollPane(table);
tablef.setSize(600,500);
tablef.setLayout(new BorderLayout());
tablef.add(s,BorderLayout.CENTER);
tablef.add(tableb1,BorderLayout.SOUTH);
tablef.setLocation(400,200);
new SQL(this).chaxun();
tablef.setVisible(true);
}
void deleteDialog()
{
deleteDialog=new JDialog(zbManagerf,"删除帐簿密码验证",true);
YnameLabel=new JLabel("账簿名");
YnameLabel.setFont(new java.awt.Font("Dialog",0,13));
YnameLabel.setBounds(new Rectangle(50,30,79,19));
YpasswordLabel=new JLabel("密码");
YpasswordLabel.setFont(new java.awt.Font("Dialog",0,13));
YpasswordLabel.setBounds(new Rectangle(50,60,79,19));
YnameText=new JTextField(6);
YnameText.setText(ZbName);
YnameText.setBounds(new Rectangle(100,30,90,19));
YpasswordText=new JPasswordField(6);
YpasswordText.setBounds(new Rectangle(100,60,90,19));
Ybutton1=new JButton("确定");Ybutton1.addActionListener(this);
Ybutton1.setFont(new java.awt.Font("Dialig",0,13));
Ybutton1.setBounds(new Rectangle(40,110,65,19));
Ybutton2=new JButton("取消");Ybutton2.addActionListener(this);
Ybutton2.setFont(new java.awt.Font("Dialog",0,13));
Ybutton2.setBounds(new Rectangle(130,110,65,19));
deleteDialog.setSize(250,180);
deleteDialog.setLocation(200,200);
deleteDialog.setLayout(null);
deleteDialog.add(YnameLabel);
deleteDialog.add(YnameText);
deleteDialog.add(YpasswordLabel);
deleteDialog.add(YpasswordText);
deleteDialog.add(Ybutton1);
deleteDialog.add(Ybutton2);
deleteDialog.setLocation(400,200);
deleteDialog.show(true);
}
void nameDialog()
{
nameDialog=new JDialog(frame,"修改帐簿名",true);
JLabel nameDialogLabel=new JLabel("新帐簿名");
nameDialogText=new JTextField(20);
nameDialogButton1=new JButton("修改");nameDialogButton1.addActionListener(this);
nameDialogButton2=new JButton("取消");nameDialogButton2.addActionListener(this);
nameDialogLabel.setBounds(new Rectangle(50,30,80,30));
nameDialogLabel.setFont(new java.awt.Font("Dialog",0,13));
nameDialogText.setBounds(new Rectangle(110,30,80,30));
nameDialogText.setFont(new java.awt.Font("Dialog",0,13));
nameDialogButton1.setBounds(new Rectangle(60,80,60,20));
nameDialogButton1.setFont(new java.awt.Font("Dialog",0,13));
nameDialogButton2.setBounds(new Rectangle(130,80,60,20));
nameDialogButton2.setFont(new java.awt.Font("Dialog",0,13));
nameDialog.setLayout(null);
nameDialog.add(nameDialogLabel);
nameDialog.add(nameDialogText);
nameDialog.add(nameDialogButton1);
nameDialog.add(nameDialogButton2);
nameDialog.setSize(250,150);
nameDialog.setLocation(400,200);
nameDialog.show();
}
void passwordDialog()
{
passwordDialog=new JDialog(frame,"修改密码",true);
JLabel pDialogLabel1=new JLabel("旧密码");
JLabel pDialogLabel2=new JLabel("新密码");
pDialogText1=new JTextField(20);
pDialogText2=new JTextField(20);
pDialogButton1=new JButton("修改");pDialogButton1.addActionListener(this);
pDialogButton2=new JButton("取消");pDialogButton2.addActionListener(this);
pDialogLabel1.setBounds(new Rectangle(50,30,80,20));
pDialogLabel1.setFont(new java.awt.Font("Dialog",0,13));
pDialogLabel2.setBounds(new Rectangle(50,60,80,20));
pDialogLabel2.setFont(new java.awt.Font("Dialog",0,13));
pDialogText1.setBounds(new Rectangle(140,30,80,20));
pDialogText1.setFont(new java.awt.Font("Dialog",0,13));
pDialogText2.setBounds(new Rectangle(140,60,80,20));
pDialogText2.setFont(new java.awt.Font("Dialog",0,13));
pDialogButton1.setBounds(new Rectangle(60,100,60,20));
pDialogButton1.setFont(new java.awt.Font("Dialog",0,13));
pDialogButton2.setBounds(new Rectangle(130,100,60,20));
pDialogButton2.setFont(new java.awt.Font("Dialog",0,13));
passwordDialog.setLayout(null);
passwordDialog.add(pDialogLabel1);
passwordDialog.add(pDialogLabel2);
passwordDialog.add(pDialogText1);
passwordDialog.add(pDialogText2);
passwordDialog.add(pDialogButton1);
passwordDialog.add(pDialogButton2);
passwordDialog.setSize(250,200);
passwordDialog.setLocation(400,200);
passwordDialog.show();
}
void xiangxixinxi()
{
xf=new JFrame();
JLabel xl1=new JLabel("账簿名");
JLabel xl2=new JLabel("建账者");
JLabel xl3=new JLabel("建账日期");
xl4=new JLabel();
xl5=new JLabel();
xl6=new JLabel();
xb1=new JButton("确定");xb1.addActionListener(this);
xl1.setBounds(new Rectangle(50,30,80,20));
xl1.setFont(new java.awt.Font("Dialog",0,13));
xl2.setBounds(new Rectangle(50,60,80,20));
xl2.setFont(new java.awt.Font("Dialog",0,13));
xl3.setBounds(new Rectangle(50,90,80,20));
xl3.setFont(new java.awt.Font("Dialog",0,13));
xl4.setBounds(new Rectangle(140,30,80,20));
xl4.setFont(new java.awt.Font("Dialog",0,13));
xl5.setBounds(new Rectangle(140,60,80,20));
xl5.setFont(new java.awt.Font("Dialog",0,13));
xl6.setBounds(new Rectangle(140,90,80,20));
xl6.setFont(new java.awt.Font("Dialog",0,13));
xb1.setBounds(new Rectangle(90,150,60,20));
xb1.setFont(new java.awt.Font("Dialog",0,13));
xf.add(xl1);xf.add(xl4);
xf.add(xl2);xf.add(xl5);
xf.add(xl3);xf.add(xl6);
xf.add(xb1);
new SQL(this).selectZb();
xf.setLayout(null);
xf.setSize(250,250);
xf.setLocation(400,200);
xf.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==inputb1)
{
new jisuanqi();
}
if(e.getSource()==xb1)
{
xf.setVisible(false);
}
if(e.getSource()==b1)//打开帐簿验证窗口
{
if(jList.getSelectedIndex()==-1)
{
JOptionPane.showMessageDialog(null,"请选择帐簿");
return;
}
ZbName=(String)listData.get(jList.getSelectedIndex());//获取list中选择行的内容
loginDialog();
}
if(e.getSource()==b2)//新建帐簿
{
NewZHangbu();
}
if(e.getSource()==b3)//删除帐簿
{
if(jList.getSelectedIndex()==-1)
{
JOptionPane.showMessageDialog(null,"请选择帐簿");
return;
}
ZbName=(String)listData.get(jList.getSelectedIndex());//获取list中选择行的内容
deleteDialog();
}
if(e.getSource()==b4)//详细信息
{
if(jList.getSelectedIndex()==-1)
{
JOptionPane.showMessageDialog(null,"请选择帐簿");
return;
}
ZbName=(String)listData.get(jList.getSelectedIndex());//获取list中选择行的内容
xiangxixinxi();
}
if(e.getSource()==b5)//刷新
{
new SQL(this).selectZbName();
}
if(e.getSource()==b6)//退出
{
System.exit(0);
}
if(e.getSource()==Tijiao)//新建帐簿窗口中的提交按钮
{
new SQL(this).addZb();
new SQL(this).selectZbName();
f.setVisible(false);
}
if(e.getSource()==Quxiao)//新建窗口中的取消按钮
{
f.setVisible(false);
}
if(e.getSource()==loginBtu)//验证窗口中的打开按钮
{
/*String s1=passwordText.getText();
if(s1==null)
{
JOptionPane.showMessageDialog(null,"请输入密码");
return;
}*/
new SQL(this).checkUser();
System.out.println(j);
if(j!=0)
{
JOptionPane.showMessageDialog(null,"密码错误");
return;
}
if(j==0)
{
frame();
loginDialog.dispose();
}
}
if(e.getSource()==exitBtu)//验证窗口中的返回按钮
{
loginDialog.dispose();
}
if(e.getSource()==MenuItem1)
{
System.out.println(ZbName);
input();
}
if(e.getSource()==MenuItem2)
{
select();
}
if(e.getSource()==MenuItem4)
{
frame.setVisible(false);
}
if(e.getSource()==MenuItem5)//重命名
{
nameDialog();
}
if(e.getSource()==MenuItem6)//修改密码
{
passwordDialog();
}
if(e.getSource()==loginBtu)
{
}
if(e.getSource()==selectb1)//确定查询按钮
{
myTable();
}
if(e.getSource()==selectb2)//取消查询按钮
{
selectf.setVisible(false);
}
if(e.getSource()==inputb2)//确定入账按钮
{
new SQL(this).ruzhang();
new SQL(this).tongji();
inputf.setVisible(false);
}
if(e.getSource()==inputb3)//取消入账按钮
{
inputf.setVisible(false);
}
if(e.getSource()==tableb1)//关闭查询数据table窗口
{
tablef.setVisible(false);
}
if(e.getSource()==Ybutton1)//验证删除账簿密码确定按钮
{
new SQL(this).deleteCheck();
if(k<0)
{
JOptionPane.showMessageDialog(null,"密码错误");
return;
}
if(k==0)
{
new SQL(this).delete();
deleteDialog.dispose();
}
}
if(e.getSource()==Ybutton2)//验证删除账簿密码取消按钮
{
deleteDialog.dispose();
}
if(e.getSource()==nameDialogButton1)//修改账簿名窗口中的修改按钮
{
new SQL(this).upDataZbName();
ZbName=nameDialogText.getText();
new SQL(this).selectZbName();
System.out.println(ZbName);
nameDialog.dispose();
}
if(e.getSource()==nameDialogButton2)//修改账簿名窗口中的取消按钮
{
nameDialog.dispose();
}
if(e.getSource()==pDialogButton1)//修改密码窗口中的修改按钮
{
new SQL(this).upDataZbPassword();
passwordDialog.dispose();
}
if(e.getSource()==pDialogButton2)//修改密码窗口中的取消按钮
{
passwordDialog.dispose();
}
}
}
public class MoneyManager
{
public static void main(String args[])
{
SQL n=new SQL();
n.lianjie();
new MainWindow().ManagerWindow();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -