public static List getSalaryList(double jiaBanFei, double qingJiaFei,
double queQinFei, String year, String month) {
List list = new ArrayList();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int year1 = Integer.parseInt(year);
int month1 = Integer.parseInt(month);
boolean has = false;
try {
conn = DB.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql = "select count(*) from salaryinfo where syear='" + year1
+ "' and smonth='" + month1 + "'";//查询这个月的薪资表是否生成
rs = stmt.executeQuery(sql);
if (rs.next()) {
int i = rs.getInt(1);
if (i > 0) { has = true;
}
}
rs.close();
if (has == false) //生成薪资表
{
} sql = "select salaryinfo.impId,imployeeinfo.impName,salaryinfo.syear," //这里的salaryinfo.syear为char
+ "salaryinfo.smonth,salaryinfo.sBase,salaryinfo.sExtra," //这里的salaryinfo.smonth为char
+ "salaryinfo.sHoliday,salaryinfo.sAbsence,salaryinfo.sTotal,"
+ "salaryinfo.sState from salaryinfo,imployeeinfo "
+ "where salaryinfo.impId=imployeeinfo.impId"; rs = stmt.executeQuery(sql); while (rs.next()) {
String impId1 = rs.getString("impId");
String impName = new String(rs.getString("impName"));
String opyear = rs.getString("syear");
String opmonth = rs.getString("smonth");
double sBase = rs.getDouble("sBase");
double sExtra = rs.getDouble("sExtra");
double sHoliday = rs.getDouble("sHoliday");
double sAbsence = rs.getDouble("sAbsence");
double sTotal = rs.getDouble("sTotal");
int sState = rs.getInt("sState");
SalaryRecord sr = new SalaryRecord(impId1, impName, opyear,
opmonth, sBase, sExtra, sHoliday, sAbsence, sTotal,sState);
list.add(sr);
}
}
红字这我想选取符合用户输入的year1和month1的数据,但总是要么显示没数据要么出错,请大家帮我看一下该怎么修改
double queQinFei, String year, String month) {
List list = new ArrayList();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int year1 = Integer.parseInt(year);
int month1 = Integer.parseInt(month);
boolean has = false;
try {
conn = DB.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql = "select count(*) from salaryinfo where syear='" + year1
+ "' and smonth='" + month1 + "'";//查询这个月的薪资表是否生成
rs = stmt.executeQuery(sql);
if (rs.next()) {
int i = rs.getInt(1);
if (i > 0) { has = true;
}
}
rs.close();
if (has == false) //生成薪资表
{
} sql = "select salaryinfo.impId,imployeeinfo.impName,salaryinfo.syear," //这里的salaryinfo.syear为char
+ "salaryinfo.smonth,salaryinfo.sBase,salaryinfo.sExtra," //这里的salaryinfo.smonth为char
+ "salaryinfo.sHoliday,salaryinfo.sAbsence,salaryinfo.sTotal,"
+ "salaryinfo.sState from salaryinfo,imployeeinfo "
+ "where salaryinfo.impId=imployeeinfo.impId"; rs = stmt.executeQuery(sql); while (rs.next()) {
String impId1 = rs.getString("impId");
String impName = new String(rs.getString("impName"));
String opyear = rs.getString("syear");
String opmonth = rs.getString("smonth");
double sBase = rs.getDouble("sBase");
double sExtra = rs.getDouble("sExtra");
double sHoliday = rs.getDouble("sHoliday");
double sAbsence = rs.getDouble("sAbsence");
double sTotal = rs.getDouble("sTotal");
int sState = rs.getInt("sState");
SalaryRecord sr = new SalaryRecord(impId1, impName, opyear,
opmonth, sBase, sExtra, sHoliday, sAbsence, sTotal,sState);
list.add(sr);
}
}
红字这我想选取符合用户输入的year1和month1的数据,但总是要么显示没数据要么出错,请大家帮我看一下该怎么修改
解决方案 »
- org.hibernate.hql.ast.QuerySyntaxException,请达人进来看看
- 我要存储一些数据一个key 一个value用XML怎么实现
- 如何监听session.getAttribute
- 怎样实现用鼠标拖动交换两个列的位置??????????
- 如何使动态生成的按钮被点击后删除所在行?
- 问关于出租和求租两个单词怎么写
- 请问用JSP开发WEB程序用哪个开发工具好啊!
- 做了个分页查询,按查询按钮时,如何重新回到第一页
- 帮我看看连接Oracle数据库bean是否有错误
- "\"转成"\\"的方法?在线
- MyBatis 3 resultType 无法赋值 父类 属性
- 开发技术选型的问题
2.报什么错,贴出来。
sql也可以写精简些。select a.impId,b.impName,a.syear,a.smonth,a.sBase
from salaryinfo a
inner join imployeeinfo b
on a.impId=b.impId