operatorsystemframe.java

中小学校园的教师

  }

  void jButton1_actionPerformed(ActionEvent e) throws SQLException {

    //String sql;
    String name;
    name = User.getText().trim();
    sql = "SELECT * FROM dbo.login where user_name= '" + name + "'";

    con = DBConnection.getConnection();
    st = con.createStatement();
    rs = st.executeQuery(sql);
    boolean b;
    b = rs.next();
    classP.close(con);
    // classP.close(st);
    // classP.close(rs);

    if (b) {
      JOptionPane.showMessageDialog(null, "该用户已存在！！！");
    }
    else {

      sql =
          "INSERT  INTO  dbo.login (user_name, password, user_type)  VALUES  (?,?,?)";
      // Connection con = null;
     // JOptionPane.showMessageDialog(null, sql);
      try {
        con = DBConnection.getConnection();
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setString(1, User.getText());
        ps.setString(2, "123456");
        ps.setString(3, String.valueOf(jComboBox1.getSelectedIndex() + 1));
        ps.executeUpdate();
        JOptionPane.showMessageDialog(null, "添加成功！！！");
        classP.close(ps);
      }
      catch (Exception ex) {
        ex.printStackTrace();
        JOptionPane.showMessageDialog(null, "数据库连接有问题！！！");
      }
      finally {
        classP.close(con);
        queryDataSet1.refresh();

      }

    }

  }

  void jButton2_actionPerformed(ActionEvent e) {
   // if()
    jtfuser.setEditable(true);
    jPanel3.setVisible(false);
    String sql = " select * from login where user_name=?";
    // System.out.print(sql);

    Connection con = null;
    try {
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, jtfuser.getText());

      ResultSet rs = ps.executeQuery();

      if (rs.next()) {
        jPanel3.setVisible(true);
        jTextField2.setText(String.valueOf(rs.getInt(1)));
        jTextField3.setText(rs.getString(2).trim());
      //  jTextField1.setText(rs.getString(2).trim());
        jTextField4.setText(rs.getString(3).trim());
      }
      else {
        JOptionPane.showMessageDialog(null, "用户名不存在！！！");
      }
      DbUtil.close(rs);
      DbUtil.close(ps);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    finally {
      DbUtil.close(con);
    }

  }

  class OperatorSystemFrame_jButton1_actionAdapter
      implements java.awt.event.ActionListener {
    OperatorSystemFrame adaptee;

    OperatorSystemFrame_jButton1_actionAdapter(OperatorSystemFrame adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
      try {
        adaptee.jButton1_actionPerformed(e);
      }
      catch (SQLException ex) {
      }

    }
  }

  class OperatorSystemFrame_jButton2_actionAdapter
      implements java.awt.event.ActionListener {
    OperatorSystemFrame adaptee;

    OperatorSystemFrame_jButton2_actionAdapter(OperatorSystemFrame adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
      adaptee.jButton2_actionPerformed(e);
    }
  }

  void jButton3_actionPerformed(ActionEvent e)
  {
   // jTextField1.setEditable(true);
    jTextField1.setEditable(true);
    jtfuser.setEditable(false);

  }

  void jButton4_actionPerformed(ActionEvent e) throws SQLException {
    String sql = " DELETE FROM dbo.login where user_name=?";
    // System.out.print(sql);
    Connection con = null;
    con = DBConnection.getConnection();
    PreparedStatement ps = con.prepareStatement(sql);
    ps.setString(1, jtfuser.getText());
    ps.executeUpdate();
     JOptionPane.showMessageDialog(null, "已删除！！！");

  }

  /**
   * jButton5_actionPerformed
   *
   * @param e ActionEvent
   */
  void jButton6_actionPerformed(ActionEvent e) throws SQLException
  {
    jtfuser.setEditable(true);
    String sql = " UPDATE dbo.login SET password = ?  where user_name = ? ";
    jPanel3.setVisible(false);

   // System.out.print(sql);
   Connection con = null;
   con = DBConnection.getConnection();
   PreparedStatement ps = con.prepareStatement(sql);
   // ps.setString(1, jtfuser.getText());
    ps.setString(1, jTextField1.getText());
    ps.setString(2, jtfuser.getText());
  //  System.out.print(sql);
   ps.executeUpdate();
   jTextField1.setEditable(true);
    JOptionPane.showMessageDialog(null, "已修改！！！");
    jPanel3.setVisible(false);


  }

  void jTextField2_actionPerformed(ActionEvent e) {

  }

  void jButton5_actionPerformed(ActionEvent e) {
System.exit(0);
  }
}
  class OperatorSystemFrame_jButton2_actionAdapter  implements java.awt.event.ActionListener {
    OperatorSystemFrame adaptee;

    OperatorSystemFrame_jButton2_actionAdapter(OperatorSystemFrame adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
      adaptee.jButton2_actionPerformed(e);
    }
  }

  class OperatorSystemFrame_jButton4_actionAdapter
      implements java.awt.event.ActionListener {
    OperatorSystemFrame adaptee;

    OperatorSystemFrame_jButton4_actionAdapter(OperatorSystemFrame adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
      try {
        adaptee.jButton4_actionPerformed(e);
      }
      catch (SQLException ex) {
      }

    }

  }

class OperatorSystemFrame_jButton6_actionAdapter implements java.awt.event.ActionListener {
  OperatorSystemFrame adaptee;

  OperatorSystemFrame_jButton6_actionAdapter(OperatorSystemFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
      try {
       adaptee.jButton6_actionPerformed(e);
     }
     catch (SQLException ex) {
     }
 //   adaptee.jButton6_actionPerformed(e);
   // adaptee.jButton6_actionPerformed(e);
    //adaptee.jButton6_actionPerformed(e);

  }
}

class OperatorSystemFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  OperatorSystemFrame adaptee;

  OperatorSystemFrame_jButton3_actionAdapter(OperatorSystemFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class OperatorSystemFrame_jTextField2_actionAdapter implements java.awt.event.ActionListener {
  OperatorSystemFrame adaptee;

  OperatorSystemFrame_jTextField2_actionAdapter(OperatorSystemFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField2_actionPerformed(e);
  }
}

class OperatorSystemFrame_jButton5_actionAdapter implements java.awt.event.ActionListener {
  OperatorSystemFrame adaptee;

  OperatorSystemFrame_jButton5_actionAdapter(OperatorSystemFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}