insert.java

java实现简易的教学管理系统

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


public class Insert extends JFrame implements ActionListener{
  //
  JTextField SnoText,SnameText,SsexText,SclassText;
  JTextField javaText,CText,dataText,opsystemText;
  
  JButton addButton,clearButton,closeButton;
  
  String Sno,Sname,Ssex,Sclass;
  
  String java,C,data,opsystem;
  
  MainWindow parent2;


  //
  public Insert(MainWindow main){
    parent2=main;
    Container c=this.getContentPane();
    c.setLayout(new GridLayout(4,2));
    
    JPanel centerPanel=new JPanel(new GridLayout(3,2));
    JPanel lowerPanel=new JPanel(new FlowLayout());

    //
    JLabel logoLabel=new JLabel("",SwingConstants.CENTER);
    logoLabel.setForeground(Color.red);
    logoLabel.setFont(new Font("TRUE",Font.TRUETYPE_FONT,30));
    logoLabel.setText("学生信息");
    c.add(logoLabel);

    //
    SnoText  =new JTextField();
    SnameText=new JTextField();
    SsexText =new JTextField();
    SclassText=new JTextField();
    
    javaText=new JTextField();
    CText=new JTextField();
    dataText = new JTextField();
    opsystemText = new JTextField();

    //
    centerPanel.add(new JLabel("学号",SwingConstants.CENTER));
    centerPanel.add(SnoText);
    centerPanel.add(new JLabel("姓名",SwingConstants.CENTER));
    centerPanel.add(SnameText);
    centerPanel.add(new JLabel("性别",SwingConstants.CENTER));
    centerPanel.add(SsexText);
    centerPanel.add(new JLabel("班级",SwingConstants.CENTER));
    centerPanel.add(SclassText);
    
    centerPanel.add(new JLabel("java",SwingConstants.CENTER));
    centerPanel.add(javaText);
    centerPanel.add(new JLabel("C++",SwingConstants.CENTER));
    centerPanel.add(CText);
    centerPanel.add(new JLabel("数据库",SwingConstants.CENTER));
    centerPanel.add(dataText);
    centerPanel.add(new JLabel("系统",SwingConstants.CENTER));
    centerPanel.add(opsystemText);
    
    c.add(centerPanel) ;
    //
    addButton  =new JButton("添加");
    clearButton=new JButton("清除");
    closeButton=new JButton("退出");
    lowerPanel.add(addButton);
    lowerPanel.add(clearButton);
    lowerPanel.add(closeButton);
    c.add(lowerPanel);


    //添加事件监听
    addButton.addActionListener(this);
    clearButton.addActionListener(this);
    closeButton.addActionListener(this);

    this.setSize(400,300);
    this.setTitle("添加学生信息");
    this.setVisible(true);
    this.setLocation(200,200);
    
    //窗口关闭监听
    this.addWindowListener(new WindowAdapter()
    {
      public void windowClosing(WindowEvent event){
        System.exit(0);
      }
    });
  }
  //按钮事件的监听
  public void actionPerformed(ActionEvent e){
    //
    if(e.getSource()==addButton)
    {Insertf();}                 ///////////////**************问题何在************
    if(e.getSource() ==clearButton)
    {clearForm();}
    if(e.getSource() ==closeButton)
    {shutDown();}
  }
  /////////////////////////////////////////////////////
  /////////////////////////////////////////////////////Insertf()
  private void Insertf(){
   
    Sno=SnoText.getText().trim();
    Sname=SnameText.getText().trim();
    Ssex=SsexText.getText().trim();
    Sclass=SclassText.getText().trim();
    ////////////////////////////////////
    java = javaText.getText().trim();
    C  = CText.getText().trim();
    data = dataText.getText();
    opsystem = opsystemText.getText().trim();

    if(Sno.length()==0&&Sname.length()==0&&Ssex.length()==0&&Sclass.length()==0)
      JOptionPane.showMessageDialog(this,"请添加完全信息");
     else
      {
        try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url="jdbc:odbc:STU";//
        Connection conn=DriverManager.getConnection(url,"sa","");
        /////////////////////////////////////////////////
        String student="insert into student"+ "values('" + Sno +"','"+ Sname+"','"+ Ssex+"','"+ Sclass +"')";
         //insert into student valuse('Sno','Sname','Ssex','Sclass');
        String course="insert into course" + "values('" +Sno +"',"+java+","+C+","+data+","+opsystem+")";
        //insert into course valuse()
      //  String student = "insert into student values (\'"+SnoText.getText()+"\,\'"+SnameText.getText()+"\',\'"+SsexText.getText()+"\',\'"+SclassText.getText()+"\')";
      //  String course  = "insert into course  values (\'"+SnoText.getText()+"\,\'"+javaText.getText()+"\',\'"+CText.getText()+"\',\'"+dataText.getText()+"\',\'"+opsystemText.getText()+"\')";
       
        Statement ps1=conn.createStatement();
        ps1.executeUpdate(student);
        
        //Statement ps2=conn.createStatement();   
        ps1.executeUpdate(course);
                        
        conn.close();
        JOptionPane.showMessageDialog(this,"添加成功!");
        clearForm();

       
      }
      
      
      
      catch(SQLException e){
        
        JOptionPane.showMessageDialog(null,e.getMessage(),
                       "数据库插入异常!",JOptionPane.ERROR_MESSAGE);
      
      }
      catch(Exception e){
        e.printStackTrace();
      }
     }
  }
  private void clearForm(){
    SnoText.setText("");
    SnameText.setText("");
    SsexText.setText("");
    SclassText.setText("");    
    javaText.setText("");
    CText.setText("");
    dataText.setText("");
    opsystemText.setText("");
    SnoText.requestFocus();
      }
  private void shutDown(){

   parent2.setVisible(true);
    this.dispose();
  }
  
}