电信资费标准管理系统.doc

电信IP资费管理系统代码
重庆文理学院java课
4管理员列表

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class 管理员列表 extends JPanel implements ActionListener{
private JButton button[]=new JButton[3];
private JTable table1;
public 管理员列表(){
JPanel p1=new JPanel(new BorderLayout());
p1.add(new JLabel("管理员列表",JLabel.CENTER),"North");

Connection con;
ResultSet rs;
Statement sql;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException ex){
System.out.println("error:"+ex);
}
try{
con=DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");
sql=con.createStatement(1005,1007);
rs=sql.executeQuery("select * from user");
rs.last();
int k=rs.getRow();
if(k==0){
JOptionPane.showMessageDialog(this,"您查询表为空表！","系统提示",JOptionPane.WARNING_MESSAGE);
}
rs.beforeFirst();
Object obj[][]=new Object[k][6];
for(int i=0;i<k&&rs.next();i++){
obj[i][0]=rs.getString("id");
obj[i][1]=rs.getString("name");
obj[i][2]=rs.getString("telephone");
obj[i][3]=rs.getString("email");
obj[i][4]=rs.getString("date");
obj[i][5]=rs.getString("authority");
}
JPanel p2=new JPanel();
String s1[]={"帐号","姓名","电话","邮箱","开户日期","权限"};
table1=new JTable(obj,s1);
table1.setSize(500,500);
JScrollPane jsp1=new JScrollPane(table1);
jsp1.setPreferredSize(new Dimension(table1.getWidth(),table1.getHeight()));
p2.add(jsp1);
p1.add(p2,"Center");
con.close();
}
catch(SQLException se){
System.out.println("SQLEception"+se.getMessage());
}
JPanel p3=new JPanel(new FlowLayout());
p1.add(p3,"South");
String s2[]={"删除","修改","清除"};
for(int i=0;i<button.length;i++){
button[i]=new JButton(s2[i]);
p3.add(button[i]);
button[i].addActionListener(this);
}
this.add(p1);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e){
if(e.getActionCommand()=="修改"){
this.setVisible(false);
this.removeAll();
this.add(new 管理员管理());
this.setVisible(true);
}
}

}

