电信IP资费管理系统4-8资料.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;ikrs.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;ibutton.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(