button[i]=newJButton(s2[i]);
p3.add(button[i]);
button[i].addActionListener(this);
}
this.add(p1);
this.setVisible(true);
}
publicvoidactionPerformed(ActionEvente){
if(e.getActionCommand()=="修改"){
this.setVisible(false);
this.removeAll();
this.add(new管理员管理());
this.setVisible(true);
}
}
}
5开通账户
importjava.awt.*;
importjava.awt.event.*;
importjavax.swing.*;
importjava.sql.*;
publicclass开通账户extendsJPanelimplementsActionListener,ItemListener
{
privateJButton提交,重设;
privateJTextField账务账号,账务密码,重复密码,顾客名称,性别选项,顾客状态,电子邮箱,联系电话,公司,公司邮箱,邮政编码;
privateJRadioButton男,女,开通,暂停;
privateJComboBox付款方式,省份,职业;
privateStringst1,st2,st3;
public开通账户()
{
JPanelp1=newJPanel();
p1.setLayout(newBorderLayout());
JPanelp2=newJPanel();
p1.add(p2,"North");
JLabeltishi=newJLabel("请输入顾客信息,带*必要填写!
");
p2.add(tishi,JLabel.CENTER);
tishi.setFont(newFont("华文行楷",1,30));
tishi.setForeground(Color.RED);
JPanelp3=newJPanel();
p1.add(p3,"South");
提交=newJButton("提交");
p3.add(提交);
提交.addActionListener(this);
重设=newJButton("重设");
p3.add(重设);
重设.addActionListener(this);
JPanelp4=newJPanel(newGridLayout(15,3));
p1.add(p4,"Center");
p4.add(newJLabel("账务账号*"));
账务账号=newJTextField();
p4.add(账务账号);
p4.add(newJLabel("请输入顾客账务账号名称"));
p4.add(newJLabel("账务密码*"));
账务密码=newJTextField();
p4.add(账务密码);
p4.add(newJLabel("请输入顾客账务密码"));
p4.add(newJLabel("重复密码*"));
重复密码=newJTextField();
p4.add(重复密码);
p4.add(newJLabel("请重复以上密码"));
p4.add(newJLabel("顾客名称*"));
顾客名称=newJTextField();
p4.add(顾客名称);
p4.add(newJLabel("请输入顾客真实姓名"));
p4.add(newJLabel("性别选项"));
JPanelp5=newJPanel(newGridLayout(1,2));
p4.add(p5);
ButtonGroupbg1=newButtonGroup();
男=newJRadioButton("男",true);
bg1.add(男);
p5.add(男);
女=newJRadioButton("女");
bg1.add(女);
p5.add(女);
p4.add(newJLabel());
p4.add(newJLabel("付款方式*"));
Object[]fangshi={"钞票支付","银行转账","邮政汇款","其他"};
付款方式=newJComboBox(fangshi);
p4.add(付款方式);
付款方式.addItemListener(this);
p4.add(newJLabel());
p4.add(newJLabel("顾客状态*"));
JPanelp6=newJPanel(newGridLayout(1,2));
p4.add(p6);
ButtonGroupgp2=newButtonGroup();
开通=newJRadioButton("开通",true);
gp2.add(开通);
p6.add(开通);
暂停=newJRadioButton("暂停");
gp2.add(暂停);
p6.add(暂停);
p4.add(newJLabel());
p4.add(newJLabel("电子邮箱*"));
电子邮箱=newJTextField("@");
p4.add(电子邮箱);
p4.add(newJLabel("请输入对的电子邮箱信息"));
p4.add(newJLabel("省份"));
Object[]shengfen={"北京","上海","河南","吉林","黑龙江","天津"};
省份=newJComboBox(shengfen);
p4.add(省份);
省份.addItemListener(this);
p4.add(newJLabel());
p4.add(newJLabel("职业"));
Object[]zhiye={"软件工程师","部门经理","销售经理","业务经理"};
职业=newJComboBox(zhiye);
p4.add(职业);
职业.addItemListener(this);
p4.add(newJLabel());
p4.add(newJLabel("联系电话"));
联系电话=newJTextField();
p4.add(联系电话);
p4.add(newJLabel("请输入联系电话"));
p4.add(newJLabel("公司"));
公司=newJTextField();
p4.add(公司);
p4.add(newJLabel("请输入顾客所在单位信息"));
p4.add(newJLabel("公司邮箱"));
公司邮箱=newJTextField();
p4.add(公司邮箱);
p4.add(newJLabel("请输入顾客所在单位邮箱号码"));
p4.add(newJLabel("邮政编码"));
邮政编码=newJTextField();
p4.add(邮政编码);
p4.add(newJLabel("请输入顾客邮政编码"));
this.add(p1);
this.setVisible(true);
}
publicvoiditemStateChanged(ItemEventf)
{
if(付款方式.getSelectedIndex()==0)
st1="钞票支付";
if(付款方式.getSelectedIndex()==1)
st1="银行转账";
if(付款方式.getSelectedIndex()==2)
st1="邮政汇款";
if(付款方式.getSelectedIndex()==3)
st1="其他";
if(省份.getSelectedIndex()==0)
st2="北京";
if(省份.getSelectedIndex()==1)
st2="上海";
if(省份.getSelectedIndex()==2)
st2="河南";
if(省份.getSelectedIndex()==3)
st2="吉林";
if(省份.getSelectedIndex()==4)
st2="黑龙江";
if(省份.getSelectedIndex()==5)
st2="天津";
if(职业.getSelectedIndex()==0)
st3="软件工程师";
if(职业.getSelectedIndex()==1)
st3="部门经理";
if(职业.getSelectedIndex()==2)
st3="销售经理";
if(职业.getSelectedIndex()==3)
st3="业务经理";
}
publicvoidactionPerformed(ActionEvente)
{
if(e.getSource()==提交)//;
{
if(账务密码.getText().equals(重复密码.getText()))
{
try
{
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
}
catch(ClassNotFoundExceptiong)
{
System.out.println("SQLException:
"+g.getLocalizedMessage());
}
Stringxb="";
if(男.isSelected())
xb="男";
if(女.isSelected())
xb="女";
Stringzt="";
if(开通.isSelected())
zt="开通";
if(暂停.isSelected())
zt="暂停";
try
{
Connectioncon;
Statementstmt;
ResultSetrs;
con=DriverManager.getConnection("jdbc:
odbc:
电信IP资费管理系统");
stmt=con.createStatement();
//rs=stmt.executeQuery("select*fromuser");
Stringsql="INSERTINTOconsumer(id,sex,password,name,telephone,province,methord,state,mail,work,workplayce,mail2,post)Values("+"'"+账务账号.getText()+"'"+","+"'"+xb+"'"+","+"'"+账务密码.getText()+"'"+","+""+"'"+顾客名称.getText()+"'"+","+"'"+联系电话.getText()+"'"+","+"'"+st2+"'"+","+"'"+st1+"'"+","+"'"+zt+"'"+","+"'"+电子邮箱.getText()+"'"+","+""+""+"'"+st3+"'"+","+"'"+公司.getText()+"'"+","+"'"+公司邮箱.getText()+"'"+","+"'"+邮政编码.getText()+"'"+")";
stmt.executeUpdate(sql);
stmt.close();
con.close();
this.setVisible(false);
this.removeAll();
this.add(new顾客列表());
this.setVisible(true);
}
catch(SQLExceptionex)
{
ex.printStackTrace();
}
}
if(!
(账务密码.getText().equals(重复密码.getTreeLock())))
{
JOptionPane.showMessageDialog(this,"您输入重复密码不对的,请重新输入!
","系统提示",JOptionPane.ERROR_MESSAGE);
}
}
if(e.getSource()==重设)
{
账务账号.setText("");
账务密码.setText("");
重复密码.setText("");
顾客名称.setText("");
电子邮箱.setText("");
联系电话.setText("");
公司.setText("");
公司邮箱.setText("");
邮政编码.setText("");
}
}
}
6明细
importjava.awt.*;
importjava.awt.event.*;
importjavax.swing.*;
publicclass明细extendsJPanelimplementsActionListener{
privateJTablejt1,jt2,jt3,jt4,jt5;
public明细(){
JPanelp1=newJPanel(newBorderLayout());
JPanelp2=newJPanel();
p1.add(p2,"North");
Objectob1[][]=newObject[2][4];
Stringst1[]={"帐务帐号","记录日期","总计(单位:
小时)","总费用(元)"};
jt1=newJTable(ob1,st1);
jt1.setSize(500,50);
JScrollPanejsp1=newJScrollPane(jt1);
jsp1.setPreferredSize(newDimension(jt1.getWidth(),jt1.getHeight()));
p2.add(jsp1);
Objectob3[][]=newObject[2][4];
Stringst3[]={"帐务帐号","记录日期","总计(单位:
小时)","总费用(元)"};
jt3=newJTable(ob3,st3);
jt3.setSize(500,50);
JScrollPanejsp3=newJScrollPane(jt3);
jsp3.setPreferredSize(newDimension(jt3.getWidth(),jt3.getHeight()));
JPanelp3=newJPanel(newBorderLayout());
p1.add(p3,"Center");
p3.add(newJLabel("详细信息如下:
",JLabel.CENTER),"North");
JPanelp4=newJPanel(newGridLayout(2,1,50,0));
p3.add(p4,"Center");
Objectob2[][]=newObject[9][3];
Stringst2[]={"登陆时间","退出时间","时长(单位:
小时)"};
jt2=newJTable(ob2,st2);
jt2.setSize(500,150);
JScrollPanejsp2=newJScrollPane(jt2);
jsp2.setPreferredSize(newDimension(jt2.getWidth(),jt2.getHeight()));
JPanelp5=newJPanel(newBorderLayout());
p5.add(jsp3,"North");
p5.add(jsp2,"Center");
p4.add(p5);
Objectob4[][]=newObject[2][4];
Stringst4[]={"帐务帐号","记录日期","总计(单位:
小时)","总费用(元)"};
jt4=newJTable(ob4,st4);
jt4.setSize(500,50);
JScrollPanejsp4=newJScrollPane(jt4);
jsp4.setPreferredSize(newDimension(jt4.getWidth(),jt4.getHeight()));
Objectob5[][]=newObject[9][3];
Stringst5[]={"登陆时间","退出时间","时长(单位:
小时)"};
jt5=newJTable(ob5,st5);
jt5.setSize(500,150);
JScrollPanejsp5=newJScrollPane(jt5);
jsp5.setPreferredSize(newDimension(jt5.getWidth(),jt5.getHeight()));
JPanelp6=newJPanel(newBorderLayout());
p4.add(p6);
p6.add(jsp4,"North");
p6.add(jsp5,"Center");