displaystudents.java

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

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
//import UI.StudentUI;
public class DisplayStudents extends JFrame{
	static final String JDBC_DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";
	static final String DATABASE_URL="jdbc:odbc:studyDSN";
	private Connection connection;
	private Statement statement;
	public DisplayStudents()
	{
		super("Students Table of Study Database");
		try{
			Class.forName(JDBC_DRIVER);
			connection=DriverManager.getConnection(DATABASE_URL,"sa","123456");
			statement=connection.createStatement();
			String sqlString=new String("select sno as 学号,sname as 姓名,ssex as 性别,sage as 年龄,sdept as 所在系 from student");
			ResultSet resultSet=statement.executeQuery(sqlString);
			StringBuffer results=new StringBuffer();
			ResultSetMetaData metaData=resultSet.getMetaData();
			int numberOfColumns=metaData.getColumnCount();
			for(int i=1;i<=numberOfColumns;i++)
				results.append(metaData.getColumnName(i)+"\t");
			results.append("\n");
			while(resultSet.next()){
				for(int i=1;i<=numberOfColumns;i++)
					results.append(resultSet.getObject(i)+"\t");
				results.append("\n");
			}
			JTextArea textArea=new JTextArea(results.toString());
			Container container=getContentPane();
			container.add(new JScrollPane(textArea));
			setSize(300,100);setVisible(true);
		}
			catch(SQLException sqlException){
				JOptionPane.showMessageDialog(null, sqlException.getMessage(),"Database Error",JOptionPane.ERROR_MESSAGE);
				System.exit(1);
			}
			catch(ClassNotFoundException classNotFound){
				JOptionPane.showMessageDialog(null, classNotFound.getMessage(),"Drive Not Found",JOptionPane.ERROR_MESSAGE);
				System.exit(1);
			}
			finally{
				try{
					statement.close();connection.close();
				}
				catch(SQLException sqlException){
					JOptionPane.showMessageDialog(null, sqlException.getMessage(),"Database Error",JOptionPane.ERROR_MESSAGE);
					System.exit(1);
				}
			}
			
		}
	public static void main(String args[])
	{
	DisplayStudents window=new DisplayStudents();
	window.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
	}