sim_insert.java

这是一个教学管理代码

package sims;

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

public class SIM_insert extends JFrame implements ActionListener
{
    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();
    JLabel jLabel1 = new JLabel();
    JButton 确定 = new JButton();
    JButton 重置 = new JButton();
    public SIM_insert()
    {
        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(123, 25, 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, 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(94, 390, 89, 35));
        确定.setFont(new java.awt.Font("Dialog", Font.BOLD, 16));
        确定.setText("确定");
        重置.setBounds(new Rectangle(280, 393, 87, 33));
        重置.setFont(new java.awt.Font("Dialog", Font.BOLD, 16));
        重置.setText("重置");
        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(jLabel1);
        this.getContentPane().add(确定);
        this.getContentPane().add(重置);

        确定.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 sql = "insert into Student values(?,?,?,?,?,?,?,?,?)";
               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) {}

       }
       if(e.getSource()==重置)
       {
           T学号.setText("");
           T姓名.setText("");
           T班级.setText("");
           T民族.setText("");
           T籍贯.setText("");
           T性别.setText("");
           T生日.setText("");
           T电话.setText("");
           T家庭地址.setText("");
       }
   }


}