infoform.java

企业员工考勤系统！！ ！

package manger;

import javax.swing.JFrame;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableCellRenderer;
import javax.swing.table.DefaultTableModel;

public class InfoForm {

	private JFrame jFrame = null;  //  @jve:decl-index=0:visual-constraint="112,-32"
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	int Mark = MainForm.jTable.getSelectedRow();
	/**
	 * This method initializes jFrame	
	 * 	
	 * @return javax.swing.JFrame	
	 */
	JFrame getJFrame() {
		if (jFrame == null) {
			jFrame = new JFrame();
			jFrame.setSize(new Dimension(252, 165));
			jFrame.setTitle("个人信息");
			Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();//窗口居中显示
			screenSize = Toolkit.getDefaultToolkit().getScreenSize();
			jFrame.setLocation((screenSize.width-jFrame.getWidth())/2,(screenSize.height-jFrame.getHeight())/2);
			jFrame.setContentPane(getJScrollPane());
		}
		return jFrame;
	}
	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}
	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable();
			jTable.setDefaultRenderer(Object.class, new MyRenderer());
			try {
				initjTable();
			} catch (Exception e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
		}
		return jTable;
	}
	
	private void initjTable() throws Exception {
		String[] Title = {"考勤序号","是否缺勤"}; 
		DefaultTableModel model = new DefaultTableModel(null,Title);
		String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		String Str="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=StuInfo";
		Connection con=null;
		Statement stmt=null;
		ResultSet rs=null;
		Class.forName(DBDriver);
		con=DriverManager.getConnection(Str);
		stmt=con.createStatement();
		rs=stmt.executeQuery("Select * From WorkInfo Where Num='"+MainForm.jTable.getValueAt(Mark, 1)+"'");
		while(rs.next())
		{
			if(rs.getInt("IsAbsent")==0) {
				Object rowData1[] = {rs.getInt("Work_ID"),"是"};
				model.addRow(rowData1);
			}
			else {
				Object rowData2[] = {rs.getInt("Work_ID"),"否"};
				model.addRow(rowData2);
			}
		}
		stmt.close();
		con.close();
		jTable.setModel(model);
		for(int i=0;i<2;i++)    //取消列宽的重定义
			jTable.getColumnModel().getColumn(i).setResizable(false);
		jTable.getSelectionModel().setSelectionMode(0);   //单行选择模式
		jTable.getTableHeader().setReorderingAllowed(false);   //列头锁定
	}
	
	class MyRenderer extends DefaultTableCellRenderer {
		private static final long serialVersionUID = 1L;
		public MyRenderer(){  
		        super();  
		        this.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);  
		}
	}
}