package?studentManageSystem.com.zse.controller;

import?java.awt.Color;
import?java.awt.GridLayout;
import?java.awt.event.*;
import?java.sql.Connection;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?javax.swing.*;
import?javax.swing.GroupLayout.Alignment;
import?javax.swing.event.TableModelEvent;
import?javax.swing.event.TableModelListener;
import?javax.swing.table.DefaultTableModel;

import?com.mysql.jdbc.PreparedStatement;
import?studentManageSystem.com.zse.dao.User;
import?studentManageSystem.com.zse.util.DbUtil;
import?studentManageSystem.com.zse.util.StringUtil;
import?studentManageSystem.com.zse.view.Adminframe;
import?studentManageSystem.com.zse.view.Loginframe;
import?studentManageSystem.com.zse.view.Userframe;

public?class?Controller?{
	public?static?Loginframe?loginframe;
	JPanel?jpanel;
????String[]?newvalue;
	String[]?oldScore;
		
	public?static?void?main（String[]?args）?{
		loginframe?=?new?Loginframe（new?Controller（））;
	}	
	public?User?login（Connection?connectionUser?userString?role）?throws?SQLException{//登錄
		User?resultUser?=?null;
		String?sql?=?null;
		if（role.equals（“admin“））{
			sql?=?“select?*?from?administrator?where?username=‘“+user.getUsername（）+“‘?and?password=‘“+user.getPassword（）+“‘“;
		}else{
			sql?=?“select?*?from?user?where?username=‘“+user.getUsername（）+“‘?and?password=‘“+user.getPassword（）+“‘“;
		}
		ResultSet?result?=?statementQuery（connection?sql）;
		if（result.next（））{
			resultUser?=?new?User（）;
			resultUser.setUsername（result.getString（“username“））;
			resultUser.setPassword（result.getString（“password“））;
			if（role.equals（“admin“））{
				resultUser.setSno（null）;
			}else{
				resultUser.setSno（result.getString（“sno“））;
			}
		}
		return?resultUser;
	}
	private?void?checkStudentInfo（Connection?connectionAdminframe?adminframe）?throws?SQLException{//查看學(xué)生信息
		jpanel?=?new?JPanel（）;
		object[][]?object?=?null;
		int?rowCount?=?0;
		int?columnCount;
		ResultSet?result?=?null;
		String[]?columnNames?=??{?“學(xué)號“?“姓名“?“性別“?“系號“?“專業(yè)號““出生日期“};
		
		try{
			String?sql?=?“select?snosnamessexdnospnosbirthday?from?studentinfo“;
			result?=?statementQuery（connection?sql）;
			//獲取行數(shù)?
			String?countSQL?=?“select?count（*）?totalCount?from?studentinfo“;
			ResultSet?rset?=?statementQuery（connection?countSQL）;
			if（rset.next（））?{?
				rowCount=rset?.getInt（“totalCount“）;?
			}?
			//獲取列數(shù)
			columnCount?=?result.getmetaData（）.getColumnCount（）;
			object?=?new?object[rowCount][columnCount];
			
			int?i=0?j=0;
			while（result.next（））{
				if（result.getString（1）?!=?null）{
					for（j?=?0;j<6;j++）{
						object[i][j]=result.getString（j+1）;
					}
					i++;
				}
			}
		}catch?（SQLException?e）?{?
			???e.printStackTrace（）;
		}
		JTable?checkTab?=?new?JTable（objectcolumnNames）;
		checkTab.setEnabled（false）;
		JScrollPane?scrollpane?=?new?JScrollPane（checkTab）;
		
		scrollpane.setBounds（2050500200）;
		jpanel.s

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-02-19?09:31??數(shù)據(jù)庫課程設(shè)計\
?????文件????????9545??2016-11-25?21:57??數(shù)據(jù)庫課程設(shè)計\informanagesystem.sql
?????文件??????490337??2016-12-28?17:42??數(shù)據(jù)庫課程設(shè)計\studentManageSystem.jar
?????文件?????1696768??2017-02-19?09:31??數(shù)據(jù)庫課程設(shè)計\數(shù)據(jù)庫課程設(shè)計報告.doc
?????目錄???????????0??2016-12-28?17:30??數(shù)據(jù)庫課程設(shè)計\源碼\
?????目錄???????????0??2016-12-28?17:34??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\
?????文件?????????473??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\.classpath
?????文件?????????395??2016-11-17?16:46??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\.project
?????目錄???????????0??2016-12-06?19:50??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\.settings\
?????文件??????????57??2016-11-20?12:17??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2016-11-17?16:46??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\.settings\org.eclipse.jdt.core.prefs
?????文件?????????106??2016-11-20?12:17??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\.settings\org.eclipse.ltk.core.refactoring.prefs
?????目錄???????????0??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\
?????目錄???????????0??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\
?????目錄???????????0??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\
?????目錄???????????0??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\
?????目錄???????????0??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\
?????文件????????1355??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$1.class
?????文件????????1431??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$10.class
?????文件????????1336??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$11.class
?????文件????????2719??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$12.class
?????文件????????1498??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$13.class
?????文件????????2897??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$14.class
?????文件????????1513??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$15.class
?????文件????????2521??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$16.class
?????文件????????2509??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$17.class
?????文件????????1032??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$18$1.class
?????文件????????2300??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$18$2.class
?????文件????????4414??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$18.class
?????文件????????1277??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$19.class
?????文件????????2818??2016-12-28?17:37??數(shù)據(jù)庫課程設(shè)計\源碼\studentManageSystem\bin\studentManageSystem\com\zse\controller\Controller$2.class
............此處省略50個文件信息