package?db;
import?java.sql.*;
public?class?db?{
	?private?String?dbDriver=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;

	?private?String?sConnStr?=?“jdbc:sqlserver://localhost:1433;databaseName=jspkaoshixns“;?
	?private?String?ussername=“sa“;//數據庫的連接名
	?private?String?usserpw=“sa“;//數據庫的連接密碼，需要改成你自己的
	?public?Connection?connect?=?null;
	??public?ResultSet?rs=null;
	??public?db（）?{
	????try?{
	?????
	??????Class.forName（dbDriver）.newInstance（）;?
	?????
	??????connect?=?DriverManager.getConnection（sConnStrussernameusserpw）;?
	?????
	????}
	????catch?（Exception?ex）?{
	??????System.out.println（“12121“）;
	????}
	??}
	
	??
	??public?ResultSet?executeQuery（String?sql）?{
			try{
				connect=DriverManager.getConnection（sConnStrussernameusserpw）;
				Statement?stmt=connect.createStatement（）;
				rs=stmt.executeQuery（sql）;
			}catch（SQLException?ex）{
				System.err.println（ex.getMessage（））;
			}
			return?rs;
		}
	??public?void?executeUpdate（String?sql）
	????{
	????	
	????	Statement?stmt=null;
	????	rs=null;
	????	try
	????	{???connect=DriverManager.getConnection（sConnStrussernameusserpw）;
	????		stmt=connect.createStatement（）;
	????		stmt.executeUpdate（sql）;
	????		stmt.close（）;
	????		connect.close（）;
	????		
	????	
	????	}
	????	catch（SQLException?ex）
	????	{
	????		System.err.println（ex.getMessage（））;
	????		
	????		
	????	}
	????
	????	
	????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\
?????文件?????1048576??2013-05-25?18:53??基于jsp的駕校考試系統\jspkaoshixns_Data.MDF
?????文件?????1048576??2013-05-25?18:53??基于jsp的駕校考試系統\jspkaoshixns_Log.LDF
?????目錄???????????0??2013-05-19?20:46??基于jsp的駕校考試系統\mykaoshi\
?????文件?????????666??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\.classpath
?????文件?????????297??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\.mymetadata
?????文件????????1226??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\.project
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\
?????文件????????2140??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\CSS.css
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\meta-INF\
?????文件??????????39??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\db\
?????文件????????2061??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\db\db.class
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\upload\
?????文件????????1912??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\upload\Request.class
?????文件????????3004??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\upload\file.class
?????文件????????1272??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\upload\files.class
?????文件????????8818??2013-05-25?17:54??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\classes\upload\upBean.class
?????目錄???????????0??2013-05-19?20:45??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\lib\
?????文件??????284752??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\lib\msbase.jar
?????文件???????64856??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\lib\mssqlserver.jar
?????文件???????59865??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\lib\msutil.jar
?????文件??????583286??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\lib\sqljdbc.jar
?????文件?????????377??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\WEB-INF\web.xml
?????文件????????1306??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\adminyanzheng.jsp
?????文件?????????865??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\center.jsp
?????文件????????1857??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\chengji.jsp
?????文件????????2031??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\chengji2.jsp
?????文件????????2118??2013-05-25?17:53??基于jsp的駕校考試系統\mykaoshi\WebRoot\chengji_updt.jsp
............此處省略566個文件信息