Ae galera… tenho esta .jsp e não estou conseguindo o resultado esperado ! creio eu q seja a lógica !!!
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<%@page import="br.com.jpessoa.conexao.Conexao"%>
<%@ include file="../../jsp/config.jsp"%>
<%
String login = (String)session.getAttribute("login_usuario");
PreparedStatement pstmt;
ResultSet rs;
String vs_empresa = (String)request.getParameter("vs_empresa");
String vs_plano = (String)request.getParameter("vs_plano");
String vs_orcamento = (String)request.getParameter("vs_orcamento");
String vs_versao = (String)request.getParameter("vs_versao");
String vs_periodo = (String)request.getParameter("vs_periodo");
String vs_tipo = (String)request.getParameter("vs_tipo");
System.out.println(vs_empresa);
String focus = "";
if(vs_empresa == null || vs_empresa.equals("")){
focus = "parametro_quadro.vs_empresa";
}else if(vs_plano == null || vs_plano.equals("")){
focus = "parametro_quadro.vs_plano";
}else if(vs_orcamento == null || vs_orcamento.equals("")){
focus = "parametro_quadro.vs_orcamento";
}else if(vs_versao == null || vs_versao.equals("")){
focus = "parametro_quadro.vs_versao";
}else if(vs_periodo == null || vs_periodo.equals("")){
focus = "parametro_quadro.vs_perido";
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title></title>
<link href="<%=urlBase%>css/Padroes.css" type=text/css rel=stylesheet>
<link href="<%=urlBase%>css/rt.css" type=text/css rel=stylesheet>
<script language="JavaScript" src="<%=urlBase%>js/ts_picker.js">
</script>
<script type="text/javascript">
function Window(mypage, myname, w, h, scroll) {
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+''
win = window.open(mypage, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) {
win.window.focus(); }
}
function Window_Empresa(mypage, myname, w, h, scroll) {
var frm = document.parametro;
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+''
win = window.open(mypage + frm.vs_empresa.value, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) {
win.window.focus(); }
}
function submit(){
var url = 'comparativo_previsto_real_result.jsp? vs_empresa='+window.document.parametro.vs_empresa.value+'&vs_plano='+window.document.parametro.vs_plano.value+'&vs_orcamento='+window.document.parametro.vs_orcamento.value+'&vs_versao='+window.document.parametro.vs_versao.value+'&vs_periodo='+window.document.parametro.vs_periodo.value+'&vs_tipo='+window.document.parametro.vs_tipo.value+'&vs_area='+window.document.parametro.vs_area.value+'&vs_pdf_html='+window.document.parametro.vs_pdf_html.value;
window.document.parametro.action = url;
window.document.parametro.submit();
}
function submit_quadro(){
document.parametro_quadro.submit();
}
function formataCampoRef(componente, texto){
if(texto.length == 2){
texto += "/";
}
componente.value = texto;
}
function formataCampoDt(componente, texto){
if(texto.length == 2){
texto += "/";
}
if(texto.length == 5){
texto += "/";
}
componente.value = texto;
}
function Conta_Contabil(mypage, myname, w, h, scroll) {
var frm = document.parametro;
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+''
win = window.open(mypage + frm.vs_tipo_conciliacao.value, myname, winprops)
if (parseInt(navigator.appVersion) >= 4) {
win.window.focus(); }
}
</script>
</head>
<body leftmargin=0 rightmargin=0 topmargin=50 bottommargin=0 onload="document.<%=focus%>.focus();">
<center>
<form method="post" name="parametro_quadro">
<table cellSpacing=0 cellPadding=0 width="500" border=0>
<tr>
<td align=right width="68%"> </td>
<td align=right width="7%"> </td>
<td class=tituloMaior noWrap align=left width="25%">
<img > Parâmetros
</td>
</tr>
<tr>
<td bgColor=#ffcc99><img ></td>
<td bgColor=#ffcc99><img ></td>
<td><img ></td>
</tr>
<tr>
<td class=fundo vAlign=bottom noWrap align=left background="<%=urlBase%>imagens/sec_fundo_linha_verde.jpg" rowspan=2>
<span class=titulo>Comparativo Previsto/Real</span>
</td>
<td vAlign=bottom width="7%" rowspan=2><img ></td>
<td width="25%"> </td>
</tr>
<tr>
<td bgColor=#478C3E><img ></td>
</tr>
<tr>
<td colspan=3><img ></td>
</tr>
<tr>
<td></td><td><img ></td><td></td>
</tr>
<tr>
<td align=middle colspan=3><img ></td>
</tr>
<tr>
<td colspan=3><img ></td>
</tr>
</table>
<table cellSpacing=0 cellPadding=0 width="500" border=0>
<tr bgColor=#478C3E>
<td vAlign=top align=left width="50%"><img ></td>
<td vAlign=top align=right width="50%"><img ></td>
</tr>
</table>
<table class=texto width="500" bgColor=#E6FAE4 border=0>
<tr>
<td width="1%"> </td>
<td width="19%"> </td>
<td width="76%"> </td>
<td width="4%"> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Empresa :</td>
<td>
<select name="vs_empresa" class="fundoVerde" onchange="javascript:submit_quadro();">
<%if(vs_empresa == null || vs_empresa.equals("")){%>
<option value="0" selected="selected" class="Linha_Tabela"> </option>
<%}%>
<%
try {
Conexao.getConexao();
pstmt = Conexao.getConn().prepareStatement(sql_empresa);
pstmt.setString(1, login);
rs = pstmt.executeQuery();
while (rs.next()) {
%>
<option value="<%=rs.getString("cod_empresa")%>" class="Linha_Tabela">
<%=rs.getString("cod_empresa") + " - " + rs.getString("nome_empresa")%>
</option>
<%
}
rs.close();
}catch(SQLException e){
out.println(e.toString());
}
%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Planos :</td>
<td>
<select name="vs_plano" class="fundoVerde" onchange="javascript:submit_quadro();">
<%
try {
pstmt = Conexao.getConn().prepareStatement(" select p.codigo from siagri.orca_planos p where p.planta = ? ");
pstmt.setString(1, vs_empresa);
rs = pstmt.executeQuery();
while (rs.next()) {
%>
<option value="<%=rs.getString("codigo")%>" class="Linha_Tabela">
<%=rs.getString("codigo")%>
</option>
<%
}
rs.close();
}catch(SQLException e){
out.println(e.toString());
}
%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Orçamento :</td>
<td>
<select name="vs_orcamento" class="fundoVerde" onchange="javascript:submit_quadro();">
<%
try {
pstmt = Conexao.getConn().prepareStatement(" select o.codigo from siagri.orca_mentos o where o.planta = ? and o.codigo_plan = ? ");
pstmt.setString(1, vs_empresa);
pstmt.setString(2, vs_plano);
rs = pstmt.executeQuery();
while (rs.next()) {
%>
<option value="<%=rs.getString("codigo")%>" class="Linha_Tabela">
<%=rs.getString("codigo")%>
</option>
<%
}
rs.close();
}catch(SQLException e){
out.println(e.toString());
}
%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Versão :</td>
<td>
<select name="vs_versao" class="fundoVerde" onchange="javascript:submit_quadro();">
<%
try {
pstmt = Conexao.getConn().prepareStatement(" select v.codigo from siagri.orca_version v where v.planta = ? and v.codigo_plan = ? and v.codigo_o = ? ");
pstmt.setString(1, vs_empresa);
pstmt.setString(2, vs_plano);
pstmt.setString(3, vs_orcamento);
rs = pstmt.executeQuery();
while (rs.next()) {
%>
<option value="<%=rs.getString("codigo")%>" class="Linha_Tabela">
<%=rs.getString("codigo")%>
</option>
<%
}
rs.close();
}catch(SQLException e){
out.println(e.toString());
}
%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Periodo :</td>
<td>
<select name="vs_periodo" class="fundoVerde" onchange="javascript:submit_quadro();">
<option value="0" selected="selected" class="Linha_Tabela">Todos</option>
<%
try {
pstmt = Conexao.getConn().prepareStatement(" select pe.codigo from siagri.orca_periodos pe where pe.planta = ? and pe.codigo_plan = ? and pe.codigo_o = ? ");
pstmt.setString(1, vs_empresa);
pstmt.setString(2, vs_plano);
pstmt.setString(3, vs_orcamento);
rs = pstmt.executeQuery();
while (rs.next()) {
%>
<option value="<%=rs.getString("codigo")%>" class="Linha_Tabela">
<%=rs.getString("codigo")%>
</option>
<%
}
rs.close();
}catch(SQLException e){
out.println(e.toString());
}
%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto>Tipo :</td>
<td>
<input name="vs_tipo" checked value="1" type="radio" class="texto">
<span class="texto">Processos</span>
<br>
<input name="vs_tipo" value="1" type="radio" class="texto">
<span class="texto">Despesas</span>
<br>
<input name="vs_tipo" value="1" type="radio" class="texto">
<span class="texto">Atividades</span>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Área :</td>
<td>
<select name="vs_area" class="fundoVerde">
<option value="0" selected="selected" class="Linha_Tabela">Todos</option>
<%
try {
pstmt = Conexao.getConn().prepareStatement(" select c.codigo, c.nome from siagri.ccusto c where (length(c.codigo)= 1 or c.codigo = 6666) ");
rs = pstmt.executeQuery();
while (rs.next()) {
%>
<option value="<%=rs.getString("codigo")%>" class="Linha_Tabela">
<%=rs.getString("codigo") + " - " + rs.getString("nome")%>
</option>
<%
}
rs.close();
}catch(SQLException e){
out.println(e.toString());
}
%>
</select>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class=texto noWrap>Formato :</td>
<td>
<input name="vs_pdf_html" checked value="1" type="radio" class="texto">
<span class="texto">PDF</span>
<input name="vs_pdf_html" value="2" type="radio" class="texto">
<span class="texto">HTML</span>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td style="COLOR: #ff0000" colspan=2></td>
</tr>
</table>
<table width="500">
<tr><td> </td></tr>
<tr>
<td align=middle>
<a ><img ></a>
<a ><img ></a>
</td>
</tr>
<tr>
<td class=texto align=middle>
Copyright® 2001 - 2006<BR>Todos os direitos reservados
</td>
</tr>
</table>
</form>
</center>
<%
Conexao.close();
%>
</body>
</html>
eu quero que conforme o usuário selecione a empresa … ele rode o próx. select q usa a planta como parametro e me traga o valor no próx combo … !!!
se alguém puder me ajudar ficaria mto grato !!!
Att,
André Hebeler.