display3.java

管理学生信息

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;
class Display3 extends JFrame{
	ResultSet rs=null;
	DefaultTableModel model;
	int flag;
	Display3(String option){
		super("显示列表");
		setSize(500,450);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

		model = new DefaultTableModel();
		JTable table = new JTable(model);
		table.setPreferredScrollableViewportSize(new Dimension(450, 400));
		JScrollPane scrollPane = new JScrollPane(table);
		JPanel scrollPanel = new JPanel();
		scrollPanel.add(scrollPane);
		add(scrollPanel);

		if(option.equals("yonghu")){
			model.addColumn("用户名");
			model.addColumn("密码");
			model.addColumn("权限");
			flag=3;
		}
		if(option.equals("st")){
			String str[]=new String[]{"学号","姓名","性别","出生年份","学位"};
			for(int i=0;i<str.length;i++)
				model.addColumn(str[i]);
			flag=str.length;
		}
		if(option.equals("ch")){
			String str[]=new String[]{"课程名","课号","学分","任课教师"};
			for(int i=0;i<str.length;i++)
				model.addColumn(str[i]);
			flag=str.length;
		}
		if(option.equals("sc")){
			String str[]=new String[]{"学号","课程号","成绩"};
			for(int i=0;i<str.length;i++)
				model.addColumn(str[i]);
			flag=str.length;
		}
			
		Connection con=null;
		Statement sm=null;
		String command=null;
		try{
			//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:student");
		}catch(Exception ex){
		System.out.println(ex.getMessage());
		return;
		}
		try{
			sm=con.createStatement();
			command="select * from "+option;
			rs=sm.executeQuery(command);
			while(rs.next())
			{
				paint();
			}
			rs.close();
			sm.close();
		}catch(Exception ey){
		System.out.println(ey.getMessage());
		}
		try{
			con.close();
			dispose();
		}catch(Exception ez){}
		validate();
		setVisible(true);
		}
		public void paint(){
			try{
				String stk[]=new String[flag];
				for(int i=1;i<flag+1;i++)
					stk[i-1]=rs.getString(i).trim();
				model.addRow(stk);
			}catch(SQLException e)
			{
				System.out.println(e.getMessage());
			}
		}
}