package?com.bwm.db;
import?java.sql.*;
public?class?Condb{
	private?static?String?driverClass=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?String?url=“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=db_Scenince;user=sa;password=“;
	private?static?Connection?con=null;//Connection對(duì)象
	private?static?ResultSet?rs=null;//建立一個(gè)記錄集
	public?Condb（）{
		try{
			Class.forName（driverClass）;//用classforname方法加載驅(qū)動(dòng)程序類(lèi)
			con?=?DriverManager.getConnection（url）;
		}catch（Exception?e）{
			System.err.println（e）;
		}
		
	}public?ResultSet?executeQuery（String?sql）{//可以執(zhí)行添加刪等操作
		try{
			Statement?stmt=con.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
			rs=stmt.executeQuery（sql）;
		}catch（SQLException?er）{
			System.err.println（er.getMessage（））;
		}
		return?rs;
	}public?int?executeUpdate（String?sql）{//數(shù)據(jù)庫(kù)的更新操作
		int?result=0;
		try{?
			Statement?stmt=con.createStatement（）;
			result=stmt.executeUpdate（sql）;
		}catch（SQLException?ex）{
			System.err.println（ex.getMessage（））;
		}
		return?result;
	}
	public?void?close（）{
		try{
			if（con!=null）
				con.close（）;
		}catch（Exception?e）{?
			System.out.print（e）;
		}try{
			if（rs!=null）
				rs.close（）;
		}catch（Exception?e）{
			System.out.println（e）;
		}
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----

????......R???????432??2011-02-28?10:44??21\.classpath

????......R???????279??2011-05-12?09:15??21\.mymetadata

????......R??????1408??2011-02-28?10:44??21\.project

????......R???????500??2011-02-28?10:43??21\.settings\.jsdtscope

????......R???????330??2011-02-28?10:43??21\.settings\org.eclipse.jdt.core.prefs

????......R????????49??2011-02-28?10:43??21\.settings\org.eclipse.wst.jsdt.ui.superType.container

????......R?????????6??2011-02-28?10:43??21\.settings\org.eclipse.wst.jsdt.ui.superType.name

????......R???2228224??2011-05-21?09:48??21\database\db_Scenince_Data.MDF

????......R???3932160??2011-05-21?09:48??21\database\db_Scenince_Log.LDF

????......R??????1826??2011-02-28?10:44??21\src\com\bwm\db\Condb.class

????......R??????1333??2011-05-12?09:29??21\src\com\bwm\db\Condb.java

????......R???????689??2011-02-28?10:44??21\src\com\bwm\page\Show.class

????......R??????1651??2011-03-01?16:31??21\src\com\bwm\page\Show.java

????......R??????1257??2011-02-28?10:44??21\src\com\bwm\string\Sql.java

????......R??????3280??2011-02-28?10:57??21\src\com\bwm\string\Str.java

????......R???????973??2011-03-01?16:26??21\WebRoot\admin\admin.jsp

????......R??????6857??2011-03-02?09:06??21\WebRoot\admin\admindex.jsp

????......R???????291??2011-02-28?10:44??21\WebRoot\admin\botom.htm

????......R???????426??2011-02-28?10:44??21\WebRoot\admin\copy.htm

????......R???????774??2011-02-28?10:44??21\WebRoot\admin\index.htm

????......R??????1033??2011-02-28?10:44??21\WebRoot\admin\left.htm

????......R??????1779??2011-02-28?10:44??21\WebRoot\admin\login.jsp

????......R???????553??2011-02-28?10:44??21\WebRoot\admin\top.htm

????......R??????1212??2011-02-28?10:44??21\WebRoot\css\style.css

????......R????????10??2011-02-28?10:44??21\WebRoot\css\style.css.LCK

????......R??????1519??2011-02-28?10:44??21\WebRoot\flow.htm

????......R?????32311??2011-02-28?10:44??21\WebRoot\images\image\shenbao_1.gif

????......R?????14425??2011-02-28?10:44??21\WebRoot\images\image\shenbao_2.gif

????......R?????13714??2011-02-28?10:44??21\WebRoot\images\image\shenbao_4.gif

????......R?????23319??2011-02-28?10:44??21\WebRoot\images\image\shenbao_5.gif

............此處省略157個(gè)文件信息