package?dao;

import?java.sql.*;

public?class?baseDao?{
	
	private?static?String?driver?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	private?static?String?url?=?“jdbc:sqlserver://localhost:1433;DatabaseName=productSys“;
	private?static?String?uName?=?“sa“;
	private?static?String?passwd?=?““;

	static{
		try?{
			Class.forName（driver）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
	}
	
	public?static?Connection?getConnection（）?{
		try?{
			return?DriverManager.getConnection（url?uName?passwd）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?null;
		}
	}

	public?static?void?closeConn（Connection?connStatement?stResultSet?rs）?{
		if（rs!=null）{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if（st!=null）{
			try?{
				st.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（conn?!=?null）?{
			try?{
				conn.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	public?static?int?update（String?sql）{
		
		Connection?conn?=?null;
		Statement?stmt?=?null;
		
		int?num=0;
		
		try?{
			conn?=?getConnection（）;
			stmt?=?conn.createStatement（）;
			
			num?=?stmt.executeUpdate（sql）;
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			closeConn（conn?stmt?null）;
			
		}
		
		return?num;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????727??2014-07-16?09:48??testAJAX（增、刪、查）\.classpath

?????文件???????1041??2014-06-05?08:35??testAJAX（增、刪、查）\.project

?????文件????????503??2014-06-05?08:35??testAJAX（增、刪、查）\.settings\.jsdtscope

?????文件????????395??2014-06-05?08:35??testAJAX（增、刪、查）\.settings\org.eclipse.jdt.core.prefs

?????文件????????454??2014-06-05?08:35??testAJAX（增、刪、查）\.settings\org.eclipse.wst.common.component

?????文件????????305??2014-07-16?09:48??testAJAX（增、刪、查）\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-06-05?08:35??testAJAX（增、刪、查）\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-06-05?08:35??testAJAX（增、刪、查）\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2226??2014-07-16?09:48??testAJAX（增、刪、查）\build\classes\dao\baseDao.class

?????文件???????3474??2014-07-16?11:11??testAJAX（增、刪、查）\build\classes\dao\ProductDao.class

?????文件???????2075??2014-07-16?11:01??testAJAX（增、刪、查）\build\classes\entity\Product.class

?????文件???????1855??2014-07-16?11:11??testAJAX（增、刪、查）\build\classes\servlet\AddServlet.class

?????文件???????1519??2014-07-16?09:48??testAJAX（增、刪、查）\build\classes\servlet\DelProductServlet.class

?????文件???????2749??2014-07-16?11:28??testAJAX（增、刪、查）\build\classes\servlet\ProductServlet.class

?????文件???????1671??2014-07-16?09:48??testAJAX（增、刪、查）\build\classes\servlet\QueryProductServlet.class

?????文件???????1623??2014-07-16?09:48??testAJAX（增、刪、查）\build\classes\servlet\Test.class

?????文件????????584??2014-06-05?12:32??testAJAX（增、刪、查）\product.sql

?????文件???????1468??2014-06-16?10:44??testAJAX（增、刪、查）\src\dao\baseDao.java

?????文件???????1856??2014-07-16?11:11??testAJAX（增、刪、查）\src\dao\ProductDao.java

?????文件???????1526??2014-07-16?11:01??testAJAX（增、刪、查）\src\entity\Product.java

?????文件???????1217??2014-07-16?11:11??testAJAX（增、刪、查）\src\servlet\AddServlet.java

?????文件????????997??2014-06-16?10:47??testAJAX（增、刪、查）\src\servlet\DelProductServlet.java

?????文件???????2056??2014-07-16?11:28??testAJAX（增、刪、查）\src\servlet\ProductServlet.java

?????文件???????1005??2014-06-16?09:15??testAJAX（增、刪、查）\src\servlet\QueryProductServlet.java

?????文件???????1098??2014-06-05?10:11??testAJAX（增、刪、查）\src\servlet\Test.java

?????文件????????260??2014-07-16?09:53??testAJAX（增、刪、查）\WebContent\css\ui-lightness\images\ui-bg_diagonals-thick_18_b81900_40x40.png

?????文件????????251??2014-07-16?09:53??testAJAX（增、刪、查）\WebContent\css\ui-lightness\images\ui-bg_diagonals-thick_20_666666_40x40.png

?????文件????????178??2014-07-16?09:53??testAJAX（增、刪、查）\WebContent\css\ui-lightness\images\ui-bg_flat_10_000000_40x100.png

?????文件????????104??2014-07-16?09:53??testAJAX（增、刪、查）\WebContent\css\ui-lightness\images\ui-bg_glass_100_f6f6f6_1x400.png

?????文件????????125??2014-07-16?09:53??testAJAX（增、刪、查）\WebContent\css\ui-lightness\images\ui-bg_glass_100_fdf5ce_1x400.png

............此處省略48個文件信息