电信IP资费管理系统9_15
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
电信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));