sim_update.java

这是一个教学管理代码

package sims;

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

public class SIM_update extends JFrame implements ActionListener
{
    JLabel jLabel1 = new JLabel();
    JLabel 输入学号 = new JLabel();
    JTextField 学号输入 = new JTextField();
    JLabel 学号 = new JLabel();
    JLabel 姓名 = new JLabel();
    JLabel 班级 = new JLabel();
    JLabel 民族 = new JLabel();
    JLabel 籍贯 = new JLabel();
    JLabel 性别 = new JLabel();
    JLabel 生日 = new JLabel();
    JLabel 电话 = new JLabel();
    JLabel 家庭地址 = new JLabel();
    JTextField T学号 = new JTextField();
    JTextField T姓名 = new JTextField();
    JTextField T班级 = new JTextField();
    JTextField T民族 = new JTextField();
    JTextField T籍贯 = new JTextField();
    JTextField T性别 = new JTextField();
    JTextField T生日 = new JTextField();
    JTextField T电话 = new JTextField();
    JTextField T家庭地址 = new JTextField();
    JButton 预览 = new JButton();
    JButton 确定 = new JButton();

    public SIM_update()
    {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }


    }

    private void jbInit() throws Exception
   {
       this.getContentPane().setLayout(null);
       this.getContentPane().setBackground(new Color(240, 170, 200));
       jLabel1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 26));
       jLabel1.setForeground(Color.green);
       jLabel1.setText("学生信息更新");
       jLabel1.setBounds(new Rectangle(118, 4, 175, 36));
       学号.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       学号.setForeground(Color.blue);
       学号.setText("学号");
       学号.setBounds(new Rectangle(30, 100, 70, 30));
       输入学号.setFont(new java.awt.Font("宋体", Font.BOLD, 20));
       姓名.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       姓名.setForeground(Color.blue);
       姓名.setText("姓名");
       姓名.setBounds(new Rectangle(230, 100, 70, 30));
       班级.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       班级.setForeground(Color.blue);
       班级.setText("班级");
       班级.setBounds(new Rectangle(30, 160, 70, 30));
       民族.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       民族.setForeground(Color.blue);
       民族.setText("民族");
       民族.setBounds(new Rectangle(230, 160, 70, 30));
       籍贯.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       籍贯.setForeground(Color.blue);
       籍贯.setText("籍贯");
       籍贯.setBounds(new Rectangle(30, 220, 70, 30));
       性别.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       性别.setForeground(Color.blue);
       性别.setText("性别");
       性别.setBounds(new Rectangle(230, 220, 70, 30));
       生日.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       生日.setForeground(Color.blue);
       生日.setText("生日");
       生日.setBounds(new Rectangle(30, 280, 70, 30));
       电话.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       电话.setForeground(Color.blue);
       电话.setText("电话");
       电话.setBounds(new Rectangle(230, 280, 90, 30));
       家庭地址.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
       家庭地址.setForeground(Color.blue);
       家庭地址.setText("家庭地址");
       家庭地址.setBounds(new Rectangle(30, 340, 100, 30));
       T学号.setBounds(new Rectangle(80, 100, 120, 30));
       T姓名.setBounds(new Rectangle(276, 100, 120, 30));
       T班级.setBounds(new Rectangle(80, 160, 120, 30));
       T民族.setBounds(new Rectangle(276, 160, 120, 30));
       T籍贯.setBounds(new Rectangle(80, 220, 120, 30));
       T性别.setBounds(new Rectangle(276, 220, 120, 30));
       T生日.setBounds(new Rectangle(80, 280, 120, 30));
       T电话.setBounds(new Rectangle(276, 280, 120, 30));
       T家庭地址.setBounds(new Rectangle(112, 340, 310, 30));
        预览.setBounds(new Rectangle(79, 389, 95, 34));
        预览.setFont(new java.awt.Font("Dialog", Font.BOLD, 16));
        预览.setText("预览");
        确定.setBounds(new Rectangle(266, 389, 91, 34));
        确定.setFont(new java.awt.Font("Dialog", Font.BOLD, 16));
        确定.setText("确定");
        this.getContentPane().add(jLabel1);
        学号输入.setBounds(new Rectangle(155, 52, 126, 31));
       this.getContentPane().add(输入学号);
       this.getContentPane().add(学号输入);
        this.getContentPane().add(学号);
       this.getContentPane().add(班级);
       this.getContentPane().add(籍贯);
       this.getContentPane().add(姓名);
       this.getContentPane().add(性别);
       this.getContentPane().add(民族);
       this.getContentPane().add(生日);
       this.getContentPane().add(电话);
       this.getContentPane().add(家庭地址);
       this.getContentPane().add(T学号);
       this.getContentPane().add(T姓名);
       this.getContentPane().add(T班级);
       this.getContentPane().add(T民族);
       this.getContentPane().add(T籍贯);
       this.getContentPane().add(T性别);
       this.getContentPane().add(T电话);
       this.getContentPane().add(T生日);
       this.getContentPane().add(T家庭地址);
        this.getContentPane().add(预览);
        this.getContentPane().add(确定);
        输入学号.setForeground(Color.yellow);
       输入学号.setText("请输入学号");
       输入学号.setBounds(new Rectangle(31, 51, 123, 34));

       确定.addActionListener(this);
       预览.addActionListener(this);

       setVisible(true);
       setSize(430,470);
       setTitle("学生信息更新");
       show();
   }


    public void actionPerformed(ActionEvent e)
    {
        if(e.getSource()==预览)
        {
            try
          {
              connection c=new connection();
              Connection con=c.createConnection();
              String str=学号输入.getText();
              String sql="select * from Student where ID='"+str+"'";
              PreparedStatement ptmt=con.prepareStatement(sql);
              ResultSet rs=ptmt.executeQuery();
              while(rs.next())
              {
                  T学号.setText(rs.getString(1));
                  T姓名.setText(rs.getString(2));
                  T班级.setText(rs.getString(3));
                  T民族.setText(rs.getString(4));
                  T籍贯.setText(rs.getString(5));
                  T性别.setText(rs.getString(6));
                  T生日.setText(rs.getString(7));
                  T电话.setText(rs.getString(8));
                  T家庭地址.setText(rs.getString(9));
              }
              c.close(rs,ptmt,con);

          }catch (Exception ee){}

        }
        else if(e.getSource()==确定)
        {
            try
            {
                connection c=new connection();
                Connection con = c.createConnection();
                String str=学号输入.getText();
                String sql="update Student set ID=?,name=?,class=?,"+
                           "nationality=?,jiguan=?,sex=?,birth=?,phone=?,"+
                           "f_address=? where ID='"+str+"'";
                PreparedStatement ptmt=con.prepareStatement(sql);
                ptmt.setString(1, T学号.getText());
                ptmt.setString(2, T姓名.getText());
                ptmt.setString(3, T班级.getText());
                ptmt.setString(4, T民族.getText());
                ptmt.setString(5, T籍贯.getText());
                ptmt.setString(6, T性别.getText());
                ptmt.setString(7, T生日.getText());
                ptmt.setString(8, T电话.getText());
                ptmt.setString(9, T家庭地址.getText());
                ptmt.executeUpdate();
                JOptionPane.showMessageDialog(null,"更新成功","信息更新",JOptionPane.INFORMATION_MESSAGE);
                c.close(ptmt,con);

            }catch(Exception ee){}
        }

    }

}