电信IP资费管理系统9-15解析.docVIP

电信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;ijt.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;js2.length;j++) p4.add(new JLabel(s2[j])); JPanel p5=new JPanel(new java.awt.FlowLayout(FlowLayout.CENTER)); String s3[]={提交,清除}; for(int i=0;ib.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;ijt.length;i++) { jt[i].setTe