infogridbyqueryjpanel.java

学生信息管理系统 java + access

/**
 * 文件：InfoGridByQueryJPanel.java
 * 说明：学生信息查询数据（表格形式）面版
 **/
 package com.javaseries.java.component;
 import java.sql.*;
 import java.text.*;
 import java.awt.*;
 import java.awt.event.*;
 import javax.swing.*;
 
 public class InfoGridByQueryJPanel extends JPanel{
 	JTable table;
 	private JLabel JLmessage=new JLabel("学生通讯录");
 	private JPanel JPLabels =new JPanel();
 	private JPanel JPlistArea = new JPanel();
 public InfoGridByQueryJPanel()
 {
 	JPLabels.setLayout(new FlowLayout());
 	JPLabels.add(JLmessage);
 	
 	String[] strTableTitle={"学号","姓名","性别","出生日期","移动电话","固定电话","院系名称","家庭住址"};
 	String[][] strTableData=null;
 	try{
 		InfoModelDB mydata=new InfoModelDB();
 		
 		String sqlst="select count(*) from students";
 		ResultSet rs=mydata.executeSelect(sqlst);
 		int Num=0;
 		if(rs.next())
 		   Num=rs.getInt(1);
 		rs=null;
 		//组织数据
 		strTableData=new String[Num][9];
 		//形成select语句
 		sqlst="select * from students";
 		rs=mydata.executeSelect(sqlst);
 		int row=0;
 		while (rs.next())
 		{
 			strTableData[row][0]=rs.getString("sno");
 			strTableData[row][1]=rs.getString("name");
 			strTableData[row][2]=rs.getString("sex");
 			SimpleDateFormat fmt=new SimpleDateFormat("yyyy-MM-dd");
 			strTableData[row][3]=fmt.format(rs.getDate("birthday"));
			strTableData[row][4]=rs.getString("mophone");
			strTableData[row][5]=rs.getString("phone");
 			strTableData[row][6]=rs.getString("department");
			strTableData[row][7]=rs.getString("address");
 			row++;
 		}
 	}catch(SQLException ex){
 		ex.printStackTrace();
 	}catch(ClassNotFoundException ex){
 		ex.printStackTrace();
 	}
 	table=new JTable(strTableData,strTableTitle);
 	this.setLayout(new BorderLayout());
 	this.add(JPLabels,BorderLayout.NORTH);
 	this.add(new JScrollPane(table),BorderLayout.CENTER);
 	    
 }	
 }