📄 message.java
字号:
if("确定".equals(e.getActionCommand()));
{
if(temp==1)
{
String sq1="update orderform set customer='"+j12.getText()+"'," +
"product='"+j13.getText()+"',subscription='"+j14.getText()+"'," +
"amount='"+j15.getText()+"',bookday='"+j16.getText()+"'," +
"getday='"+j17.getText()+"',other='"+j18.getText()+"'" +
"where id='"+(row1()+1)+"'";
trange(sq1);
renew(sql1,dtb1);
}
if(temp==2)
{
String sq2="update reckoning set borrow='"+j22.getText()+"'," +
"returned='"+j23.getText()+"',pay='"+j24.getText()+"'," +
"get='"+j25.getText()+"',payoff='"+j26.getText()+"'," +
"day='"+j27.getText()+"',other='"+j28.getText()+"'" +
"where id='"+(row2()+1)+"'";
trange(sq2);
renew(sql2,dtb2);
}
if(temp==3)
{
String sq3="update message set PNum='"+j32.getText()+"'," +
"size='"+j33.getText()+"',amount='"+j34.getText()+"'," +
"price='"+j35.getText()+"',color='"+j36.getText()+"'," +
"other='"+j37.getText()+"'where id="+(row3()+1);
trange(sq3);
renew(sql3,dtb3);
}
if(temp==4)
{
String sq4="update staffmessage set name='"+j42.getText()+"'," +
"job='"+j43.getText()+"'," +
"wage='"+j44.getText()+"',worktime='"+j45.getText()+"'," +
"vacation='"+j46.getText()+"',begintime='"+j47.getText()+"'," +
"address='"+j48.getText()+"',birthday='"+j49.getText()+"'," +
"other='"+j40.getText()+"'where id='"+(row4()+1)+"'";
trange(sq4);
renew(sql4,dtb4);
}
if(temp==5)
{
String sq5="update duty set staff='"+j52.getText()+"'," +
"inorout='"+j53.getText()+"',behave='"+j54.getText()+"'," +
"day='"+j55.getText()+"',other='"+j56.getText()+"'" +
"where id='"+(row5()+1)+"'";
trange(sq5);
renew(sql5,dtb5);
}
setVisible(false);
}
if("取消".equals(e.getActionCommand()))
{
setVisible(false);
}
}
}
//该类为添加类
public class Add extends JFrame implements ActionListener
{
JTextField t12=new JTextField(10);
JTextField t13=new JTextField(10);
JTextField t14=new JTextField(10);
JTextField t15=new JTextField(10);
JTextField t16=new JTextField(10);
JTextField t17=new JTextField(10);
JTextField t18=new JTextField(10);
JTextField t22=new JTextField(10);
JTextField t23=new JTextField(10);
JTextField t24=new JTextField(10);
JTextField t25=new JTextField(10);
JTextField t26=new JTextField(10);
JTextField t27=new JTextField(10);
JTextField t28=new JTextField(10);
JTextField t32=new JTextField(10);
JTextField t33=new JTextField(10);
JTextField t34=new JTextField(10);
JTextField t35=new JTextField(10);
JTextField t36=new JTextField(10);
JTextField t37=new JTextField(10);
JTextField t42=new JTextField(10);
JTextField t43=new JTextField(10);
JTextField t44=new JTextField(10);
JTextField t45=new JTextField(10);
JTextField t46=new JTextField(10);
JTextField t47=new JTextField(10);
JTextField t48=new JTextField(10);
JTextField t49=new JTextField(10);
JTextField t40=new JTextField(10);
JTextField t52=new JTextField(10);
JTextField t53=new JTextField(10);
JTextField t54=new JTextField(10);
JTextField t55=new JTextField(10);
JTextField t56=new JTextField(10);
JButton B=new JButton("确定");
JButton B1=new JButton("取消");
public Add()
{
setSize(350,300);
setLocation(350,300);
if(temp==1)
{
set1();
}
if(temp==2)
{
set2();
}
if(temp==3)
{
set3();
}
if(temp==4)
{
set4();
}
if(temp==5)
{
set5();
}
B.addActionListener(this);
B1.addActionListener(this);
}
public void set1()
{
Container c=getContentPane();
JLabel l2=new JLabel("客 户");
JLabel l3=new JLabel("货 物");
JLabel l4=new JLabel("订 金");
JLabel l5=new JLabel("总 金 额");
JLabel l6=new JLabel("订 货 日");
JLabel l7=new JLabel("取 货 日");
JLabel l8=new JLabel("备 注");
c.setLayout(new GridLayout(8,2,5,5));
c.add(l2); c.add(t12);
c.add(l3); c.add(t13);
c.add(l4); c.add(t14);
c.add(l5); c.add(t15);
c.add(l6); c.add(t16);
c.add(l7); c.add(t17);
c.add(l8); c.add(t18);
c.add(B); c.add(B1);
}
public void set2()
{
Container c=getContentPane();
JLabel l2=new JLabel("贷 款");
JLabel l3=new JLabel("还 款");
JLabel l4=new JLabel("支 出");
JLabel l5=new JLabel("收 入");
JLabel l6=new JLabel("盈 利");
JLabel l7=new JLabel("日 期");
JLabel l8=new JLabel("备 注");
c.setLayout(new GridLayout(8,2,5,5));
c.add(l2); c.add(t22);
c.add(l3); c.add(t23);
c.add(l4); c.add(t24);
c.add(l5); c.add(t25);
c.add(l6); c.add(t26);
c.add(l7); c.add(t27);
c.add(l8); c.add(t28);
c.add(B); c.add(B1);
}
public void set3()
{
Container c=getContentPane();
JLabel l2=new JLabel("产 品 编 号");
JLabel l3=new JLabel("尺寸大小(码)");
JLabel l4=new JLabel("生产总数(双)");
JLabel l5=new JLabel("价 格 (元)");
JLabel l6=new JLabel("颜 色");
JLabel l7=new JLabel("备 注");
c.setLayout(new GridLayout(7,2,5,5));
c.add(l2); c.add(t32);
c.add(l3); c.add(t33);
c.add(l4); c.add(t34);
c.add(l5); c.add(t35);
c.add(l6); c.add(t36);
c.add(l7); c.add(t37);
c.add(B); c.add(B1);
}
public void set4()
{
Container c=getContentPane();
JLabel l2=new JLabel("姓 名");
JLabel l3=new JLabel("职 位");
JLabel l4=new JLabel("薪 金");
JLabel l5=new JLabel("上 班 时 间");
JLabel l6=new JLabel("假 期");
JLabel l7=new JLabel("入 厂 时 间");
JLabel l8=new JLabel("家 庭 住 址");
JLabel l9=new JLabel("出 生 年 月");
JLabel l0=new JLabel("备 注");
c.setLayout(new GridLayout(10,2,5,5));
c.add(l2); c.add(t42);
c.add(l3); c.add(t43);
c.add(l4); c.add(t44);
c.add(l5); c.add(t45);
c.add(l6); c.add(t46);
c.add(l7); c.add(t47);
c.add(l8); c.add(t48);
c.add(l9); c.add(t49);
c.add(l0); c.add(t40);
c.add(B); c.add(B1);
}
public void set5()
{
Container c=getContentPane();
JLabel l2=new JLabel("员 工");
JLabel l3=new JLabel("出 勤 情 况");
JLabel l4=new JLabel("员 工 表 现");
JLabel l5=new JLabel("日 期");
JLabel l6=new JLabel("备 注");
c.setLayout(new GridLayout(6,2,5,5));
c.add(l2); c.add(t52);
c.add(l3); c.add(t53);
c.add(l4); c.add(t54);
c.add(l5); c.add(t55);
c.add(l6); c.add(t56);
c.add(B); c.add(B1);
}
public String sq1()
{
i=max(sql1)+1;
String sq1="insert into orderform values('"+i+"','"+t12.getText()+"'," +
"'"+t13.getText()+"','"+t14.getText()+"','"+t15.getText()+"'," +
"'"+t16.getText()+"','"+t17.getText()+"','"+t18.getText()+"')";
return sq1;
}
public String sq2()
{
i=max(sql2)+1;
String sq2="insert into reckoning values('"+i+"','"+t22.getText()+"'," +
"'"+t23.getText()+"','"+t24.getText()+"','"+t25.getText()+"'," +
"'"+t26.getText()+"','"+t27.getText()+"','"+t28.getText()+"')";
return sq2;
}
public String sq3()
{
i=max(sql3)+1;
String sq3="insert into message values('"+i+"','"+t32.getText()+"'," +
"'"+t33.getText()+"','"+t34.getText()+"','"+t35.getText()+"'," +
"'"+t36.getText()+"','"+t37.getText()+"')";
return sq3;
}
public String sq4()
{
i=max(sql4)+1;
String sq4="insert into staffmessage values('"+i+"','"+t42.getText()+"'," +
"'"+t43.getText()+"','"+t44.getText()+"','"+t45.getText()+"'," +
"'"+t46.getText()+"','"+t47.getText()+"','"+t48.getText()+"'," +
"'"+t49.getText()+"','"+t40.getText()+"')";
return sq4;
}
public String sq5()
{
i=max(sql5)+1;
String sq5="insert into duty values('"+i+"','"+t52.getText()+"'," +
"'"+t53.getText()+"','"+t54.getText()+"','"+t55.getText()+"'," +
"'"+t56.getText()+"')";
return sq5;
}
public void add(String sql,String sq,DefaultTableModel dtb)
{
trange(sq);
renew(sql,dtb);
}
public void actionPerformed(ActionEvent e)
{
if("确定".equals(e.getActionCommand()))
{
if(temp==1)
{
add(sql1,sq1(),dtb1);
}
if(temp==2)
{
add(sql2,sq2(),dtb2);
}
if(temp==3)
{
add(sql3,sq3(),dtb3);
}
if(temp==4)
{
add(sql4,sq4(),dtb4);
//在加入员工资料的同时,加入以该员工姓名初始化帐号和密码
String sq4="insert into staff values('"+max(sql4)+"','"+t42.getText()+"','"+t42.getText()+"')";
trange(sq4);
}
if(temp==5)
{
add(sql5,sq5(),dtb5);
}
setVisible(false);
}
if("取消".equals(e.getActionCommand()))
{
setVisible(false);
}
}
}
//该类为查找类
public class Search extends JFrame implements ActionListener
{
JLabel jl=new JLabel("请输关键字,您将查找到所有的信息");
JTextField jt=new JTextField(10);
JButton jb=new JButton("查找");
public Search()
{
setLocation(150,100);
setSize(700,70);
Container ct=getContentPane();
ct.setLayout(new GridLayout(1,3));
ct.add(jl);
ct.add(jt);
ct.add(jb);
jb.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{
if("查找".equals(e.getActionCommand()))
{
if(temp==1)
{
String sq1="select * from orderform where " +
"customer='"+jt.getText()+"'or product='"+jt.getText()+"'" +
"or subscription='"+jt.getText()+"'or amount='"+jt.getText()+"'" +
"or bookday='"+jt.getText()+"'or getday='"+jt.getText()+"'" +
"or other='"+jt.getText()+"'";
renew(sq1,dtb1);
}
if(temp==2)
{
String sq2="select * from reckoning where " +
"borrow='"+jt.getText()+"'or returned='"+jt.getText()+"'" +
"or pay='"+jt.getText()+"'or get='"+jt.getText()+"'" +
"or payoff='"+jt.getText()+"'or day='"+jt.getText()+"'" +
"or other='"+jt.getText()+"'";
renew(sq2,dtb2);
}
if(temp==3)
{
String sq3="select * from message where PNum='"+jt.getText()+"'" +
"or size='"+jt.getText()+"'or amount='"+jt.getText()+"'" +
"or price='"+jt.getText()+"'or color='"+jt.getText()+"'" +
"or other='"+jt.getText()+"'";
renew(sq3,dtb3);
}
if(temp==4)
{
String sq4="select * from staffmessage where " +
"name='"+jt.getText()+"'or job='"+jt.getText()+"'or wage='"+jt.getText()+"'" +
"or worktime='"+jt.getText()+"'or vacation='"+jt.getText()+"'" +
"or begintime='"+jt.getText()+"'or address='"+jt.getText()+"'" +
"or birthday='"+jt.getText()+"'or other='"+jt.getText()+"'";
renew(sq4,dtb4);
}
if(temp==5)
{
String sq5="select * from duty where " +
"staff='"+jt.getText()+"'or inorout='"+jt.getText()+"'" +
"or behave='"+jt.getText()+"'or day='"+jt.getText()+"'" +
"or other='"+jt.getText()+"'";
renew(sq5,dtb5);
}
setVisible(false);
card1.next(jp0);
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -