updatestudentframe.java

java+sql学生信息管理 该源码实现了学生信息的添加

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import UI.StudentUI;
import javax.swing.border.*;
public class UpdateStudentFrame extends JFrame{
	private StudentUI userInterface1,userInterface2;
	private JButton firstButton1,secondButton1,firstButton2,secondButton2;
	String snoUpdate;
	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;
	public UpdateStudentFrame(){
		super("Update a recond of students");
		initialize();
		String names1[]={"请输入要修改的学生的学号"};
		userInterface1=new StudentUI(names1);
		String names2[]={"学号","姓名","性别","年龄","所在院系"};
		userInterface2=new StudentUI(names2);
		Container c=getContentPane();
		Box box=Box.createVerticalBox();
		box.add(userInterface1);
		box.add(userInterface2);
		c.add(box);
		firstButton1=userInterface1.getDoTask1Button();
		firstButton1.setText("确认");
		firstButton1.addActionListener(
		new ActionListener(){
			public void actionPerformed(ActionEvent event)
			{DisplayRecord();}
		}		
		);
		secondButton1=userInterface1.getDoTask2Button();
		secondButton1.setText("清除");
		secondButton1.addActionListener( 
		new ActionListener(){
			public void actionPerformed(ActionEvent event)
			{userInterface1.clearFields();}
		}		
		);
		firstButton2=userInterface2.getDoTask1Button();
		firstButton2.setText("确认修改");
		firstButton2.addActionListener( 
		new ActionListener(){
			public void actionPerformed(ActionEvent event)
			{UpdateRecord();}
		}		
		);
		secondButton2=userInterface2.getDoTask2Button();
		secondButton2.setText("放弃");
		secondButton2.addActionListener( 
		new ActionListener(){
			public void actionPerformed(ActionEvent event)
			{userInterface2.clearFields();}
		}		
		);
		addWindowListener(
		new WindowAdapter(){
			public void windowClosing(WindowEvent event)
			{terminate();}
		}		
		);
		setSize(400,260);setVisible(true);
	}
	public void initialize()
	{
		try{
			Class.forName(JDBC_DRIVER);
			connection=DriverManager.getConnection(DATABASE_URL,"sa","123456");
			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 DisplayRecord(){
		String fieldValues1[]=userInterface1.getFieldValues();
		String fieldValues2[]=new String[5];
		if(!fieldValues1[StudentUI.SNO].equals("")){
			snoUpdate=fieldValues1[0];
			try{
				int numberAge=Integer.parseInt(fieldValues1[StudentUI.SNO]);
				String sqlString="select * from student where sno='"+fieldValues1[0]+"'";
				ResultSet resultSet=statement.executeQuery(sqlString);
				ResultSetMetaData metaData=resultSet.getMetaData();
				int numberOfColumns=metaData.getColumnCount();
				if(resultSet.next()){
					fieldValues2[0]=resultSet.getString(1);
					fieldValues2[1]=resultSet.getString(2);
					fieldValues2[2]=resultSet.getString(3);
					fieldValues2[3]=String.valueOf(resultSet.getString(4));
					fieldValues2[4]=resultSet.getString(5);
					
					userInterface2.setFieldValues(fieldValues2);
				}
				else{
					userInterface2.clearFields();
					JOptionPane.showMessageDialog(this, "Not fund this record!","Find Result",JOptionPane.INFORMATION_MESSAGE);
				}
			}
			catch(NumberFormatException formatException){
				JOptionPane.showMessageDialog(this, "Bad age number", "Invalid Number Format", JOptionPane.ERROR_MESSAGE);
			}
			catch(SQLException ee)
			{
				System.out.println(ee);
			}
		}
	}
	public void UpdateRecord()
	{
		String fieldValues[]=userInterface2.getFieldValues();
		if(!fieldValues[StudentUI.SNO].equals("")){
			try{
				int numberAge=Integer.parseInt(fieldValues[StudentUI.SNO]);
				String sqlString="Update student set sno='"+fieldValues[0]+"',sname='"+fieldValues[1]+"',ssex='"+fieldValues[2]+"',sage='"+numberAge+"',sdept='"+fieldValues[4]+"' where sno='"+snoUpdate+"'";
				int result=statement.executeUpdate(sqlString);
				if(result!=0)
				{
					JOptionPane.showMessageDialog(this, "Updated sucess!","Update Result",JOptionPane.INFORMATION_MESSAGE);
				}
			}
			catch(NumberFormatException formatException){
				JOptionPane.showMessageDialog(this, "Bad age number", "Invalid Number Format", JOptionPane.ERROR_MESSAGE);
			}
			catch(SQLException ee)
			{
				System.out.println(ee);
			}
			
		}			
	}
	public static void main(String args[])
	{new UpdateStudentFrame();}

}