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對象
	private?static?ResultSet?rs=null;//建立一個記錄集
	public?Condb（）{
		try{
			Class.forName（driverClass）;//用classforname方法加載驅動程序類
			con?=?DriverManager.getConnection（url）;
		}catch（Exception?e）{
			System.err.println（e）;
		}
		
	}public?ResultSet?executeQuery（String?sql）{//可以執行添加刪等操作
		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）{//數據庫的更新操作
		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）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????432??2014-04-24?17:56??.classpath
?????文件?????????279??2014-04-24?17:56??.mymetadata
?????文件????????1408??2014-04-24?17:56??.project
?????目錄???????????0??2014-11-14?19:36??.settings\
?????文件?????????500??2014-04-24?17:56??.settings\.jsdtscope
?????文件?????????330??2014-04-24?17:56??.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2014-04-24?17:56??.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-04-24?17:56??.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-11-14?19:36??WebRoot\
?????目錄???????????0??2014-11-14?19:36??WebRoot\meta-INF\
?????文件??????????36??2014-04-24?17:56??WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\classes\com\bwm\
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\classes\com\bwm\db\
?????文件????????2100??2014-04-24?17:56??WebRoot\WEB-INF\classes\com\bwm\db\Condb.class
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\classes\com\bwm\page\
?????文件????????1700??2014-04-24?17:56??WebRoot\WEB-INF\classes\com\bwm\page\Show.class
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\classes\com\bwm\string\
?????文件????????1021??2014-04-24?17:56??WebRoot\WEB-INF\classes\com\bwm\string\Sql.class
?????文件????????2543??2014-04-24?17:56??WebRoot\WEB-INF\classes\com\bwm\string\Str.class
?????目錄???????????0??2014-11-14?19:36??WebRoot\WEB-INF\lib\
?????文件??????583286??2014-04-24?17:56??WebRoot\WEB-INF\lib\sqljdbc.jar
?????文件????????1102??2014-04-24?17:56??WebRoot\WEB-INF\web.xml
?????目錄???????????0??2014-11-14?19:36??WebRoot\admin\
?????文件?????????973??2014-04-24?17:56??WebRoot\admin\admin.jsp
?????文件????????6857??2014-04-24?17:56??WebRoot\admin\admindex.jsp
?????文件?????????291??2014-04-24?17:56??WebRoot\admin\botom.htm
?????文件?????????426??2014-04-24?17:56??WebRoot\admin\copy.htm
?????文件?????????774??2014-04-24?17:56??WebRoot\admin\index.htm
............此處省略154個文件信息