电信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

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

p4.add(new JLabel(s2[j]));

JPanel p5=new JPanel(new java.awt.FlowLayout(FlowLayout.CENTER));

String s3[]={"提交","清除"};

for(int i=0;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[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");