資源簡介
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();
//?分層測試是否拿到前端的數(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.xm
?????文件?????????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.xm
?????文件???????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.xm
?????文件???????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\me
?????文件???????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.xm
............此處省略28個文件信息
評論
共有 條評論