package?db;
import?java.sql.*;
public?class?Datebase?{ResultSet?rs?=?null?;

//連接數據庫，并執行SQL查詢語句，返回結果指針
public?ResultSet?executeQuery（String?sql）{		
	try?{?
			Class.forName（“com.mysql.jdbc.Driver“）;?
			Connection?con=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/test“?“root“?“111111“）;?
			Statement?stmt=con.createStatement（）;?
			rs?=?stmt.executeQuery（sql）;
		}catch?（Exception?ex）{
			ex.printStackTrace（）;
			System.out.print（“數據庫連接失敗“）;
		}
	return?rs?;
}

//連接數據庫，并執行SQL更新語句，返回結果狀態

public?int?executeUpdate（String?sql）{
	int?count?=?0?;
	try{
		Class.forName（“com.mysql.jdbc.Driver“）;?
		Connection?con=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/test“?“root“?“111111“）;?
		Statement?stmt=con.createStatement（）;?
		count?=?stmt.executeUpdate（sql）;
	
	}catch（Exception?ex）{
		ex.printStackTrace（）;
		System.out.print（“數據庫操作失敗“）;
	}
	return?count;
}
}

		

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-05-27?15:20??shouye\
?????文件?????????434??2012-05-20?20:53??shouye\.classpath
?????目錄???????????0??2012-05-27?15:20??shouye\.myeclipse\
?????文件?????????291??2012-05-15?11:25??shouye\.mymetadata
?????文件????????1412??2012-05-15?11:29??shouye\.project
?????目錄???????????0??2012-05-27?15:20??shouye\.settings\
?????文件?????????406??2012-05-15?11:25??shouye\.settings\.jsdtscope
?????文件??????????88??2012-05-15?20:45??shouye\.settings\org.eclipse.core.resources.prefs
?????文件?????????334??2012-05-15?11:25??shouye\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2012-05-15?11:25??shouye\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2012-05-15?11:25??shouye\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-05-27?15:20??shouye\src\
?????目錄???????????0??2012-05-27?15:20??shouye\src\db\
?????文件?????????985??2012-05-26?12:14??shouye\src\db\Datebase.java
?????目錄???????????0??2012-05-27?15:20??shouye\WebRoot\
?????文件????????1830??2012-05-22?15:45??shouye\WebRoot\add.jsp
?????文件????????6583??2012-05-26?21:46??shouye\WebRoot\chen1.jsp
?????文件????????2796??2012-05-27?15:10??shouye\WebRoot\chen2.jsp
?????文件????????2926??2012-05-26?15:50??shouye\WebRoot\chen3.jsp
?????文件????????2412??2012-05-27?14:47??shouye\WebRoot\chen4.jsp
?????文件????????1286??2012-05-26?11:39??shouye\WebRoot\chen5.jsp
?????文件????????3189??2012-05-25?20:51??shouye\WebRoot\chen6.jsp
?????文件????????5555??2012-05-27?14:48??shouye\WebRoot\chenjun1.jsp
?????文件????????2869??2012-05-25?20:59??shouye\WebRoot\chenjun2.jsp
?????文件????????4158??2012-05-26?16:20??shouye\WebRoot\chenjun3.jsp
?????文件????????2427??2012-05-27?14:49??shouye\WebRoot\chenjun4.jsp
?????文件????????1547??2012-05-22?12:05??shouye\WebRoot\index.jsp
?????文件????????5021??2012-05-27?14:50??shouye\WebRoot\jun1.jsp
?????文件????????2865??2012-05-25?21:06??shouye\WebRoot\jun2.jsp
?????文件????????4161??2012-05-26?16:15??shouye\WebRoot\jun3.jsp
?????文件????????2417??2012-05-27?14:51??shouye\WebRoot\jun4.jsp
............此處省略25個文件信息