display1.java

管理学生信息

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.util.*;
import java.sql.*;
class Display1 extends JFrame{
	ResultSet rs=null,rs1=null,rs2=null;//,rs3=null;
	Display1(ResultSet r){
		super("显示列表");
		setSize(500,450);
		//GridLayout bj=new GridLayout(20,1);
		setLayout(new FlowLayout());
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		this.rs1=r;

		String str[]=new String[]{"学号","姓名","性别","年龄","学位","课程名","成绩"};
		DefaultTableModel model=new DefaultTableModel();
		for(int i=0;i<str.length;i++)
			model.addColumn(str[i]);
		JTable table=new JTable(model);
		table.setPreferredScrollableViewportSize(new Dimension(450, 400));
		JScrollPane scroll=new JScrollPane(table);
		JPanel scrollPanel=new JPanel();
		scrollPanel.add(scroll);
		add(scrollPanel);
			
		Connection con=null,con2=null;
		Statement sm=null,sm2=null;
		String command=null,command2=null;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:student");
			con2=DriverManager.getConnection("jdbc:odbc:student");
		}catch(Exception ex){
				System.out.println(ex.getMessage());
				return;
		}
		try{
			while(rs1.next()){
				sm=con.createStatement();
				sm2=con2.createStatement();
				command2="select ch.cname,sc.grade from sc,ch where sc.cno=ch.cno and sc.sno='"+rs1.getString("sno")+"'";
				command="select sno,sname,sex,(2006-birth) as age,degree from st where sno='"+rs1.getString("sno")+"'";
				rs=sm.executeQuery(command);
				rs2=sm2.executeQuery(command2);
				if(rs.next())
				{
					String stk[]=new String[7];
					try{
						stk[0]=rs.getString(1).trim();
						stk[1]=rs.getString(2).trim();
						stk[2]=rs.getString(3).trim();
						stk[3]=rs.getString(4).trim();
						stk[4]=rs.getString(5).trim();
					}catch(SQLException e2){}
					if(rs2.next())
					{	
						stk[5]=rs2.getString(1).trim();
						stk[6]=rs2.getString(2).trim();
						model.addRow(stk);
						while(rs2.next())
						{
							stk[5]=rs2.getString(1).trim();
							stk[6]=rs2.getString(2).trim();
							model.addRow(stk);
						}
					}
					else
					{
						stk[5]="空";
						stk[6]="空";
						model.addRow(stk);
					}
					rs2.close();
					rs.close();
				}
			}
		}catch(Exception ey){
				System.out.println(ey.getMessage());
		}
		try{
			sm.close();
			sm2.close();
			con2.close();
			con.close();
			dispose();
		}catch(Exception ez){}
		setVisible(true);
		validate();
		}
}