ll.java~52~

基于java的学生信息管理系统的开发与应用

package sfms;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;

public class ll extends JFrame implements ActionListener {
   JTextField tt1, t2, t3, t4, t5, t6;
   JButton b4, b5, b6;
   String STNO="100009";
   ll() {
     super("更新学生档案");
     Container c2 = this.getContentPane();
     setBackground(new Color(215, 215, 215));
    c2.setLayout(new GridLayout(3, 1));
     tt1= new JTextField(50);
     t2 = new JTextField(50);
     t3 = new JTextField(50);
     t4 = new JTextField(50);
     t5 = new JTextField(50);
     t6 = new JTextField(50);
     JPanel pp1=new JPanel();
     pp1.add(new JLabel("学号为" + STNO + "学生的档案"));
     c2.add(pp1);
     JPanel pp2 = new JPanel(new GridLayout(6,2));
     pp2.add(new JLabel("学号"));
     tt1.setText(STNO);
     pp2.add(tt1);
     pp2.add(new JLabel("姓名"));
     pp2.add(t2);
     pp2.add(new JLabel("性别"));
     pp2.add(t3);
     pp2.add(new JLabel("系别"));
     pp2.add(t4);
     pp2.add(new JLabel("地址"));
     pp2.add(t5);
     pp2.add(new JLabel("电话"));
     pp2.add(t6);
     c2.add(pp2);
     JPanel pp3 = new JPanel(new FlowLayout());
     b4 = new JButton("确定");
     b5 = new JButton("清除");
     b6 = new JButton("退出");
     b4.addActionListener(this);
     b5.addActionListener(this);
     b6.addActionListener(this);
     pp3.add(b4);
     pp3.add(b5);
     pp3.add(b6);
     c2.add(pp3);
     this.setSize(400,300);
     this.addWindowListener(new WindowAdapter() {
     public void windowClosing(WindowEvent event) {
         shutDown2();
          }
             }
          );
  try {
       Class.forName("oracle.jdbc.OracleDriver").newInstance();
       String url = "jdbc:oracle:thin:@thsspc0792:1521:SFMS";
       Connection cn = DriverManager.getConnection(url, "df", "1234");
       String str = "select * from DF.FILEINFO where STNO='" + STNO + "'";
       PreparedStatement ps = cn.prepareStatement(str);
       ResultSet rs = ps.executeQuery();
       if (rs.next() == false) {
        JOptionPane.showMessageDialog(null, "您输入的学生号有误,请重新输入","输入错误",
                                     JOptionPane.YES_NO_OPTION );
       }
       else {
         tt1.setText(rs.getString("STNO"));
         t2.setText(rs.getString("SName"));
         t3.setText(rs.getString("Gender"));
         t4.setText(rs.getString("Department"));
         t5.setText(rs.getString("NativePlace"));
         t6.setText(rs.getString("TEL"));
       }
       cn.close();
     }
     catch (SQLException e) {
       System.out.println("Error Code: " + e.getErrorCode());
       System.out.println("Message=" + e.getMessage());
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }
   public void actionPerformed(ActionEvent f) {
     if (f.getSource() == b4) {
       up();
     }
     if (f.getSource() == b5) {
       tt1.setText("");
       tt1.repaint();
       t2.setText("");
       t2.repaint();
       t3.setText("");
       t3.repaint();
       t4.setText("");
       t4.repaint();
       t5.setText("");
       t5.repaint();
       t6.setText("");
       t6.repaint();

     }
     if (f.getSource() == b6) {
       shutDown2();
     }

   }
   public void up() {
     String s1, s2, s3, s4, s5, s6;
     s1 = tt1.getText();
     s2 = t2.getText();
     s3 = t3.getText();
     s4 = t4.getText();
     s5 = t5.getText();
     s6 = t6.getText();
     if (s1.length() == 0) {
       JOptionPane.showMessageDialog(null, "没有输入学生号");
     }
     if (s2.length() == 0) {
       JOptionPane.showMessageDialog(null, "没有输入学生名");
     }
     if (s3.length() == 0) {
       JOptionPane.showMessageDialog(null, "没有输入学生性别");

     }
     if (s4.length() == 0) {
       JOptionPane.showMessageDialog(null, "没有输入学生系别");
     }
     if (s5.length() == 0) {
       JOptionPane.showMessageDialog(this, "没有输入学生地址");
     }
     if (s6.length() == 0) {
       JOptionPane.showMessageDialog(null, "没有输入学生电话");

     }
     else {
       try {
         s1="100009";s2="141444";s3="14";s4="141444";s5="141444";s6="141444";

         Class.forName("oracle.jdbc.OracleDriver").newInstance();
         String url = "jdbc:oracle:thin:@localhost:1521:SFMS";
         Connection cn = DriverManager.getConnection(url, "df", "1234");
         String str = "update DF.FILEINFO"+
             " SET"+ "TEL='111111'"+
            " WHERE STNO='100009'";
         /*   "SNAME='" + s2 + "',"+
            "GENDER='" + s3 + "',"+
            "DEPARTMENT='" + s4 + "',"+
            "NATIVEPLACE='" + s5 + "',"+*/

         /*       +
            "SET"+
            "TEL='12324'"+
            "WHERE STNO='100009'";
          */
         PreparedStatement ps = cn.prepareStatement(str);
 //        ps.setString(1, s1);
         System.out.println("s1="+s1);
        /* ps.setString(2, s2);
         ps.setString(3, s3);
         System.out.println("s2="+s2);
         ps.setString(4, s4);
         ps.setString(5, s5);
         ps.setString(6, s6);
*/         ps.executeQuery(str);

         cn.close();
         JOptionPane.showMessageDialog(null, "更新成功!");
       }
       catch (SQLException e) {
         JOptionPane.showMessageDialog(null, "更新失败!");
       }
       catch (Exception e) {
                      e.printStackTrace();
         }
     }
   }
   public void shutDown2() {
     System.exit(0);
   }
    public static void main(String[] args) {
     ll rr = new ll();
      rr.setVisible(true);
    }
}