package?common;
import?java.sql.*;
public?class?ConnDb?{

	/**
	?*?@param?args
	?*/
	
	private?Connection?conn=null;
	private?Statement?st=null;
	private?ResultSet?rs=null;
		
	public?Connection?getConn（）?{
		return?conn;
	}

	public?Statement?getSt（）?{
		return?st;
	}

	public?ResultSet?getRs（）?{
		return?rs;
	}

	public?void?setRs（ResultSet?rs）?{
		this.rs?=?rs;
	}

	public?void?createConn（）{
		//?TODO?Auto-generated?method?stub
		//數據庫驅動
		String?url=“jdbc:microsoft:sqlserver://localhost:1433;databaseName=tushu“;
		try?{
			Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）.newInstance（）;
			//創(chuàng)建連接
			conn=DriverManager.getConnection（url?“sa“?“sa“）;
			//創(chuàng)建實例對象
			st=conn.createStatement（）;
		}?catch?（InstantiationException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（IllegalAccessException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			//e.printStackTrace（）;
			System.out.println（“連接驅動失敗！“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?void?closeAll（）{
		try?{
			if（rs!=null）
				rs.close（）;
			if（st!=null）	
				st.close（）;
			if（conn!=null）	
				conn.close（）;			
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}		
	}
	public?void?query（String?sql）{
		try?{
			rs=st.executeQuery（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	public?void?update（String?sql）{
		try?{
			st.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-06-19?20:25??bookshop\
?????文件?????????786??2013-06-28?17:22??bookshop\.classpath
?????目錄???????????0??2013-06-28?17:22??bookshop\.myeclipse\
?????文件?????????297??2014-06-29?14:12??bookshop\.mymetadata
?????文件????????1414??2013-06-28?17:22??bookshop\.project
?????目錄???????????0??2014-06-19?20:25??bookshop\.settings\
?????文件?????????406??2013-06-28?17:22??bookshop\.settings\.jsdtscope
?????文件??????????49??2013-06-28?17:22??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-06-28?17:22??bookshop\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-06-19?20:25??bookshop\src\
?????目錄???????????0??2014-06-19?20:25??bookshop\src\common\
?????文件????????1833??2013-06-28?17:22??bookshop\src\common\ConnDb.java
?????文件????????2825??2013-06-28?17:22??bookshop\src\common\MyEclipseGen.java
?????目錄???????????0??2014-06-19?20:25??bookshop\WebRoot\
?????文件????????4175??2013-06-28?17:22??bookshop\WebRoot\1.jsp
?????文件????????4166??2013-06-28?17:22??bookshop\WebRoot\2.jsp
?????文件????????4181??2013-06-28?17:22??bookshop\WebRoot\3.jsp
?????文件????????2466??2013-06-28?17:22??bookshop\WebRoot\admin.jsp
?????文件????????2334??2013-06-28?18:25??bookshop\WebRoot\admin_book.jsp
?????文件????????2589??2013-06-28?18:25??bookshop\WebRoot\admin_order.jsp
?????文件????????1600??2013-06-28?17:22??bookshop\WebRoot\admin_shop.jsp
?????文件????????2365??2013-06-28?18:25??bookshop\WebRoot\admin_user.jsp
?????文件????????1503??2013-06-28?17:22??bookshop\WebRoot\bookadd.jsp
?????文件????????1288??2013-06-28?17:22??bookshop\WebRoot\bookBorrow.jsp
?????文件????????2392??2013-06-28?17:22??bookshop\WebRoot\bookBorrow1.jsp
?????文件????????1334??2013-06-28?17:22??bookshop\WebRoot\bookdelete.jsp
?????文件????????2433??2013-06-28?17:22??bookshop\WebRoot\bookmodi.jsp
?????文件????????2160??2013-06-28?17:22??bookshop\WebRoot\bookReturn.jsp
?????文件????????2159??2013-06-28?17:22??bookshop\WebRoot\bookReturn1.jsp
?????文件????????2104??2013-06-28?18:24??bookshop\WebRoot\bookselete.jsp
?????文件????????1360??2013-06-28?17:22??bookshop\WebRoot\borrowDele.jsp
............此處省略74個文件信息