package?com.itheima.dao;

import?java.sql.SQLException;

import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanHandler;

import?com.itheima.domain.Personal_income_tax;
import?com.itheima.utils.c3p0_jdbcUtils;

/**
?*?@author:?qi
?*?@date:?2018年6月21日
?*?@description:
?*/
public?class?taxDao?{

	/**
	?*?@param?pit
	?*?@return
	?*?@throws?SQLException
	?*/
	public?Personal_income_tax?query（Personal_income_tax?pit）
			throws?SQLException?{
		//?用工具獲取QueryRunner核心類
		QueryRunner?qr?=?new?QueryRunner（c3p0_jdbcUtils.getDataSource（））;
		Double?taxable_income?=?pit.getTaxable_income（）;
		//?分層測試是否拿到前端的數(shù)據(jù)
		System.out.println（“應(yīng)納稅所得額:?“+taxable_income）;	
		//?查詢稅率和速算扣除數(shù)
		if?（taxable_income?>=?80000）?{
			String?sql?=?“select?*?from??personal_income_tax?where??taxable_income_min=80000“;
			Personal_income_tax?result?=?qr.query（sql
					new?BeanHandler（
							Personal_income_tax.class））;
			return?result;
		}?else?{
			String?sql?=?“select?*?from??personal_income_tax?where???>=taxable_income_min?and??			Personal_income_tax?result?=?qr.query（sql
					new?BeanHandler（
							Personal_income_tax.class）?taxable_income
					taxable_income）;
			return?result;
		}
	}

}

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

?????文件??????75975??2018-06-23?14:23??稅率表.jpg

?????文件????????725??2018-06-21?19:23??personal_income_tax\.classpath

?????文件???????1052??2018-06-21?19:22??personal_income_tax\.project

?????文件????????503??2018-06-21?19:22??personal_income_tax\.settings\.jsdtscope

?????文件????????364??2018-06-21?19:22??personal_income_tax\.settings\org.eclipse.jdt.core.prefs

?????文件????????509??2018-06-21?19:22??personal_income_tax\.settings\org.eclipse.wst.common.component

?????文件????????305??2018-06-21?19:22??personal_income_tax\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-06-21?19:22??personal_income_tax\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-06-21?19:22??personal_income_tax\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????373??2018-06-21?23:45??personal_income_tax\build\classes\c3p0-config.xml

?????文件???????2032??2018-06-22?02:30??personal_income_tax\build\classes\com\itheima\dao\taxDao.class

?????文件???????1853??2018-06-21?23:39??personal_income_tax\build\classes\com\itheima\domain\Personal_income_tax.class

?????文件????????750??2018-06-22?00:11??personal_income_tax\build\classes\com\itheima\service\taxService.class

?????文件???????1649??2018-06-21?23:29??personal_income_tax\build\classes\com\itheima\utils\c3p0_jdbcUtils.class

?????文件???????2786??2018-06-22?15:21??personal_income_tax\build\classes\com\itheima\web\servlet\QueryServlet.class

?????文件????????373??2018-06-21?23:45??personal_income_tax\src\c3p0-config.xml

?????文件???????1409??2018-06-22?02:30??personal_income_tax\src\com\itheima\dao\taxDao.java

?????文件???????1507??2018-06-21?23:39??personal_income_tax\src\com\itheima\domain\Personal_income_tax.java

?????文件????????574??2018-06-22?00:11??personal_income_tax\src\com\itheima\service\taxService.java

?????文件???????1450??2018-06-21?23:29??personal_income_tax\src\com\itheima\utils\c3p0_jdbcUtils.java

?????文件???????2283??2018-06-22?15:21??personal_income_tax\src\com\itheima\web\servlet\QueryServlet.java

?????文件???????3941??2018-06-22?01:54??personal_income_tax\WebContent\input_Pattern.jsp

?????文件?????????39??2018-06-21?19:22??personal_income_tax\WebContent\meta-INF\MANIFEST.MF

?????文件???????2256??2018-06-22?13:07??personal_income_tax\WebContent\personal_income_tax_calculater.jsp

?????文件?????610790??2018-06-08?11:02??personal_income_tax\WebContent\WEB-INF\lib\c3p0-0.9.1.2.jar

?????文件?????232019??2018-06-13?11:39??personal_income_tax\WebContent\WEB-INF\lib\commons-beanutils-1.8.3.jar

?????文件??????77857??2018-06-08?19:29??personal_income_tax\WebContent\WEB-INF\lib\commons-dbutils-1.6.jar

?????文件??????60841??2018-06-13?11:39??personal_income_tax\WebContent\WEB-INF\lib\commons-logging-1.1.1.jar

?????文件?????540852??2018-06-08?19:29??personal_income_tax\WebContent\WEB-INF\lib\mysql-connector-java-5.0.8-bin.jar

?????文件???????1025??2018-06-21?23:27??personal_income_tax\WebContent\WEB-INF\web.xml

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