电信IP资费管理系统9-15

电信IP资费管理系统代码重庆文理学院java课9添加资费import java.awt.*;import javax.swing.*;import java.sql.*;import java.awt.event.*;public class 添加资费extends JPanel implements ActionListener{private JPanel p1;private JTextField[]jt=new JTextField [4];private String s[]={"资费名称","月租费用","每小时费用","资费描述"};private JButton b[]=new JButton[2];public 添加资费(){p1=new JPanel(new BorderLayout());p1.add(new JLabel("添加新的资费政策",JLabel.CENTER),"North");JPanel p2=new JPanel(new GridLayout(1,2));JPanel p3=new JPanel(new GridLayout(4,2));p1.add(p2);p2.add(p3);for(int i=0;i<jt.length;i++){p3.add(new JLabel(s[i]));jt[i]=new JTextField();p3.add(jt[i]);}JPanel p4=new JPanel(new GridLayout(4,1));p2.add(p4);String s2[]={"请输入新建资费名称","请选择新建的月租费用","请输入每小时费用","请输入对新建资费的简单描述"};for(int j=0;j<s2.length;j++)p4.add(new JLabel(s2[j]));JPanel p5=new JPanel(new java.awt.FlowLayout(FlowLayout.CENTER));String s3[]={"提交","清除"};for(int i=0;i<b.length;i++){b[i]=new JButton(s3[i]);p5.add(b[i]);b[i].addActionListener(this);}p1.add(p5,"South");this.add(p1);this.setVisible(true);}public void actionPerformed(ActionEvent e){if(e.getSource()==b[0]){try{Connection conn;Statement stmt;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn = DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");stmt = conn.createStatement();String s1 = "";String s2 = "";s1="p"+jt[1].getText()+"-"+jt[2].getText();s2="月租"+jt[1].getText()+"元"+","+"每小时"+jt[2].getText()+"元";jt[0].setText(s1);jt[1].setText(s2);String sql="insert into source values('"+jt[0].getText()+"','"+jt[1].getText()+"','"+jt[2].getText()+"','"+s2+"')";stmt.executeUpdate(sql);stmt.close();conn.close();this.setVisible(false);this.removeAll();this.add(new 资费列表());this.setVisible(true);}catch (SQLException ex){ex.printStackTrace();}catch (ClassNotFoundException ex){ex.printStackTrace();}}if(e.getSource()==b[1]){for(int i=0;i<jt.length;i++){jt[i].setText("");}}}}10修改个人信息import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class 修改个人信息extends JPanel implements ActionListener,ItemListener{private JButton 修改;private JLabel label1[]=new JLabel[14];private JTextField textfield1[]=new JTextField[16];private String string1[]={"","密码*","重复密码*","姓名*","联系方式*","电子邮箱*","付款方式*","","职业","省份","性别","公司","公司邮箱","邮编"};private JPasswordField mima,chongfumima;private JRadioButton fukuanfangshi[]=new JRadioButton[3];private JRadioButton 男,女;private JComboBox 省份,职业;private String st1,st2,st3,st4,st5,st6,st7,st8,st9,st10;public 修改个人信息(){JPanel p1=new JPanel();p1.setLayout(new BorderLayout());JPanel p3=new JPanel();p1.add(p3,"South");修改=new JButton("修改");p3.add(修改);修改.addActionListener(this);JPanel p4=new JPanel(new GridLayout(14,1));p1.add(p4,"West");for(int i=0;i<14;i++){label1[i]=new JLabel(string1[i]);p4.add(label1[i]);}JPanel p5=new JPanel(new GridLayout(1,2,0,20));p1.add(p5,"Center");JPanel p6=new JPanel(new GridLayout(14,1));p5.add(p6);p6.add(new JLabel());mima=new JPasswordField("123");p6.add(mima);chongfumima=new JPasswordField("132");p6.add(chongfumima);Stringstring2[]={"aaa","62136369","**************"};for(int j=0;j<3;j++){textfield1[j]=new JTextField(string2[j]);p6.add(textfield1[j]);}JPanel p7=new JPanel(new GridLayout(1,3));p6.add(p7);ButtonGroup fangshi=new ButtonGroup();String s_fangshi[]={"现金支付","银行转账","IP卡充值"};for(int i=0;i<3;i++){fukuanfangshi[i]=new JRadioButton(s_fangshi[i]);fangshi.add(fukuanfangshi[i]);if(fukuanfangshi[i].isSelected())st3=""+s_fangshi+"";}p6.add(new JLabel());Object zhiye[]={"软件工程师","部门经理","销售经理","业务经理"}; 职业=new JComboBox(zhiye);职业.addItemListener(this);p6.add(职业);Object shengfen[]={"北京","上海","河南","吉林","黑龙江","天津"}; 省份=new JComboBox(shengfen);p6.add(省份);省份.addItemListener(this);JPanel p8=new JPanel();p6.add(p8);ButtonGroup bg1=new ButtonGroup();男=new JRadioButton("男",true);bg1.add(男);p8.add(男);女=new JRadioButton("女");bg1.add(女);p8.add(女);for(int i=3;i<6;i++){textfield1[i]=new JTextField();p6.add(textfield1[i]);}JPanel p9=new JPanel(new GridLayout(14,1));p5.add(p9);p9.add(new JLabel("aaa的资料管理状态[正常]"));p9.add(new JLabel("请输入用户的密码"));p9.add(new JLabel("请重复以上密码"));p9.add(new JLabel("请输入用户的真实姓名"));p9.add(new JLabel("请输入有效的联系方式"));p9.add(new JLabel("请输入有效的电子邮箱"));p9.add(new JLabel());p9.add(new JLabel("以下是附加信息(可不填)"));p9.add(new JLabel());p9.add(new JLabel());p9.add(new JLabel());p9.add(new JLabel("请输入公司名称(可不填)"));p9.add(new JLabel("请输入公司的电子邮箱(可不填)"));p9.add(new JLabel("请输入公司邮政编码(可不填)"));this.add(p1);this.setVisible(true);}public void itemStateChanged(ItemEvent f){st1=""+职业.getSelectedItem()+"";st2=""+省份.getSelectedItem()+"";if(男.isSelected())st4="男";if(女.isSelected())st4="女";char mm[]=mima.getPassword();for(int i=0;i<mm.length;i++)st5+=""+mm[i]+"";}public void actionPerformed(ActionEvent e){if(e.getSource()==修改){int message=0;Connection con;Statement sql;ResultSet rs;try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con=DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");sql=con.createStatement(1005,1008);rs=sql.executeQuery("select * from consumer");while(rs.next()){if(textfield1[0].getText().equals(rs.getString("name")));{message=1;String str1="UPDATE consumer SET password='"+st5+"',"+"name='"+textfield1[0].getText()+"',"+"telephone='"+textfield1[1].getText()+"',"+"mail+'"+textfield1[2].getText()+"',"+"methord='"+st3+"',work='"+st1+"',"+"province='"+st2+"',sex='"+st4+"',"+"workplace='"+textfield1[3].getText()+"',"+"mail2='"+textfield1[4].getText()+"',"+"post='"+textfield1[5].getText()+"',"+"WHERE name='"+textfield1[0].getText()+"'";sql.executeUpdate(str1);break;}}if(message==0)JOptionPane.showMessageDialog(this, "对不起!此用户名不存在" +"请重新输入!", "系统提示",RMA TION_MESSAGE);//rs.close();sql.close();con.close();this.setVisible(false);this.removeAll();this.add(new 用户列表());this.setVisible(true);}catch(HeadlessException ex){ex.printStackTrace();}catch(SQLException ex){ex.printStackTrace();}catch(ClassNotFoundException ex){ex.printStackTrace();}}}}11用户管理import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class 用户管理extends JPanel implements ActionListener {private JButton 开通账户, 用户列表, 查询;private JTextField 账务账号;private JPanel p1, p2, p3, p4, p5;private JButton[] jb = new JButton[3];private JScrollPane jsp1;private Connection con;private Statement sql;private ResultSet rs;private int message = 0;public 用户管理(){p1 = new JPanel(new BorderLayout());p2 = new JPanel();p1.add(p2, "North");p2.setLayout(new GridLayout(1, 5, 30, 0));开通账户= new JButton("开通账户");开通账户.addActionListener(this);p2.add(开通账户);用户列表= new JButton("用户列表");p2.add(用户列表);用户列表.addActionListener(this);p2.add(new JLabel("账务账号"));账务账号= new JTextField();p2.add(账务账号);查询= new JButton("查询");p2.add(查询);查询.addActionListener(this);p4 = new JPanel(new BorderLayout());p5 = new JPanel(new GridLayout(17, 1));p4.add(p5, "East");String[] s2 = {"恢复", "暂停", "删除"};int j = 0;for(j = 0; j<jb.length; j++){jb[j] = new JButton(s2[j]);jb[j].addActionListener(this);p5.add(jb[j]);}p3 = new JPanel();p1.add(p3, "Center");p3.add(new 用户列表());this.add(p1);this.setVisible(true);}public void actionPerformed(ActionEvent e){try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");con = DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");sql = con.createStatement(1005, 1008);rs = sql.executeQuery("select * from consumer");while(rs.next()){String st1 = rs.getString("id");String st2 = 账务账号.getText();if(st2.equals(st1)){message = 1;Object[][] ob = new Object[1][6];String[] s1 = {"账号", "姓名", "电话", "邮箱", "性别", "状态"};String st4 = rs.getString("state");ob[0][0] = st1;ob[0][1] = rs.getString("name");ob[0][2] = rs.getString("telephone");ob[0][3] = rs.getString("mail");ob[0][4] = rs.getString("sex");ob[0][5] = st4;JTable table1 = new JTable(ob, s1);table1.setSize(500, 50);jsp1 = new JScrollPane(table1);jsp1.setPreferredSize(new Dimension(table1.getWidth(), table1.getHeight()));p4.add(jsp1, "Center");if(e.getSource() == jb[1]){String st3 = "UPDA TE consumer SET state = '暂停' WHERE id = ''' + st2 + '''";sql.executeUpdate(st3);}if(e.getSource() == jb[0]){String st5 = "UPDA TE consumer SET state = '开通' WHERE id = ''' + st2 + '''";sql.executeUpdate(st5);}if(e.getSource() == jb[2]){String st6 = "DELETE from consumer WHERE id = ''' + st2 + '''";sql.executeUpdate(st6);}p3.setVisible(false);p3.removeAll();p3.add(new 用户列表());p3.setVisible(true);break;}}sql.close();con.close();}catch(HeadlessException ex){ex.printStackTrace();}catch(SQLException ex){ex.printStackTrace();}catch(ClassNotFoundException ex){ex.printStackTrace();}if(e.getSource() == 开通账户){p3.setVisible(false);p3.removeAll();p3.add(new 开通账户());p3.setVisible(true);//break;}if(e.getSource() == 用户列表){p3.setVisible(false);p3.removeAll();p3.add(new 用户列表());p3.setVisible(true);//break;}if(e.getSource() == 查询){if(message == 0){JOptionPane.showMessageDialog(this, "您查询的用户不存在", "系统提示", JOptionPane.W ARNING_MESSAGE);}else{p3.setVisible(false);p3.removeAll();p3.add(p4);p3.setVisible(true);}}}}12用户列表import static ng.System.out;import java.awt.*;import java.awt.event.*;import javax.swing.*;import javax.swing.table.*;import java.util.Vector;import java.sql.*;public class 用户列表extends JPanel implements ActionListener{private JTable m_view;private JPanel p1, p2, p3;public 用户列表(){JPanel p1 = new JPanel(new BorderLayout());Connection con;Statement stmt;ResultSet rs;try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundException f){out.println("SQLException:" + f.getLocalizedMessage());}try{con = DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");stmt = con.createStatement(1005, 1008);rs = stmt.executeQuery("select * from consumer");st();int k = rs.getRow();if(k == 0){JOptionPane.showMessageDialog(this, "您查询的表为空表！", "系统提示", JOptionPane.W ARNING_MESSAGE);}rs.beforeFirst();String ob[][] = new String[k][7];for(int i = 0; i<k && rs.next(); i++){ob[i][0] = rs.getString("state");ob[i][1] = rs.getString("id");ob[i][2] = rs.getString("name");ob[i][3] = rs.getString("telephone");ob[i][4] = rs.getString("mail");ob[i][5] = rs.getString("date");}String s[] = {"状态", "账务账号", "姓名", "电话", "邮箱", "日期",};m_view = new JTable(ob, s);m_view.setSize(700, 700);m_view.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);JScrollPane sPane = new JScrollPane(m_view);sPane.setPreferredSize(new Dimension(m_view.getWidth() - 300,m_view.getHeight() - 300));p3 = new JPanel(new FlowLayout());p1.add(p3, "Center");p3.add(sPane);this.add(p1);this.setVisible(true);con.close();}catch(SQLException ex){ex.printStackTrace();}}public void actionPerformed(ActionEvent e){}}13用户自服务import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class 用户自服务extends JPanel implements ActionListener {private JButton button[]=new JButton[2];private JPanel p1,p2,p3;public 用户自服务(){p1=new JPanel(new BorderLayout());p2=new JPanel();p1.add(p2,"North");String string[]={"修改个人信息","账单查询"};for(int i=0;i<button.length;i++){button[i]=new JButton(string[i]);button[i].addActionListener(this);p2.add(button[i]);}p3=new JPanel();p1.add(p3,"Center");p3.add(new 账单查询());this.add(p1);this.setVisible(true);}public void actionPerformed(ActionEvent e){if(e.getActionCommand()=="修改个人信息"){p3.setVisible(false);p3.removeAll();p3.add(new 修改个人信息());p3.setVisible(true);}if(e.getActionCommand()=="账单查询"){p3.setVisible(false);p3.removeAll();p3.add(new 账单查询());p3.setVisible(true);}}}14月账务查询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 String st1,st2,aline="";private JTextArea ta;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");st();int k=rs.getRow();if(k==0){JOptionPane.showMessageDialog(this,"您查询的表为空表！","系统提示",JOptionPane.W ARNING_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(newDimension(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[]={"2004","2005","2006","2007"};年=new JComboBox(obj1);p1.add(年);年.addItemListener(this);p1.add(new JLabel("年"));Object obj2[]={"1","2","3","4","5","6","7","8","9","10","11","12",}; 月=new JComboBox(obj2);p1.add(月);月.addItemListener(this);p1.add(new JLabel("月"));button=new JButton("月账务查询");button.addActionListener(this);p1.add(button);p3.add(p1,"North");ta=new JTextArea();JPanel p2=new JPanel();p2.add(ta);p3.add(p2,"South");this.add(p3);this.setVisible(true);}public void itemStateChanged(ItemEvent f){for(int i=0;i<4;i++){if(年.getSelectedIndex()==i)st1=""+(2004+i)+"";}for(int j=0;j<12;j++)if(月.getSelectedIndex()==j)st2=""+(j+1)+"";aline="查询日期：";aline+=""+st1+"年";aline+=""+st2+"月";}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");String st2=rs.getString("date2");if(年.getSelectedItem().equals(st1)&&(月.getSelectedItem().equals(st2))){message=1;Object obj2[][]=new Object[1][2];obj2[0][0]=rs.getString("serve");obj2[0][1]=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.W ARNING_MESSAGE);con.close();}catch(SQLException ex){ex.printStackTrace();}}}}15增加管理员import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*;public class 增加管理员extends JPanel implements ActionListener,ItemListener { private JPanel p1,p2;private JTextField textfield[]=new JTextField[6];private JCheckBox checkbox1[]=new JCheckBox[5];private JLabel label1[]=new JLabel[7];private JLabel label2[]=new JLabel[7];private JButton 提交;private String qx;public 增加管理员(){p1=new JPanel(new BorderLayout());p1.add(new JLabel("请添加管理员信息",JLabel.CENTER),"North");p2=new JPanel(new GridLayout(12,3,50,10));String string1[]={"帐号*","登陆密码","重复密码*","真实姓名*","管理员邮箱*","联系电话*","登陆权限*"};String string2[]={"请输入管理员帐号","请输入管理员的登陆密码","请重复以上管理员密码","请输入管理员的真实姓名","请输入管理员的邮箱","请输入管理员的联系电话","请选择管理员的操作权限"};for(int i=0;i<textfield.length;i++){label1[i]=new JLabel(string1[i]);p2.add(label1[i]);textfield[i]=new JTextField();p2.add(textfield[i]);label2[i]=new JLabel(string2[i]);p2.add(label2[i]);}label1[6]=new JLabel(string1[6]);p2.add(label1[6]);p2.add(new JLabel());label2[6]=new JLabel(string2[6]);p2.add(label2[6]);String string3[]={"管理员管理","资费管理","用户管理","帐务查询","帐单查询"};for(int j=0;j<string3.length;j++){p2.add(new JLabel());checkbox1[j]=new JCheckBox(string3[j]);checkbox1[j].addItemListener(this);p2.add(checkbox1[j]);p2.add(new JLabel());}p1.add(p2,"Center");JPanel p3=new JPanel(new FlowLayout(FlowLayout.CENTER));提交=new JButton("提交");提交.addActionListener(this);p3.add(提交);p1.add(p3,"South");this.add(p1);this.setVisible(true);}public void itemStateChanged(ItemEvent f){for(int i=0;i<checkbox1.length;i++){if(f.getSource()==checkbox1[i])qx+=checkbox1[i].getText()+"";}}public void actionPerformed(ActionEvent e){if(e.getSource()==提交){try{Connection conn;Statement stmt;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");stmt=conn.createStatement();String sql="insert into user(id,password,name,email,telephone,authority) values('"+textfield[0].getText()+"','"+textfield[1].getText()+"','"+textfield[2].getText()+"','"+textfield[3] .getText()+"','"+textfield[4].getText()+"','"+qx+"')";stmt.executeUpdate(sql);stmt.close();conn.close();}catch (SQLException ex){ex.printStackTrace();}catch (ClassNotFoundException ex){ex.printStackTrace();}}}}。