import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import UI.StudentUI;

class AddStudentFrame extends JFrame{
 private StudentUI userInterface;
 private JButton clearButton,writeButton;
 
 static final String JDBC_DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
 static final String DATABASE_URL="jdbc:odbc:studyDSN";
 
 private Connection connection;
 private Statement statement;
 String sqlString;
 
 String names[]={"学号","姓名","性别","年龄","所在系"
 };
 public AddStudentFrame(){
  super("add a record of students");
  initialize();
  
  userInterface=new StudentUI(names);
  getContentPane().add(userInterface,BorderLayout.CENTER);
  
  writeButton=userInterface.getDotask1Button();
  writeButton.setText("保存");
  
  writeButton.addActionListener(new ActionListener(){
   public void actionPerformed(ActionEvent event){
    addRecord();
   }
  });
  clearButton=userInterface.getDoTask2Button();
  clearButton.setText("清除");
  
  clearButton.addActionListener(
   new ActionListener(){
    public void actionPerformed(ActionEvent event){
     userInterface.clearFields();
    }
   });
   
  addWindowListener(new WindowAdapter(){
   public void windowClosing(WindowEvent event)
   {
    terminate();
   }
  });
  
  setSize(300,200);
  setVisible(true); 
 }
 public void initialize()
 {
  try{
   Class.forName(JDBC_DRIVER);
   connection=DriverManager.getConnection(DATABASE_URL,"sa",null);
   statement=connection.createStatement();
  }
  catch(SQLException sqlException){
   JOptionPane.showMessageDialog(null,sqlException.getMessage(),"Database error",JOptionPane.ERROR_MESSAGE);
   System.exit(1);
  }
  catch(ClassNotFoundException classNotFound){
   JOptionPane.showMessageDialog(null,classNotFound.getMessage(),"driver not found",JOptionPane.ERROR_MESSAGE);
   System.exit(1);
  }
 }
 
 public void terminate(){
  try{
   statement.close();
   connection.close();
   
  }
  catch(SQLException sqlException){
   JOptionPane.showMessageDialog(null,sqlException.getMessage(),"database error",JOptionPane.ERROR_MESSAGE);
   System.exit(1);
  }
 }
 public void addRecord(){
  String fieldValues[]=userInterface.getFieldValues();
  if(!fieldValues[StudentUI.SNO].equals("")){
   try{
    int numberAge=Integer.parseInt(fieldValues[StudentUI.SAGE]);
    
    String sqlInsert="insert into student"+"values('"+fieldValues[0]+"','"+fieldValues[1]+"','"+fieldValues[2]+"',"+numberAge+",'"+fieldValues[4]+"')";
    int result=statement.executeUpdate(sqlInsert);
    if(result!=0){
     userInterface.clearFields();
     JOptionPane.showMessageDialog(this,"inserted sucess!","insert result",JOptionPane.INFORMATION_MESSAGE);
    }
    
   }
   catch(NumberFormatException formatException){
    JOptionPane.showMessageDialog(this,"bad age numver","invalid numver format",JOptionPane.ERROR_MESSAGE);
   }
   catch(SQLException ee)
    {System.out.println(ee);
    }
   }
   else JOptionPane.showMessageDialog(this,"bad sno number","invalid number format",JOptionPane.ERROR_MESSAGE);
  }
 
 public static void main(String args[]){
  new AddStudentFrame();
 }
}

评论