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（））;
	????		
	????		
	????	}
	????
	????	
	????}
}

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

?????文件????1048576??2013-03-26?17:46??244JSP駕校管理系統\jspkaoshixns_Data.MDF

?????文件????1048576??2013-03-26?17:46??244JSP駕校管理系統\jspkaoshixns_Log.LDF

?????文件????1426456??2012-03-01?19:49??244JSP駕校管理系統\JSP駕校管理系統錄像.exe

?????文件????????666??2013-03-26?17:42??244JSP駕校管理系統\mykaoshi\.classpath

?????文件????????297??2013-03-26?17:42??244JSP駕校管理系統\mykaoshi\.mymetadata

?????文件???????1226??2010-04-02?21:22??244JSP駕校管理系統\mykaoshi\.project

?????文件???????1454??2013-03-26?17:44??244JSP駕校管理系統\mykaoshi\src\db\db.java

?????文件???????3132??2008-05-31?21:26??244JSP駕校管理系統\mykaoshi\src\upload\file.java

?????文件???????1177??2008-05-31?21:26??244JSP駕校管理系統\mykaoshi\src\upload\files.java

?????文件???????2032??2008-05-31?21:26??244JSP駕校管理系統\mykaoshi\src\upload\Request.java

?????文件??????11739??2008-05-31?21:26??244JSP駕校管理系統\mykaoshi\src\upload\upBean.java

?????文件???????1306??2012-01-09?12:15??244JSP駕校管理系統\mykaoshi\WebRoot\adminyanzheng.jsp

?????文件????????865??2010-04-13?12:25??244JSP駕校管理系統\mykaoshi\WebRoot\center.jsp

?????文件???????1857??2011-11-02?23:00??244JSP駕校管理系統\mykaoshi\WebRoot\chengji.jsp

?????文件???????2031??2011-11-02?23:05??244JSP駕校管理系統\mykaoshi\WebRoot\chengji2.jsp

?????文件???????2118??2010-04-25?12:25??244JSP駕校管理系統\mykaoshi\WebRoot\chengji_updt.jsp

?????文件???????1086??2010-04-25?12:28??244JSP駕校管理系統\mykaoshi\WebRoot\chengji_updt_post.jsp

?????文件???????2140??2008-03-23?12:45??244JSP駕校管理系統\mykaoshi\WebRoot\CSS.css

?????文件????????824??2011-11-02?23:07??244JSP駕校管理系統\mykaoshi\WebRoot\databack.jsp

?????文件?????????61??2013-05-16?08:58??244JSP駕校管理系統\mykaoshi\WebRoot\default.jsp

?????文件????????873??2009-06-29?22:52??244JSP駕校管理系統\mykaoshi\WebRoot\del.jsp

?????文件????????946??2009-09-02?12:58??244JSP駕校管理系統\mykaoshi\WebRoot\down.jsp

?????文件???????3254??2011-11-02?22:40??244JSP駕校管理系統\mykaoshi\WebRoot\duoxuanti_add.jsp

?????文件???????1718??2011-11-02?22:39??244JSP駕校管理系統\mykaoshi\WebRoot\duoxuanti_add_post.jsp

?????文件???????4888??2011-11-02?22:40??244JSP駕校管理系統\mykaoshi\WebRoot\duoxuanti_list.jsp

?????文件???????4022??2011-11-02?22:40??244JSP駕校管理系統\mykaoshi\WebRoot\duoxuanti_updt.jsp

?????文件???????1429??2011-11-02?22:39??244JSP駕校管理系統\mykaoshi\WebRoot\duoxuanti_updt_post.jsp

?????文件???????1763??2009-06-29?22:52??244JSP駕校管理系統\mykaoshi\WebRoot\error.jsp

?????文件????????299??2010-11-14?10:03??244JSP駕校管理系統\mykaoshi\WebRoot\eWebEditor_V4.60\buttonimage\blue\about.gif

?????文件????????219??2010-11-14?10:03??244JSP駕校管理系統\mykaoshi\WebRoot\eWebEditor_V4.60\buttonimage\blue\abspos.gif

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