package?com.student;

/*?這是我的一個Student表的模型
*/
import?java.sql.*;
import?java.util.Vector;
import?javax.swing.JTable;
import?javax.swing.table.*;

public?class?ConnectionGrade?extends?AbstractTableModel?{
	Vector?rowData?columnNames;
	JTable?jt?=?null;
	//?定義操作數(shù)據(jù)庫需要的東西
	PreparedStatement?ps?=?null;
	Connection?ct?=?null;
	ResultSet?rs?=?null;
	String?driver?=?“com.mysql.jdbc.Driver“;
	String?url?=?“jdbc:mysql://localhost:3306/studentsystem“;
	String?user?=?“root“;
	String?password?=?“123“;

	public?Boolean?updateStudent（String?sql?String[]?paras）?{
		boolean?b?=?true;
		try?{
			Class.forName（driver）;
			ct?=?DriverManager.getConnection（url?user?password）;
			ps?=?ct.prepareStatement（sql）;
			for?（int?i?=?0;?i?				ps.setString（i?+?1?paras[i]）;
			}
			if?（ps.executeUpdate（）?!=?1）?{
				b?=?false;
			}
		}?catch?（Exception?e）?{
			b?=?false;
			e.printStackTrace（）;
		}?finally?{
			try?{
				if?（ps?!=?null）
					ps.close（）;
				if?（ct?!=?null）
					ct.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		return?b;
	}

	public?void?init（String?sql）?{
		if?（sql?==?null）?{
			sql?=?“select?*?from?grade“;
		}
		jt?=?new?JTable（）;
		columnNames?=?new?Vector（）;//?設(shè)置列名
		columnNames.add（“學(xué)號“）;
		columnNames.add（“姓名“）;
		columnNames.add（“課程“）;
		columnNames.add（“成績“）;	

		rowData?=?new?Vector（）;
		try?{
			ct?=?DriverManager.getConnection（url?user?password）;
			ps?=?ct.prepareStatement（sql）;
			rs?=?ps.executeQuery（）;
			while?（rs.next（））?{
				Vector?hang?=?new?Vector（）;
				hang.add（rs.getInt（1））;
				hang.add（rs.getString（2））;
				hang.add（rs.getString（3））;
				hang.add（rs.getString（4））;	

				//?加入到rowData
				rowData.add（hang）;
			}
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}?finally?{
			try?{
				if?（rs?!=?null）
					rs.close（）;
				if?（ps?!=?null）
					ps.close（）;
				if?（ct?!=?null）
					ct.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	public?ConnectionGrade（String?sql）?{
		init（sql）;
	}
	public?ConnectionGrade（）?{
		this.init（null）;
	}

	public?void?addStu（String?sql）?{
		//?根據(jù)用戶輸入的sql語句完成添加任務(wù).
	}

	@Override
	public?String?getColumnName（int?column）?{
		return?（String）?this.columnNames.get（column）;
	}

	@Override
	//?得到共有多少列
	public?int?getColumnCount（）?{
		//?System.out.print（“getColumnCount“）;//?測試所用
		return?this.columnNames.size（）;
	}

	@Override
	//?得到共有多少行
	public?int?getRowCount（）?{
		return?this.rowData.size（）;
	}

	@Override
	//?得到某行某列的數(shù)據(jù)
	public?object?getValueAt（int?rowIndex?int?columnIndex）?
	{
		return?（（Vector）?this.rowData.get（rowIndex））.get（columnIndex）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3568??2015-01-14?12:08??數(shù)據(jù)庫源文件\studentsystem.sql

?????文件????????413??2015-01-08?13:38??eclipse源文件\javastudent\.classpath

?????文件????????387??2015-01-08?13:38??eclipse源文件\javastudent\.project

?????文件????????598??2015-01-08?13:38??eclipse源文件\javastudent\.settings\org.eclipse.jdt.core.prefs

?????文件???????4374??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\ConnectionGrade.class

?????文件???????4546??2015-01-10?14:08??eclipse源文件\javastudent\bin\com\student\ConnectionStudent.class

?????文件???????4387??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\ConnectionTeacher.class

?????文件???????6011??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\Login.class

?????文件???????2430??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\StuOperation.class

?????文件???????2971??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\StuQueryGrade.class

?????文件???????2978??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\StuQueryInfo.class

?????文件???????2584??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\TeaOperation.class

?????文件???????2894??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\TeaQueryInfo.class

?????文件???????3347??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\UserAddGrade.class

?????文件???????3694??2015-01-10?14:08??eclipse源文件\javastudent\bin\com\student\UserAddStu.class

?????文件???????3376??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\UserAddTea.class

?????文件???????3565??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\UserChangeGrade.class

?????文件???????3865??2015-01-10?14:08??eclipse源文件\javastudent\bin\com\student\UserChangeStu.class

?????文件???????3495??2015-01-09?19:33??eclipse源文件\javastudent\bin\com\student\UserChangeTea.class

?????文件???????4286??2015-01-10?14:45??eclipse源文件\javastudent\bin\com\student\UserMainGrade.class

?????文件???????4205??2015-01-10?14:45??eclipse源文件\javastudent\bin\com\student\UserMainStu.class

?????文件???????4287??2015-01-10?14:45??eclipse源文件\javastudent\bin\com\student\UserMainTea.class

?????文件???????2559??2015-01-10?13:56??eclipse源文件\javastudent\bin\com\student\UserOperation.class

?????文件???????2816??2015-01-09?09:15??eclipse源文件\javastudent\src\com\student\ConnectionGrade.java

?????文件???????2994??2015-01-10?14:08??eclipse源文件\javastudent\src\com\student\ConnectionStudent.java

?????文件???????2905??2015-01-08?19:35??eclipse源文件\javastudent\src\com\student\ConnectionTeacher.java

?????文件???????4774??2015-01-09?18:03??eclipse源文件\javastudent\src\com\student\Login.java

?????文件???????1539??2015-01-09?17:40??eclipse源文件\javastudent\src\com\student\StuOperation.java

?????文件???????1890??2015-01-09?17:42??eclipse源文件\javastudent\src\com\student\StuQueryGrade.java

?????文件???????1903??2015-01-09?17:42??eclipse源文件\javastudent\src\com\student\StuQueryInfo.java

............此處省略25個文件信息