package?com.niit.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.niit.util.JDBCUtil;

public?class?baseDao?{
	protected?Connection?conn;
	protected?PreparedStatement?stmt;
	protected?ResultSet?rst;
	
	public?final?int?executeUpdate（String?sqlobject[]?obj）{
		int?rowNum=0;
		try?{
			getConnection（）;
			setPreParedStatement（sql?obj）;
			rowNum=stmt.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			close（）;
		}
		return?rowNum;
	}

	protected?void?setPreParedStatement（String?sql?object[]?obj）
			throws?SQLException?{
		stmt=conn.prepareStatement（sql）;
		if?（obj!=null&&obj.length>0）?{
			for?（int?i?=?0;?i?				stmt.setobject（i+1obj[i]）;
			}
		}
	}

	public?final?ResultSet?executeQuery（String?sqlobject[]?obj）
			throws?SQLException{
		getConnection（）;
		setPreParedStatement（sql?obj）;
		rst=stmt.executeQuery（）;
		return?rst;
	}
	
	protected?final?void?close（）?{
		JDBCUtil.closeAll（rst?stmt?conn）;
	}
	
	protected?final?void?getConnection（）?throws?SQLException?{
		conn=JDBCUtil.getConnection（）;
	}

	
	
//	public?static?void?main（String[]?args）?{
//		baseDao?dao=new?baseDao（）;
//		String?sql?=“insert?into?DrugInfo?values“?+
//				“（?????）“;
//		object[]?objs={“888““444“89“333“3};
//		int?i=dao.executeUpdate（sql?objs）;
//		System.out.println（i）;
//		
//	}
	
}

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

?????文件????????727??2013-07-07?12:15??DrugDemo\.classpath

?????文件???????1041??2013-07-03?11:30??DrugDemo\.project

?????文件????????503??2013-07-03?11:30??DrugDemo\.settings\.jsdtscope

?????文件????????364??2013-07-03?11:30??DrugDemo\.settings\org.eclipse.jdt.core.prefs

?????文件????????476??2013-07-03?11:30??DrugDemo\.settings\org.eclipse.wst.common.component

?????文件????????305??2013-07-07?12:14??DrugDemo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-07-03?11:30??DrugDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-07-03?11:30??DrugDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2012??2013-07-15?09:14??DrugDemo\build\classes\com\niit\dao\baseDao.class

?????文件????????995??2013-07-15?09:14??DrugDemo\build\classes\com\niit\dao\deleteImg.class

?????文件???????1600??2013-07-17?21:57??DrugDemo\build\classes\com\niit\entity\AttendanceSheet.class

?????文件???????2378??2013-07-17?16:09??DrugDemo\build\classes\com\niit\entity\BillInfo.class

?????文件???????1418??2013-07-17?21:57??DrugDemo\build\classes\com\niit\entity\CostInfo.class

?????文件???????2942??2013-07-15?13:22??DrugDemo\build\classes\com\niit\entity\Datails.class

?????文件???????2974??2013-07-16?00:23??DrugDemo\build\classes\com\niit\entity\DrugInfo.class

?????文件???????4335??2013-07-17?22:17??DrugDemo\build\classes\com\niit\entity\EmployeeInfo.class

?????文件???????2019??2013-07-15?20:57??DrugDemo\build\classes\com\niit\entity\EmpXiaoshou.class

?????文件???????2607??2013-07-17?15:29??DrugDemo\build\classes\com\niit\entity\OrderInfo.class

?????文件???????3657??2013-07-16?13:41??DrugDemo\build\classes\com\niit\entity\ReceiptInfo.class

?????文件???????1601??2013-07-15?09:14??DrugDemo\build\classes\com\niit\entity\ShopkeeperInfo.class

?????文件???????2416??2013-07-15?09:14??DrugDemo\build\classes\com\niit\entity\UserInfo.class

?????文件???????2041??2013-07-17?21:58??DrugDemo\build\classes\com\niit\impl\AttendanceSheetDaoImpl.class

?????文件???????3714??2013-07-17?16:53??DrugDemo\build\classes\com\niit\impl\BillInfoDaoImpl.class

?????文件???????3991??2013-07-18?11:29??DrugDemo\build\classes\com\niit\impl\DatailsDaoImpl.class

?????文件???????7426??2013-07-17?21:56??DrugDemo\build\classes\com\niit\impl\DrugInfoImpl.class

?????文件???????7131??2013-07-17?21:53??DrugDemo\build\classes\com\niit\impl\EmployeeInfoDaoImpl.class

?????文件???????2897??2013-07-15?21:53??DrugDemo\build\classes\com\niit\impl\EmpXiaoshouDaoImpl.class

?????文件???????5110??2013-07-18?11:23??DrugDemo\build\classes\com\niit\impl\OrderInfoDaoImpl.class

?????文件???????4175??2013-07-16?16:36??DrugDemo\build\classes\com\niit\impl\ReceiptInfoDaoImpl.class

?????文件???????1729??2013-07-15?09:14??DrugDemo\build\classes\com\niit\impl\ShopkeeperInfoDaoimpl.class

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