2018年个税计算器代码.rar

2018年个税计算器代码,供大家在使用!

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（）;
		// 分层测试是否拿到前端的数据
		System.out.println（“应纳税所得额: “+taxable_income）;	
		// 查询税率和速算扣除数
		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个文件信息