package?com.softlin.web.dao.baseDB;

import?java.util.List;

import?org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import?org.springframework.stereotype.Component;

@Component（“baseIbatisDao“）
public??class?baseIbatisDao?extends?SqlMapClientDaoSupport{

	//private?SqlSession?sqlSession;?ibatis3對象
	/**
	?*?查詢集合沒有參數(shù)
	?*?@param?statementName?bean?sql的名稱
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?queryForList（String?statementName）?throws?Exception{
		return?this.getSqlMapClientTemplate（）.queryForList（statementName）;
	}
	
	/**
	?*?查詢集合
	?*?@param?statementName?bean?sql的名稱
	?*?@param?obj?參數(shù)對象
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?queryForList（String?statementNameobject?obj）?throws?Exception{
		return?this.getSqlMapClientTemplate（）.queryForList（statementNameobj）;
		
	}
	
	/**
	?*?分頁查詢
	?*?@param?statementName?bean?sql的名稱
	?*?@param?obj?參數(shù)對象
	?*?@param?page?頁數(shù)
	?*?@param?size?行數(shù)
	?*?@return
	?*?@throws?Exception
	?*/
	public?List?queryForList（String?statementNameobject?objint?pageint?size）?throws?Exception{
		return?this.getSqlMapClientTemplate（）.queryForList（statementNameobjpagesize）;
	}
	
	public?object?queryForobject（String?sql）throws?Exception{
		return?this.getSqlMapClientTemplate（）.queryForobject（sql）;
	}
	
	
//	/**
//	?*?json格式分頁（有問題）
//	?*?@param?sql?sql語句
//	?*?@param?page?頁數(shù)
//	?*?@param?rows?行數(shù)
//	?*?@return
//	?*?@throws?Exception
//	?*/
//	public?JSONobject?queryForJson（String?sqlint?pageint?rows）throws?Exception{
//		Integer?count=getCount（sql）;
//		List?list=this.getSqlMapClientTemplate（）.queryForList（sql）;
//		List?list=this.getSqlMapClientTemplate（）.queryForList（sql?page?rows）;
//		JSONobject?json=new?JSONobject（）;
//		json.put（“total“?count）;
//		json.put（“rows“?JSONArray.fromobject（list））;
//		return?json;
//	}

	/**
	?*?保存數(shù)據(jù)
	?*?@param?statementName?bean?sql的名稱
	?*?@param?obj?參數(shù)對象
	?*?@return
	?*/
	public?object?save（String?statementNameobject?obj）throws?Exception{
		return??this.getSqlMapClientTemplate（）.insert（statementNameobj）;
	}
	
	/**
	?*?修改
	?*?@param?statementName?bean?sql的名稱
	?*?@param?obj?參數(shù)對象
	?*?@return
	?*/
	public?int?update（String?statementNameobject?obj）throws?Exception{
		return??this.getSqlMapClientTemplate（）.update（statementNameobj）;
	}
	
	/**
	?*?刪除
	?*?@param?statementName?bean?sql的名稱
	?*?@param?obj?參數(shù)對象
	?*?@return
	?*/
	public?int?delete（String?statementNameobject?obj）throws?Exception{
		return??this.getSqlMapClientTemplate（）.delete（statementNameobj）;
	}
	
	public?void?insert（String?statementNameobject?obj）?throws?Exception?{???
???????this.getSqlMapClientTemplate（）.insert（statementNameobj）;???
????}
	
	/**
	?*?獲取結(jié)果總數(shù)
	?*?@param?sql?sql語句
	?*?@return
	?*?@throws?Exception
	?*/
	public?Integer?getCount（String?sql）throws?Exception{
		return?（Integer）?this.getSqlMapClientTemplate（）.queryForobject（“common.selectCount“sql）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-09-27?16:32??softlin_new\
?????文件????????6426??2014-09-27?16:41??softlin_new\.classpath
?????目錄???????????0??2018-01-29?00:24??softlin_new\.myeclipse\
?????文件?????????306??2014-09-27?16:31??softlin_new\.mymetadata
?????文件????????1013??2014-09-27?16:31??softlin_new\.project
?????目錄???????????0??2014-09-27?16:31??softlin_new\.settings\
?????文件?????????629??2014-09-27?16:45??softlin_new\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2014-09-27?16:32??softlin_new\WebRoot\
?????目錄???????????0??2014-09-27?16:31??softlin_new\WebRoot\meta-INF\
?????文件??????????39??2014-09-27?16:31??softlin_new\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-09-27?16:32??softlin_new\WebRoot\WEB-INF\
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\softlin\
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\softlin\service\
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\softlin\service\test\
?????文件?????????950??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\softlin\service\test\InitTestAction.class
?????文件?????????999??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\softlin\service\test\InitTestDao.class
?????文件?????????807??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\com\softlin\service\test\InitTestService.class
?????目錄???????????0??2018-01-29?00:24??softlin_new\WebRoot\WEB-INF\classes\com\softlin\tag\
?????文件?????????223??2013-05-05?13:43??softlin_new\WebRoot\WEB-INF\classes\ehcache.xml
?????文件????????3894??2014-04-19?20:38??softlin_new\WebRoot\WEB-INF\classes\global.datasource.xml
?????文件????????3053??2014-04-19?20:32??softlin_new\WebRoot\WEB-INF\classes\global.multi.transaction.xml
?????文件????????1699??2014-04-19?18:35??softlin_new\WebRoot\WEB-INF\classes\global.service.xml
?????文件????????2307??2014-04-19?20:31??softlin_new\WebRoot\WEB-INF\classes\global.transaction.xml
?????文件?????????623??2014-04-19?18:29??softlin_new\WebRoot\WEB-INF\classes\ibatis-base.xml
?????文件?????????610??2014-02-21?23:08??softlin_new\WebRoot\WEB-INF\classes\ibatis-config.xml
?????文件????????1414??2014-04-19?20:38??softlin_new\WebRoot\WEB-INF\classes\jdbc.properties
?????文件????????3151??2014-04-19?20:23??softlin_new\WebRoot\WEB-INF\classes\log4j.properties
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\org\
?????目錄???????????0??2016-08-20?23:16??softlin_new\WebRoot\WEB-INF\classes\org\apache\
............此處省略3544個文件信息