package?database;
import?java.sql.*;
import?com.sun.rowset.*;
public?class?MySqlBean?{
????CachedRowSetImpl?rowSet;//查詢結果
????int?affectRows;//影響行數
	public?MySqlBean（）
	{
		try?
		{?
			Class.forName（“com.mysql.jdbc.Driver“）;??
		}catch（Exception?e）	{}?
	}
	public?void?setRowSet（String?sqlQuery）
	{
		Connection?con;
	????Statement?sql;
	????ResultSet?rs;
		try{
			String?uri=“jdbc:mysql://localhost/jsj0305“;
			con=DriverManager.getConnection（uri“root“““）;
			sql=con.createStatement（）;
			rs=sql.executeQuery（sqlQuery）;
			rowSet=new?CachedRowSetImpl（）;//創建行集對象
			rowSet.populate（rs）;
			con.close（）;
		}catch（Exception?e）?{}
	}
	public?CachedRowSetImpl?getRowSet（）
	{
		return?rowSet;
	}
	public?void?setAffectRows（String?sqlUpdate）
	{
		Connection?con;
	????Statement?sql;
		try{
			String?uri=“jdbc:mysql://localhost/jsj0305“;
			con=DriverManager.getConnection（uri“root“““）;
			sql=con.createStatement（）;
			affectRows=sql.executeUpdate（sqlUpdate）;//影響行數
			con.close（）;
		}catch（Exception?e）?{}
	}
	public?int?getAffectRows（）
	{
		return?affectRows;
	}
}

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

?????文件????????362??2010-12-18?19:38??.classpath

?????文件????????291??2010-12-18?19:39??.mymetadata

?????文件???????1224??2010-12-18?20:17??.project

?????文件???????8590??2010-12-19?10:59??data\jsj0305\admin.frm

?????文件?????????20??2010-12-19?10:59??data\jsj0305\admin.MYD

?????文件???????2048??2010-12-19?10:59??data\jsj0305\admin.MYI

?????文件???????8766??2010-12-19?20:00??data\jsj0305\course.frm

?????文件????????272??2010-12-20?10:28??data\jsj0305\course.MYD

?????文件???????3072??2010-12-20?10:58??data\jsj0305\course.MYI

?????文件?????????65??2010-12-18?17:27??data\jsj0305\db.opt

?????文件???????8590??2010-12-19?10:58??data\jsj0305\department.frm

?????文件?????????20??2010-12-19?10:58??data\jsj0305\department.MYD

?????文件???????2048??2010-12-19?10:58??data\jsj0305\department.MYI

?????文件???????8626??2010-12-19?10:57??data\jsj0305\sc.frm

?????文件?????????84??2010-12-20?10:58??data\jsj0305\sc.MYD

?????文件???????3072??2010-12-20?10:58??data\jsj0305\sc.MYI

?????文件???????8650??2010-12-19?15:48??data\jsj0305\student.frm

?????文件????????192??2010-12-20?15:31??data\jsj0305\student.MYD

?????文件???????3072??2010-12-20?15:31??data\jsj0305\student.MYI

?????文件???????8720??2010-12-19?10:56??data\jsj0305\teacher.frm

?????文件????????120??2010-12-19?23:22??data\jsj0305\teacher.MYD

?????文件???????3072??2010-12-19?23:34??data\jsj0305\teacher.MYI

?????文件????????115??2010-12-27?20:59??讀我.txt

?????文件???????1137??2010-12-18?22:55??src\database\MySqlBean.java

?????文件????????628??2010-12-19?23:26??WebRoot\admin\admin.jsp

?????文件????????416??2010-12-19?18:34??WebRoot\admin\administrator.jsp

?????文件???????1886??2010-12-19?19:35??WebRoot\admin\student.jsp

?????文件???????1392??2010-12-19?16:00??WebRoot\admin\student_add.jsp

?????文件???????1022??2010-12-19?16:54??WebRoot\admin\student_alt.jsp

?????文件????????822??2010-12-19?17:20??WebRoot\admin\student_alt_chk.jsp

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