<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@
include file="ServerConfiguration.jsp"
%>
<%@
page import="org.firebirdsql.jdbc.*,org.firebirdsql.logging.Logger,java.sql.*"
%>
<%
Class.forName("org.firebirdsql.jdbc.FBDriver");
Connection aConnection = DriverManager.getConnection(DatabaseAddr,UserName, Password);
Statement stmt = aConnection.createStatement();
String Sql="Select idcidade, nomecidade from cidade order by nomecidade";
ResultSet aQuery=stmt.executeQuery(Sql);
String Sql1="Select idcidade, nomecidade from cidade order by nomecidade";
ResultSet aQuery1=stmt.executeQuery(Sql1);
%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<script language="JavaScript">
function validar_dados(){
valido = 'S';
if(document.cadastro.Nome.value == ""){
alert('teste');
document.cadastro.endereco.focus();
valido = 'N';
return false;
}
if (valido == "S"){
document.forms['cadastro'].action = "inclui.jsp";
document.forms['cadastro'].submit();
}
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Cadastro de Movimentações de Usuário</title>
</head>
<body>
<br><br>
<%-- Tipo de Movimentacao<br><select name="tpmovimetacao">
<option>1 - inclusao de Titular</option>
<option>2 - Inclusao de Dependente</option>
<option>3 - Exclusao de Titular</option>
<option>4 - Exclusao de Dependente</option>
<option>5 - Solicitacao de 2 via</option>
<option>8 - Alteracao de Dados</option>
</select> ---%>
<br><br>
<%---<form action="inclui.jsp" name="cadastro" method="post"> ----%>
<form name="cadastro" method="post">
<table border="0">
<thead>
<tr>
<th>Nome <input type="text" name="Nome" value="" SIZE=50 /></th>
<th></th>
</tr>
</thead>
<tbody>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br><br>
Tp Usuario <input type="text" name="tpusuario" value="" SIZE=2 />
<br><br>
Grupo Setor <input type="text" name="gruposetor" value="" SIZE=5/>
<br><br>
Estado
<select name="estado">
<option> AC </option>
<option> AL </option>
<option> AM </option>
<option> AP </option>
<option> BA </option>
<option> CE </option>
<option> DF </option>
<option> ES </option>
<option> GO </option>
<option> MA </option>
<option> MG </option>
<option> MS </option>
<option> MT </option>
<option> PA </option>
<option> PB </option>
<option> PE </option>
<option> PI </option>
<option> PR </option>
<option> RJ </option>
<option> RN </option>
<option> RO </option>
<option> RR </option>
<option> RS </option>
<option> SC </option>
<option> SE </option>
<option> SP </option>
<option> TO </option>
</select>
local Atendimento
<select name="atendimento">
<%
while (aQuery.next())
{
%>
<option><%=aQuery.getString("nomecidade")%></option>
<%
}
%>
</select>
<br><br>
Endereço <input type="text" name="endereco" value="" SIZE=70/>
<br><br>
Bairro <input type="text" name="bairro" value="" SIZE=40/>
<br><br>
<%---Cidade
<select name="cidade">
<%
while (aQuery1.next())
{
%>
<option><%=aQuery1.getString("nomecidade")%></option>
<%
}
%>
</select> --%>
<br><br>
Cep <input type="text" name="cep" value="" SIZE=14/>
telefone <input type="text" name="fone" value="" SIZE=14/>
cpf <input type="text" name="cpf" value="" SIZE=11/>
rg <input type="text" name="rg" value="" SIZE=12/>
<br><br>
Data Nascimento <input type="text" name="dtnascimento" value="" SIZE=12/>
Estado Civil
<select name="estadocivil">
<option> Casado </option>
<option> Solteiro </option>
<option> Divorciado </option>
<option> Viuvo </option>
</select>
<br><br>
Sexo
<select name="sexo">
<option> masculino </option>
<option> feminino </option>
</select>
cpf titular<input type="text" name="cpftitular" value="" SIZE=11/>
Nome da Mae<input type="text" name="nmae" value="" SIZE=70/>
pis<input type="text" name="pis" value="" SIZE=11/>
Data Cadastro <input type="text" name="dtcadastro" value="" SIZE=12/>
identificacao do funcionario <input type="text" name="identificacao" value="" SIZE=12/>
<br><br>
<input name='submit' type='submit' value='inclui'OnClick="validar_dados()" />
</form>
<%--
This example uses JSTL, uncomment the taglib directive above.
To test, display the page like this: index.jsp?sayHello=true&name=Murphy
--%>
<%--
<c:if test="${param.sayHello}">
<!-- Let's welcome the user ${param.name} -->
Hello ${param.name}!
</c:if>
--%>
</body>
</html>
Como eu faco para selecionar o estado no combo 1 e carregar no segundo combo apenas aquelas cidades daqueles estados??
Grato
Evandro
