Galera olha eu to programando em jsp assim…SOU UM SIMPLES INICIANTE.
eu tenho uma função que calcula o numero de dias uteis de um determinado mes, e eu não sei aonde eu ponho minha função alguem pode me ajudar???
<%@ page language=“java”
import=“java.sql."
import="oracle.jdbc.driver.”
import=“java.util.Date”
import=“java.text.*”
%>
<%
Connection conn = null;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Date dataatual = new Date();
SimpleDateFormat formatadordata = new SimpleDateFormat(“dd/MM/yyyy”);
SimpleDateFormat mesano = new SimpleDateFormat(“MM/yyyy”);
SimpleDateFormat formatadorhora = new SimpleDateFormat(“hh:mm:ss”);
DecimalFormat formatadorNum = new DecimalFormat();
formatadorNum.setMinimumFractionDigits(2);
String rep = new String();
String data = new String();
rep = request.getParameter(“rep”);
data = request.getParameter(“data”);
conn = DriverManager.getConnection(“jdbc:oracle:oci8:@ORACLE”,“EMP”,“CONTROL”);
Statement stmt = null;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(“select PEDVADM2.CODREP, SYSREPCR.NOMREP, "
+“sum(PEDVADM2.QTDE) QTDE, "
+“nvl(max(decode(to_char(DATAPED,‘mm’),‘01’,planejarep.DESAFIO1, "
+”‘02’,planejarep.DESAFIO2, "
+”‘03’,planejarep.DESAFIO3, "
+”‘04’,planejarep.DESAFIO4, "
+"‘05’,planejarep.DESAFIO5, "
+"‘06’,planejarep.DESAFIO6, "
+"‘07’,planejarep.DESAFIO7, "
+"‘08’,planejarep.DESAFIO8, "
+"‘09’,planejarep.DESAFIO9, "
+"‘10’,planejarep.DESAFIO10, "
+"‘11’,planejarep.DESAFIO11, "
+"‘12’,planejarep.DESAFIO12)),0) DESAFIOMES, "
+“nvl(max(decode(to_char(DATAPED,‘mm’),‘01’,planejarep.DIAS1, "
+”‘02’,planejarep.DIAS2, "
+"‘03’,planejarep.DIAS3, "
+"‘04’,planejarep.DIAS4, "
+"‘05’,planejarep.DIAS5, "
+"‘06’,planejarep.DIAS6, "
+"‘07’,planejarep.DIAS7, "
+"‘08’,planejarep.DIAS8, "
+"‘09’,planejarep.DIAS9, "
+"‘10’,planejarep.DIAS10, "
+"‘11’,planejarep.DIAS11, "
+"‘12’,planejarep.DIAS12)),0) DIASUTEIS "
+"from pedvadm2, sysrepcr, planejarep "
+"where "
+“DATAPED between '01/” + mesano.format(formatadordata.parse(data)) + “’ and '” + formatadordata.format(formatadordata.parse(data)) + "’ and "
+“pedvadm2.CODREP between " +rep+ " and " +rep+” and "
+"pedvadm2.posicao in (‘ABERTO’,‘PRODUCAO’,‘FATURADO’) and "
+"pedvadm2.codrep = sysrepcr.codrep (+) and "
+"pedvadm2.codrep = planejarep.codrep(+) and "
+"planejarep.ano = " + (new SimpleDateFormat(“yyyy”)).format(formatadordata.parse(data)) + " "
+“group by pedvadm2.codrep,sysrepcr.nomrep”);
%>
