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

	?private?String?sConnStr?=?“jdbc:microsoft:sqlserver://localhost:1433;databasename=jspjmsdfxns“;?
	??public?Connection?connect?=?null;
	??public?ResultSet?rs=null;
	??public?db（）?{
	????try?{
	?????
	??????Class.forName（dbDriver）.newInstance（）;?
	?????
	??????connect?=?DriverManager.getConnection（sConnStr“sa““sa“）;?
	?????
	????}
	????catch?（Exception?ex）?{
	??????System.out.println（“12121“）;
	????}
	??}
	
	??
	??public?ResultSet?executeQuery（String?sql）?{
			try{
				connect=DriverManager.getConnection（sConnStr“sa““sa“）;
				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（sConnStr“sa““sa“）;
	????		stmt=connect.createStatement（）;
	????		stmt.executeUpdate（sql）;
	????		stmt.close（）;
	????		connect.close（）;
	????		
	????	
	????	}
	????	catch（SQLException?ex）
	????	{
	????		System.err.println（ex.getMessage（））;
	????		
	????		
	????	}
	????
	????	
	????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-08-14?16:28??#_jsp_079_sqlserver_居民水電費收費系統_\
?????文件???????11776??2013-01-03?17:44??#_jsp_079_sqlserver_居民水電費收費系統_\Thumbs.db
?????目錄???????????0??2013-08-14?16:28??#_jsp_079_sqlserver_居民水電費收費系統_\程序\
?????文件?????????673??2011-04-16?00:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\.classpath
?????文件?????????306??2012-04-05?22:24??#_jsp_079_sqlserver_居民水電費收費系統_\程序\.mymetadata
?????文件????????1229??2011-12-14?14:20??#_jsp_079_sqlserver_居民水電費收費系統_\程序\.project
?????目錄???????????0??2013-08-14?16:32??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\
?????文件????????2140??2010-07-13?16:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\CSS.css
?????目錄???????????0??2013-08-12?17:38??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\meta-INF\
?????文件???????????9??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\meta-INF\Desktop_1.ini
?????文件??????????39??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2013-08-12?17:38??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\
?????文件???????????9??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\Desktop_1.ini
?????目錄???????????0??2013-08-12?17:38??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\classes\
?????目錄???????????0??2013-08-12?17:38??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\classes\db\
?????文件????????1980??2012-04-05?22:25??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\classes\db\db.class
?????目錄???????????0??2013-08-12?17:38??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\lib\
?????文件???????14334??2011-03-24?08:33??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\lib\jspsmartupload.jar
?????文件??????284752??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\lib\msbase.jar
?????文件???????64856??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\lib\mssqlserver.jar
?????文件???????59865??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\lib\msutil.jar
?????文件?????????284??2010-07-19?08:32??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\WEB-INF\web.xml
?????文件????????1430??2011-12-14?15:18??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\adminyanzheng.jsp
?????文件?????????805??2011-04-10?09:49??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\center.jsp
?????文件?????????821??2011-12-14?14:58??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\databack.jsp
?????文件?????????873??2010-07-13?15:02??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\del.jsp
?????文件????????1360??2011-12-14?14:20??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\down.jsp
?????目錄???????????0??2013-08-12?17:38??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\images\
?????文件????????2804??2007-11-06?00:10??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\images\CssAdmin.css
?????文件?????????111??2010-10-21?21:06??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\images\Upload.gif
?????文件????????2477??2010-04-19?22:04??#_jsp_079_sqlserver_居民水電費收費系統_\程序\WebRoot\images\cont.css
............此處省略92個文件信息