电信IP资费管理系统

电信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");

https://www.360docs.net/doc/fe2284096.html,st();

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

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[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("@123.");

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,wo rkplayce,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()));