package?bean;
import?java.sql.*;
public?class?dbConn?{
????????Connection?conn?=?null;
????????ResultSet?rs?=?null;
????
????????//構(gòu)造函數(shù)
????????public?dbConn（）?
????????{
????????????????
????????}
????????
???????//查詢
????????public?ResultSet?executeQuery（String?sql）?{
????????????????try?{
????????????????	try
					{
						Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
					}?catch?（ClassNotFoundException?e）
					{
						//?TODO?Auto-generated?catch?block
						e.printStackTrace（）;
					}
????????????????	String?url=“jdbc:microsoft:sqlserver://localhost:1433;databaseName=ygEBuy“;
????????????????	String?user=“sa“;
????????????????	String?password=“sa“;
????????????????	conn?=?DriverManager.getConnection（urluserpassword）;
????????????????????????Statement?stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
????????????????????????
			rs?=?stmt.executeQuery（sql）;
????????????????}
????????????????catch（SQLException?ex）?{
????????????????????????System.err.println（ex.getMessage（））;
????????????????}
????????????????return?rs;
????????????????
????????}
????????
????????//插入或更新
????????public?int?executeUpdate（String?sql）?{
????????????????int?result?=?0;
????????????????try?{
????????????????	try
					{
						Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
					}?catch?（ClassNotFoundException?e）
					{
						//?TODO?Auto-generated?catch?block
						e.printStackTrace（）;
					}
????????????????	String?url=“jdbc:microsoft:sqlserver://localhost:1433;databaseName=ygEBuy“;
????????????????	String?user=“sa“;
????????????????	String?password=“sa“;
????????????????	conn?=?DriverManager.getConnection（urluserpassword）;
????????????????????????Statement?stmt?=?conn.createStatement（）;
????????????????????????result?=?stmt.executeUpdate（sql）;
????????????????}
????????????????catch（SQLException?ex）?{
????????????????????????System.err.println（ex.getMessage（））;
????????????????}
????????????????return?result;
???????????????
????????}
????????
????????		////關(guān)閉數(shù)據(jù)庫連接
		public?void?dbClose（）?{
????????????????try?{
????????????????????????conn.close（）;
????????????????}
????????????????catch（SQLException?ex）?{
????????????????????????System.err.println（ex.getMessage（））;
????????????????}
????????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-02-21?23:35??SH\
?????文件?????????622??2012-02-21?23:26??SH\.classpath
?????目錄???????????0??2012-02-21?23:35??SH\.myeclipse\
?????文件?????????279??2012-02-21?23:21??SH\.mymetadata
?????文件????????1342??2007-05-13?21:20??SH\.project
?????目錄???????????0??2012-02-21?23:35??SH\src\
?????目錄???????????0??2012-02-21?23:35??SH\src\bean\
?????文件????????2388??2012-02-21?23:29??SH\src\bean\dbConn.java
?????文件????????1337??2007-05-13?22:35??SH\src\bean\Goods.java
?????文件????????1173??2007-05-13?23:14??SH\src\bean\Shop.java
?????文件?????????232??2007-05-13?23:01??SH\src\bean\Test.java
?????文件????????5628??2007-05-21?10:43??SH\src\bean\UploadBean.java
?????目錄???????????0??2012-02-21?23:35??SH\WebRoot\
?????文件????????4834??2007-05-24?21:43??SH\WebRoot\anyQuery.jsp
?????文件????????3455??2007-05-24?16:06??SH\WebRoot\buyDisplay.jsp
?????文件????????3473??2007-05-24?20:51??SH\WebRoot\buyQuery.htm
?????文件????????3697??2007-05-25?11:53??SH\WebRoot\buyQuery.jsp
?????文件?????????467??2007-05-14?01:40??SH\WebRoot\cartDel.jsp
?????文件????????3856??2007-05-24?21:13??SH\WebRoot\cartDisplay.jsp
?????文件?????????616??2007-05-14?01:16??SH\WebRoot\changeNum.jsp
?????目錄???????????0??2012-02-21?23:35??SH\WebRoot\img\
?????文件???????50318??2007-05-24?19:27??SH\WebRoot\img\11111.jpg
?????文件????????2350??2007-05-24?19:27??SH\WebRoot\img\2%.JPG
?????文件????????4863??2007-05-24?19:27??SH\WebRoot\img\logo.jpg
?????文件???????68830??2007-05-24?19:27??SH\WebRoot\img\logo.png
?????目錄???????????0??2012-02-21?23:35??SH\WebRoot\img\upload\
?????文件????????6030??2007-05-24?19:27??SH\WebRoot\img\upload\1166937136390.jpg
?????文件????????7272??2007-05-24?19:27??SH\WebRoot\img\upload\1166937165796.jpg
?????文件???????12794??2007-05-24?19:27??SH\WebRoot\img\upload\1166937200515.jpg
?????文件???????14415??2007-05-24?19:27??SH\WebRoot\img\upload\1166937225218.jpg
?????文件???????10474??2007-05-24?19:27??SH\WebRoot\img\upload\1166937258390.jpg
............此處省略71個(gè)文件信息