电信资费管理系统样本.doc

资料内容仅供您学习参考，如有不当之处，请联系改正或者删除。
电信IP资费管理系统代码
重庆文理学院java课
4管理员列表

importjava.awt.*;
importjava.awt.event.*;
importjavax.swing.*;
importjava.sql.*;
publicclass管理员列表extendsJPanelimplementsActionListener{
privateJButtonbutton[]=newJButton[3];
privateJTabletable1;
public管理员列表(){
JPanelp1=newJPanel(newBorderLayout());
p1.add(newJLabel("管理员列表",JLabel.CENTER),"North");

Connectioncon;
ResultSetrs;
Statementsql;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundExceptionex){
System.out.println("error:"+ex);
}
try{
con=DriverManager.getConnection("jdbc:odbc:电信IP资费管理系统");
sql=con.createStatement(1005,1007);
rs=sql.executeQuery("select*fromuser");
rs.last();
intk=rs.getRow();
if(k==0){
JOptionPane.showMessageDialog(this,"您查询的表为空表!","系统提示",JOptionPane.WARNING_MESSAGE);
}
rs.beforeFirst();
Objectobj[][]=newObject[k][6];
for(inti=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");
}
JPanelp2=newJPanel();
Strings1[]={"帐号","姓名","电话","邮箱","开户日期","权限"};
table1=newJTable(obj,s1);
table1.setSize(500,500);
JScrollPanejsp1=newJScrollPane(table1);
jsp1.setPreferredSize(newDimension(table1.getWidth(),table1.getHeight()));
p2.add(jsp1);
p1.add(p2,"Center");
con.close();
}
catch(SQLExceptionse){
System.out.println("SQLEception"+se.getMessage());
}
JPanelp3=newJPanel(newFlowLayout());
p1.add(p3,"South");
Strings2[]={"删除","修改","清除"};
for(inti=0;i<button.length;i++){
button[i]=newJButton(s2[i]);
p3.add(button[i]);
button[i].addActionListener(this);
}
this.add(p1);
this.setVisible(true);
}
publicvoidactionPerformed(ActionEvente){
if(e.getActionCommand()=="修改"){
this.setVisible(false);
this.removeAll();
this.add(new管理员管理());
this.setVisible(true);
}
}

}

5开通账户

im