电信资费基础管理系统

1、电信IP资费管理系统代码重庆文理学院java课4管理员列表import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class 管理员列表 extends JPanel implements ActionListenerprivate JButton button=new JButton3;private JTable table1;public 管理员列表()JPanel p1=new JPanel(new BorderLayout();p1.add(new JLabel(管

2、理员列表,JLabel.CENTER),North);Connection con;ResultSet rs;Statement sql;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch (ClassNotFoundException ex)System.out.println(error:+ex);trycon=DriverManager.getConnection(jdbc:odbc:电信IP资费管理系统);sql=con.createStatement(1005,1007); rs=sql.executeQuery(select *

3、 from user); rs.last(); int k=rs.getRow(); if(k=0) JOptionPane.showMessageDialog(this,您查询旳表为空表！,系统提示,JOptionPane.WARNING_MESSAGE); rs.beforeFirst(); Object obj=new Objectk6; for(int i=0;ik&rs.next();i+) obji0=rs.getString(id); obji1=rs.getString(name); obji2=rs.getString(telephone); obji3=rs.getStri

4、ng(email); obji4=rs.getString(date); obji5=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(js

5、p1); 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;ibutton.length;i+)buttoni=new JButton(s2i);p3.add(buttoni);buttoni.addActionListener(this);this.add(p1);this.

6、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 A

7、ctionListener, ItemListenerprivate JButton 提交, 重设;private JTextField 账务账号, 账务密码, 反复密码, 顾客名称, 性别选项, 顾客状态, 电子邮箱, 联系电话, 公司, 公司邮箱, 邮政编码;private JRadioButton 男, 女, 开通, 暂停;private JComboBox 付款方式, 省份, 职业;private String st1, st2, st3;public 开通账户()JPanel p1 = new JPanel();p1.setLayout(new BorderLayout();JPan

8、el 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(重设

9、);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

10、 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 JRadio

11、Button(男, 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 JPan

12、el(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

13、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(联

14、系电话);联系电话 = 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.

15、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(省份.getSelectedIn

16、dex() = 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(职业.get

17、SelectedIndex() = 2)st3 = 销售经理;if(职业.getSelectedIndex() = 3)st3 = 业务经理;public void actionPerformed(ActionEvent e)if(e.getSource() = 提交)/;if(账务密码.getText().equals(反复密码.getText()tryClass.forName(sun.jdbc.odbc.jdbcOdbcDriver);catch(ClassNotFoundException g)System.out.println(SQLException: + g.getLocali

18、zedMessage();String xb = ;if(男.isSelected()xb = 男;if(女.isSelected()xb = 女;String zt = ;if(开通.isSelected()zt = 开通;if(暂停.isSelected()zt = 暂停;tryConnection con;Statement stmt;ResultSet rs;con = DriverManager.getConnection(jdbc:odbc:电信IP资费管理系统);stmt = con.createStatement();/rs = stmt.executeQuery(select

19、 * 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()+,+邮政编码.getTe

20、xt()+);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.

21、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

22、 JTable jt1,jt2,jt3,jt4,jt5; public 明细() JPanel p1=new JPanel(new BorderLayout(); JPanel p2=new JPanel(); p1.add(p2,North); Object ob1=new Object24; String st1=帐务帐号,记录日期,总计(单位:小时),总费用(元); jt1=new JTable(ob1,st1); jt1.setSize(500,50); JScrollPane jsp1=new JScrollPane(jt1); jsp1.setPreferredSize(new D

23、imension(jt1.getWidth(),jt1.getHeight(); p2.add(jsp1); Object ob3=new Object24; 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 Bor

24、derLayout(); 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 Object93; String st2=登陆时间,退出时间,时长(单位:小时); jt2=new JTable(ob2,st2); jt2.setSize(500,150); JScrollPane jsp2=new JScrollPane(jt2); jsp2.setPr

25、eferredSize(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 Object24; String st4=帐务帐号,记录日期,总计(单位:小时),总费用(元); jt4=new JTable(ob4,st4); jt4.setSize(500,50); JScrollPane jsp4=new JScrollPane(jt4);

26、 jsp4.setPreferredSize(new Dimension(jt4.getWidth(),jt4.getHeight(); Object ob5=new Object93; 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

27、(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

28、,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.Jdbc

29、OdbcDriver); 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,您查询旳表为空表!, 系统

30、提示,JOptionPane.WARNING_MESSAGE); rs.beforeFirst(); Object obj=new Objectk2; for(int i=0;ik&rs.next();i+) obji0=rs.getString(serve); obji1=rs.getString(all); String s1=服务器,总计(单位:小时); zhangwu=new JTable(obj,s1); zhangwu.setSize(500,500); JScrollPane jsp1=new JScrollPane(zhangwu); jsp1.setPreferredSize

31、(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(年); but

32、ton=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;i4;i+) if(年.getSelectedIndex()=i) aline=查询日期:

33、+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(

34、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; Object obj2=new Object12; obj200=rs.getString(serve);

35、obj201=rs.getString(all); String s2=服务器,总计(单位:小时); JTable jt2=new JTable(obj2,s2); JScrollPane jsp2=new JScrollPane(jt2); p4.setVisible(false); p4.removeAll(); p4.add(jsp2); p4.setVisible(true); break; if(message=0) JOptionPane.showMessageDialog(this,您查询旳数据不存!, 系统提示,JOptionPane.WARNING_MESSAGE); con

36、.close(); catch(SQLException ex) ex.printStackTrace(); 8私人信息import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class 私人信息 extends JPanel implements ActionListener private JPanel p1,p2,p3,p4;private JLabel label1=new JLabel7;private JTextField tf1,tf2,tf3,tf4;priv

37、ate JPasswordField pf1,pf2;private JButton button1=new JButton2;public 私人信息()p1=new JPanel(new BorderLayout();p1.add(new JLabel(信息管理,JLabel.CENTER),North);p2=new JPanel(new GridLayout(7,1);p1.add(p2,West);String string1=登陆密码,反复密码,真实姓名,管理员邮箱*,开通日期,联系电话,登陆权限;for(int i=0;ilabel1.length;i+)label1i=new J

38、Label(string1i);p2.add(label1i);p3=new JPanel(new GridLayout(7,1,0,30);p1.add(p3,Center);pf1=new JPasswordField();p3.add(pf1);pf2=new JPasswordField();p3.add(pf2);tf1=new JTextField();p3.add(tf1);tf2=new JTextField();p3.add(tf2);p3.add(new JLabel(Sun Oct 15 00:00:00:00 CST );tf3=new JTextField();p3.add(tf3);tf4=new JTextField(资费管理 帐务查询