5开通账户

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class 开通账户 extends JPanel implements ActionListener，ItemListener
{
private JButton 提交，重设;
private JTextField 账务账号，账务密码，重复密码，顾客名称，性别选项，顾客状态，电子邮箱，联系电话，公司，公司邮箱，邮政编码;
private JRadioButton 男，女，开通，暂停;
private JComboBox 付款方式，省份，职业;
private String st1，st2，st3;
public 开通账户()
{
JPanel p1 = new JPanel();
p1.setLayout(new BorderLayout());
JPanel p2 = new JPanel();
p1.add(p2，"North");

JLabel tishi = new JLabel("请输入顾客信息，带*必要填写！");
p2.add(tishi，JLabel.CENTER);
tishi.setFont(new Font("华文行楷"，1，30));
tishi.setForeground(Color.RED);
JPanel p3 = new JPanel();
p1.add(p3，"South");

提交 = new JButton("提交");
p3.add(提交);
提交.addActionListener(this);
重设 = new JButton("重设");
p3.add(重设);
重设.addActionListener(this);

JPanel p4 = new JPanel(new GridLayout(15，3));
p1.add(p4，"Center");
p4.add(new JLabel("账务账号*"));
账务账号 = new JTextField();
p4.add(账务账号);
p4.add(new JLabel("请输入顾客账务账号名称"));
p4.add(new JLabel("账务密码*"));
账务密码 = new JTextField();
p4.add(账务密码);
p4.add(new JLabel("请输入顾客账务密码"));

p4.add(new JLabel("重复密码*"));
重复密码 = new JTextField();
p4.add(重复密码);
p4.add(new JLabel("请重复以上密码"));

p4.add(new JLabel("顾客名称*"));
顾客名称 = new JTextField();
p4.add(顾客名称);
p4.add(new JLabel("请输入顾客真实姓名"));

p4.add(new JLabel("性别选项"));
JPanel p5 = new JPanel(new GridLayout(1，2));
p4.add(p5);
ButtonGroup bg1 = new ButtonGroup();
男 = new JRadioButton("男"，true);
bg1.add(男);
p5.add(男);

女 = new JRadioButton("女");
bg1.add(女);
p5.add(女);

p4.add(new JLabel());
p4.add(new JLabel("付款方式*"));
Object[] fangshi = {"钞票支付"，"银行转账"，"邮政汇款"，"其他"};
付款方式 = new JComboBox(fangshi);
p4.add(付款方式);
付款方式.addItemListener(this);
p4.add(new JLabel());

p4.add(new JLabel("顾客状态*"));
JPanel p6 = new JPanel(new GridLayout(1，2));
p4.add(p6);
ButtonGroup gp2 = new ButtonGroup();
开通 = new JRadioButton("开通"，true);
gp2.add(开通);
p6.add(开通);

暂停 = new JRadioButton("暂停");
gp2.add(暂停);
p6.add(暂停);
p4.add(new JLabel());

p4.add(new JLabel("电子邮箱*"));
电子邮箱 = new JTextField("@");
p4.add(电子邮箱);
p4.add(new JLabel("请输入对的电子邮箱信息"));

p4.add(new JLabel("省份"));
Object[] shengfen = {"北京"，"上海"，"河南"，"吉林"，"黑龙江"，"天津"};
省份 = new JComboBox(shengfen);
p4.add(省份);
省份.addItemListener(this);
p4.add(new JLabel());

p4.add(new JLabel("职业"));
Object[] zhiye = {"软件工程师"，"部门经理"，"销售经理"，"业务经理"};
职业 = new JComboBox(zhiye);
p4.add(职业);
职业.addItemListener(this);
p4.add(new JLabel());

p4.add(new JLabel("联系电话"));
联系电话 = new JTextField();
p4.add(联系电话);
p4.add(new JLabel("请输入联系电话"));

p4.add(new JLabel("公司"));
公司 = new JTextField();
p4.add(公司);
p4.add(new JLabel("请输入顾客所在单位信息"));

p4.add(new JLabel("公司邮箱"));
公司邮箱 = new JTextField();
p4.add(公司邮箱);
p4.add(new JLabel("请输入顾客所在单位邮箱号码"));

p4.add(new JLabel("邮政编码"));
邮政编码 = new JTextField();
p4.add(邮政编码);
p4.add(new JLabel("请输入顾客邮政编码"));

this.add(p1);
this.setVisible(true);
}
public void itemStateChanged(ItemEvent f)
{
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 = "业务经理";
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource() == 提交)//;
{
if(账务密码.getText().equals(重复密码.getText()))
{
try
{
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
}
catch(ClassNotFoundException g)
{
System.out.println("SQLException:" + g.getLocalizedMessage());
}
String xb = "";
if(男.isSelected())
xb = "男";
if(女.isSelected())
xb = "女";
String zt = "";
if(开通.isSelected())
zt = "开通";
if(暂停.isSelected())
zt = "暂停";

try
{
Connection con;
Statement stmt;
ResultSet rs;

con = DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");
stmt = con.createStatement();
//rs = stmt.executeQuery("select * from user");
String sql = "INSERT INTO consumer(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(SQLException ex)
{
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明细

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
public class 明细 extends JPanel implements ActionListener {
private JTable jt1,jt2,jt3,jt4,jt5;
public 明细(){
JPanel p1=new JPanel(new BorderLayout());
JPanel p2=new JPanel();
p1.add(p2,"North");

Object ob1[][]=new Object[2][4];
String st1[]={"帐务帐号","记录日期","总计(单位:小时)","总费用(元)"};
jt1=new JTable(ob1,st1);
jt1.setSize(500,50);
JScrollPane jsp1=new JScrollPane(jt1);
jsp1.setPreferredSize(new Dimension(jt1.getWidth(),jt1.getHeight()));
p2.add(jsp1);

Object ob3[][]=new Object[2][4];
String st3[]={"帐务帐号","记录日期","总计(单位:小时)","总费用(元)"};
jt3=new JTable(ob3,st3);
jt3.setSize(500,50);
JScrollPane jsp3=new JScrollPane(jt3);
jsp3.setPreferredSize(new Dimension(jt3.getWidth(),jt3.getHeight()));

JPanel p3=new JPanel(new BorderLayout());
p1.add(p3,"Center");
p3.add(new JLabel("详细信息如下:",JLabel.CENTER),"North");
JPanel p4=new JPanel(new GridLayout(2,1,50,0));
p3.add(p4,"Center");

Object ob2[][]=new Object[9][3];
String st2[]={"登陆时间","退出时间","时长(单位:小时)"};
jt2=new JTable(ob2,st2);
jt2.setSize(500,150);
JScrollPane jsp2=new JScrollPane(jt2);
jsp2.setPreferredSize(new Dimension(jt2.getWidth(),jt2.getHeight()));

JPanel p5=new JPanel(new BorderLayout());
p5.add(jsp3,"North");
p5.add(jsp2,"Center");
p4.add(p5);

Object ob4[][]=new Object[2][4];
String st4[]={"帐务帐号","记录日期","总计(单位:小时)","总费用(元)"};
jt4=new JTable(ob4,st4);
jt4.setSize(500,50);
JScrollPane jsp4=new JScrollPane(jt4);
jsp4.setPreferredSize(new Dimension(jt4.getWidth(),jt4.getHeight()));

Object ob5[][]=new Object[9][3];
String st5[]={"登陆时间","退出时间","时长(单位:小时)"};
jt5=new JTable(ob5,st5);
jt5.setSize(500,150);
JScrollPane jsp5=new JScrollPane(jt5);
jsp5.setPreferredSize(new Dimension(jt5.getWidth(),jt5.getHeight()));

JPanel p6=new JPanel(new BorderLayout());
p4.add(p6);
p6.add(jsp4,"North");
p6.add(jsp5,"Center");
this.add(p1);
this.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{}
}

7年账务查询
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class 年账务查询 extends JPanel implements ActionListener,ItemListener
{
private JComboBox 年;
private JButton button;
private JTable zhangwu;
private JTextArea ta;
private String aline;
private JPanel p4;
public 年账务查询()
{
JPanel p3=new JPanel(new BorderLayout());
p4=new JPanel();
Connection con;
ResultSet rs;
Statement sql;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex)
{
System.out.println("error:"+ex);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");
sql=con.createStatement(1005,1007);
rs=sql.executeQuery("select * from serve");
rs.last();
int k=rs.getRow();
if(k==0)
{
JOptionPane.showMessageDialog(this,"您查询表为空表!",
"系统提示",JOptionPane.WARNING_MESSAGE);
}
rs.beforeFirst();
Object obj[][]=new Object[k][2];
for(int i=0;i<k&&rs.next();i++)
{
obj[i][0]=rs.getString("serve");
obj[i][1]=rs.getString("all");
}
String s1[]={"服务器","总计(单位:小时)"};
zhangwu=new JTable(obj,s1);
zhangwu.setSize(500,500);
JScrollPane jsp1=new JScrollPane(zhangwu);
jsp1.setPreferredSize(new Dimension(zhangwu.getWidth(),zhangwu.getHeight ()));
p4.add(jsp1);
p3.add(p4,"Center");
con.close();
}
catch(Exception el)
{
System.out.println(el+"error:");
}
JPanel p1=new JPanel(new GridLayout(1,15,20,0));
Object obj1[]={"","","",""};
年=new JComboBox(obj1);
年.addItemListener(this);
p1.add(年);
p1.add(new JLabel("年"));
button=new JButton("年账务查询");
button.addActionListener(this);
p1.add(button);
p3.add(p1,"North");

JPanel p2=new JPanel();
p3.add(p2,"South");
ta=new JTextArea();

p2.add(ta);
this.add(p3);
this.setVisible(true);
}
public void itemStateChanged(ItemEvent f)
{
for(int i=0;i<4;i++)
{
if(年.getSelectedIndex()==i)
aline="查询日期:"++i+"";
}
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==button)
{
ta.append(aline);
Connection con;
ResultSet rs;
Statement sql;
int message=0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex)
{
System.out.println("error:"+ex);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");
sql=con.createStatement(1005,1007);
rs=sql.executeQuery("select * from serve");
while(rs.next())
{
String st1=rs.getString("date");
System.out.println(st1);
if(年.getSelectedItem().equals(st1))
{
System.out.println(aline);
message=1