try {
Statement st = cn.createStatement();
ResultSet rs1 = st.executeQuery("select sum(sueldoq) as sueldo from personal where quincena='1' and tipo='ALTO FUNCIONARIO'");
rs1.next();
String su1quaf1 = rs1.getString(1);
if (su1quaf1 == null) {
su1quaf1 = "0.00";
}
String cod1 = "01.02.00.01.4.01.01.35.00.000";
System.out.println("numero de renglones 1: " + su1quaf1 + " - " + cod1);
ResultSet rs2 = st.executeQuery("select sum(sueldoq) as sueldo from personal where quincena='1' and tipo='ALTO NIVEL'");
rs2.next();
String su1quaf2 = rs2.getString(1);
if (su1quaf2 == null) {
su1quaf2 = "0.00";
}
String cod2 = "01.02.00.01.4.01.01.36.00.000";
System.out.println("numero de renglones 2: " + su1quaf2 + " - " + cod2);
ResultSet rs3 = st.executeQuery("select sum(sueldoq) as sueldo from personal where quincena='1' and tipo='EMPLEADO'");
rs3.next();
String su1quaf3 = rs3.getString(1);
if (su1quaf3 == null) {
su1quaf3 = "0.00";
}
String cod3 = "01.02.00.01.4.01.01.01.00.000";
System.out.println("numero de renglones 3: " + su1quaf3 + " - " + cod3);
ResultSet rs4 = st.executeQuery("select sum(sueldoq) as sueldo from personal where quincena='1' and tipo='OBRERO'");
rs4.next();
String su1quaf4 = rs4.getString(1);
if (su1quaf4 == null) {
su1quaf4 = "0.00";
}
String cod4 = "01.02.00.01.4.01.01.10.00.000";
System.out.println("numero de renglones 4: " + su1quaf4 + " - " + cod4);
ResultSet rs5 = st.executeQuery("select sum(sueldoq) as sueldo from personal where quincena='1' and tipo='PENSIONADO'");
rs5.next();
String su1quaf5 = rs5.getString(1);
if (su1quaf5 == null) {
su1quaf5 = "0.00";
}
String cod5 = "01.02.00.01.4.01.01.01.01.000";
System.out.println("numero de renglones 5: " + su1quaf5 + " - " + cod5);
ResultSet rs6 = st.executeQuery("select sum(diasf) as sueldo from personal where quincena='1' and tipo='EMPLEADO'");
rs6.next();
String su1quaf6 = rs6.getString(1);
if (su1quaf6 == null) {
su1quaf6 = "0.00";
}
String cod6 = "01.02.00.01.4.01.04.10.00.000";
System.out.println("numero de renglones 6: " + su1quaf6 + " - " + cod6);
ResultSet rs7 = st.executeQuery("select sum(diasf) as sueldo from personal where quincena='1' and tipo='OBRERO'");
rs7.next();
String su1quaf7 = rs7.getString(1);
if (su1quaf7 == null) {
su1quaf7 = "0.00";
}
String cod7 = "01.02.00.01.4.01.04.20.00.000";
System.out.println("numero de renglones 7: " + su1quaf7 + " - " + cod7);
int su1quaf8 = 0;
ResultSet rs8 = st.executeQuery("select max(numord::int+1) from ordencausada");
rs8.next();
su1quaf8 = rs8.getInt(1);
if (su1quaf8 == 0) {
su1quaf8 = 1;
}
System.out.println("numero de renglones 8: " + su1quaf8);
double totalg = Double.valueOf(su1quaf1) + Double.valueOf(su1quaf2) + Double.valueOf(su1quaf3) + Double.valueOf(su1quaf4) + Double.valueOf(su1quaf5) + Double.valueOf(su1quaf6) + Double.valueOf(su1quaf7);
// DecimalFormat df = new DecimalFormat("#.##");
// totalg = Double.valueOf(df.format(totalg));
System.out.println("numero de renglones 9: " + totalg);
//////// PRINCIPAL
No hay comentarios:
Publicar un comentario