You are here: Wiki-SL>Sandbox Web>TWikiUsers?>RogerioRibeiro>CodigoFonteCadastro (08 Aug 2006, RogerioRibeiro)EditAttach
Codigo Fonte Cadastro
Pessoa
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Tabela Usuário</title>
<script language="Javascript">
function enviar(par){
if (par == 'cadastrar'){
if (document.cadastro.nomeField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Nome';
}else if(document.cadastro.dddField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo DDD';
}else if(document.cadastro.foneField.value== ''){
document.cadastro.statusField.value = 'Preecha o campo Fone';
}else {
document.cadastro.action='cadastrar.jsp';
document.cadastro.submit();
}
}else if (par == 'consultar'){
if (document.cadastro.idusuarioField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Código';
}else{
document.cadastro.action='consultar.jsp';
document.cadastro.submit();
}
}else if(par == 'alterar'){
if (document.cadastro.idusuarioField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Código'
} else if (document.cadastro.nomeField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Nome';
} else if (document.cadastro.dddField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo DDD';
} else if (document.cadastro.foneField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Fone';
} else if (document.cadastro.sexoField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Sexo';
} else {
document.cadastro.action='alterar.jsp';
document.cadastro.submit();
}
}else if (par == 'excluir'){
if (document.cadastro.idusuarioField.value == ''){
document.cadastro.statusField.value = 'Preecha o campo Código';
}else{
document.cadastro.action='excluir.jsp';
document.cadastro.submit();
}
}else if (par == 'listar'){
document.cadastro.action='listar.jsp';
document.cadastro.submit();
}
}
</script>
</head>
<%
String idusuario = request.getParameter("idusuario");
String nome = request.getParameter("nome");
String ddd = request.getParameter("ddd");
String fone = request.getParameter("fone");
String sexo = "";
if (request.getParameter("sexo") != null){
sexo =request.getParameter("sexo"); }
String status = request.getParameter("status");
%>
<body>
<form name="cadastro" method="get">
<table border="0" width="472">
<tr>
<td width="458" height="70" bgcolor="#6699F" >
<p align="left"> <h1>Cadastro usuario</h1> </p>
</td>
</tr>
<tr>
<td height="177" bgcolor="#6699F">
<p> <b>Cod:</b>
<input name="idusuarioField" type="text" id="idusuarioField" size="3" value="<%=(idusuario==null)?"":idusuario%>">
<b>Nome:</b>
<input name="nomeField" type="text" id="nomeField" size="40" value="<%=(nome==null)?"":nome%>">
</p>
<p> <b>DDD:</b>
<input name="dddField" type="text" id="dddField" size="3" value="<%=(ddd==null)?"":ddd%>">
<b>Fone:</b>
<input name="foneField" type="text" id="foneField" size="11" value="<%=(fone==null)?"":fone%>"> <br>
</p>
<p> <b>Sexo:</b>
<input type="radio" name="sexo" value="M"
<%=sexo.equals("M")?"checked=\"checked\"":""%> /> Masculino
<input type="radio" name="sexo" value="F"
<%=sexo.equals("F")?"checked=\"checked\"":""%> /> Feminino
</p>
</td>
</tr>
<tr>
<td height="101" bgcolor="#6699F"> <p>
<input type="button" onClick="enviar('cadastrar')" name="bt1" value="cadastrar">
<input type="button" onClick="enviar('consultar')" name="bt2" value="consultar">
<input type="button" onClick="enviar('alterar')" name="bt3" value="alterar">
<input type="button" onClick="enviar('excluir')" name="bt4" value="excluir">
<input type="button" onClick="enviar('listar')" name="bt5" value="listar">
</p>
<p> <b>Status:
<input name="statusField" type="text" id="statusField" disabled size="46"
value="<%=(status==null)?"":status%>"></b>
</p>
</td>
</tr>
</table>
</form>
</body>
</html>
Cadastrar
<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="con" class="conexao.Conexao"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Cadastrar Usuários</title>
</head>
<body>
<form name="form1" method="post" action="pessoa.jsp">
<p><b> Usuários Cadastrados </b></p>
<table border="1" cellspacing=0 cellpadding=0 >
<tr>
<td width="50"> <b> Codigo </b> </td>
<td width="200"> <b> Nome </b> </td>
<td width="50"> <b> DDD </b> </td>
<td width="100"> <b> Fone </b> </td>
</tr>
<%
try{
con.setNome(request.getParameter("nomeField"));
con.setDdd(request.getParameter("dddField"));
con.setFone(request.getParameter("foneField"));
con.setSexo(request.getParameter("sexoField"));
out.print(request.getParameter("sexoField"));
con.setConsulta();
ResultSet temp = con.getResultado();
temp.next();
if (request.getParameter("nomeField").equals(temp.getString("nome"))){
response.sendRedirect("http://localhost:8080/UsuarioWeb/pessoa.jsp?status=Registro já existente");
}else{con.inserirDados();}
do{
%>
<tr>
<td width="50"> <%out.print(temp.getString("id_usuario"));%> </td>
<td width="200"><%out.print(temp.getString("nome"));%> </td>
<td width="50"> <%out.print(temp.getString("ddd"));%> </td>
<td width="100"><%out.print(temp.getString("fone"));%> </td>
<td width="50"><%out.print(temp.getString("sexo"));%> </td>
</tr>
<%
}while (temp.next());
}catch(Exception e){
e.printStackTrace();
}
%>
</table>
<p> </p>
<p><input type="submit" name="Submit" value="voltar"></p>
<p><b>Status:
<input name="statusField" disable type="text" id="statusField" size="50"
value="<%=request.getParameter("nomeField")%> foi cadastrado com sucesso">
</b></p>
</form>
</body>
</html>
Consultar
<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="con" class="conexao.Conexao"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head> <title>Consulta de usuários</title> </head>
<body>
<form method="get">
<%
con.setIdUsuario(Integer.parseInt(request.getParameter("idusuarioField")));
boolean testa = con.consultarDados();
if (testa)
{
ResultSet temp = con.getResultado();
response.sendRedirect("http://localhost:8080/UsuarioWeb/pessoa.jsp?"+
"status=Consulta efetuada com sucesso &nome="+temp.getString("nome")+"&ddd="+
temp.getString("ddd")+"&fone="+temp.getString("fone")+"&idusuario="+temp.getString("id_usuario")+
"&sexo="+temp.getString("sexo"));
}else{
response.sendRedirect("http://localhost:8080/UsuarioWeb/pessoa.jsp?status=Registro não encontrado");
}
%>
</form>
</body>
</html>
Excluir
<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="con" class="conexao.Conexao" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head> <title>Exclusão de Usuários </title> </head>
<body>
<form name="form1" method="post" action="pessoa.jsp">
<p><b> Tabela de Usuários </b> </p>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="50"><b>Codigo</b></td>
<td width="200"><b>Nome</b></td>
<td width="50"><b>DDD</b></td>
<td width="100"><b>Fone</b></td>
</tr>
<%
try{
con.setIdUsuario(Integer.parseInt(request.getParameter("idusuarioField")));
if (con.excluirDados()){
con.setConsulta();
ResultSet temp = con.getResultado();
while(temp.next()){
%>
<tr>
<td width="50"><%out.print(temp.getString("id_usuario"));%> </td>
<td width="200"><%out.print(temp.getString("nome"));%> </td>
<td width="50"><%out.print(temp.getString("ddd"));%> </td>
<td width="100"><%out.print(temp.getString("fone"));%> </td>
</tr>
<%
}
}else{
response.sendRedirect("http://localhost:8080/UsuarioWeb/pessoa.jsp?status=Registro noo encontrado");
}
}catch(Exception e){e.printStackTrace();}
%>
</table>
<p> </p>
<p><input type="submit" name="Submit" value="voltar"></p>
<p><b>Status
<input type="text" name="statusField" disable size="50"
value="<%=request.getParameter("nomeField")%> foi excluido com sucesso"> </b>
</p>
</form>
</body>
</html>
Listar
<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="UTF-8"%>
<jsp:useBean id="con" class="conexao.Conexao"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><title>Listagem de usuários</title></head>
<body>
<form name="form1" method="post" action="pessoa.jsp">
<p><b>Tabela de Usuarios</b></p>
<table cellpadding="0" cellspacing="0" border="1">
<tr>
<td width="50"> <b>Codigo </b></td>
<td width="200"><b>Nome </b></td>
<td width="50"> <b>DDD </b></td>
<td width="100"><b>Fone </b></td>
<td width="50"> <b>Sexo </b></td>
</tr>
<%
try{
con.setConsulta();
ResultSet temp = con.getResultado();
while(temp.next()){
%>
<tr>
<td width="50"><%out.print(temp.getString("id_usuario"));%></td>
<td width="200"><%out.print(temp.getString("nome"));%> </td>
<td width="50"><%out.print(temp.getString("ddd"));%> </td>
<td width="100"><%out.print(temp.getString("fone"));%> </td>
<td width="50"><%out.print(temp.getString("sexo"));%> </td>
</tr>
<%
}
}catch(Exception e){e.printStackTrace();}
%>
</table>
<p> <input type="submit" name="Submit" value="voltar"> </p>
</form>
</body>
</html>
Alterar
<%@ page language="java" import="java.util.*" import="java.sql.*"pageEncoding="UTF-8"%>
<jsp:useBean id="con" class="conexao.Conexao"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Alteração de usuários</title>
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form name="form1" method="post" action="pessoa.jsp">
<%con.setIdUsuario(Integer.parseInt(request.getParameter("idusuarioField")));%>
<%con.setSexo(request.getParameter("sexoField"));%>
<jsp:setProperty name="con" property="nome" value="<%=request.getParameter("nomeField")%>"/>
<jsp:setProperty name="con" property="ddd" value="<%=request.getParameter("dddField")%>"/>
<jsp:setProperty name="con" property="fone" value="<%=request.getParameter("foneField")%>"/>
<p> <b> Tabela de Usuários </b> </p>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="50" ><b>Codigo </b></td>
<td width="200"><b>Nome </b></td>
<td width="50"> <b>DDD </b></td>
<td width="100"><b>Fone </b></td>
<td width="50"> <b>Sexo </b></td>
</tr>
<%
try{
boolean testa = con.alterarDados();
out.print("xxxx"+request.getParameter("sexoField"));
if (con.alterarDados()){
con.setConsulta();
ResultSet temp = con.getResultado();
while (temp.next()){
%>
<tr>
<td width="50"> <%out.print(temp.getString("id_usuario"));%></td>
<td width="200"> <%out.print(temp.getString("nome"));%> </td>
<td width="50"> <%out.print(temp.getString("ddd"));%> </td>
<td width="100"> <%out.print(temp.getString("fone"));%> </td>
<td width="50"> <%out.print(temp.getString("sexo"));%> </td>
</tr>
<%
}
}else{
response.sendRedirect("http://localhost:8080/UsuarioWeb/pessoa.jsp?status=Registro não encontrado");
}
}catch(Exception e){
e.printStackTrace();
}
%>
</table>
<p> <input type="submit" name="Submit" value="voltar"> </p>
<p> <b> Status:
<input name="statusField" disable type="text" id="statusField" size="50"
value="<%=request.getParameter("nomeField")%> foi alterado com sucesso">
</b></p>
</form>
</body>
</html>
-- RogerioRibeiro - 29 May 2006
-- RogerioRibeiro - 08 Aug 2006 Edit | Attach | Print version | History: r1 | Backlinks | Raw View | More topic actions
Topic revision: r1 - 08 Aug 2006 - 16:00:50 - RogerioRibeiro
Create New Topic
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences- Webs
-
Amadeu
- Anapolivre
- ArquivoLivre
- Arte
- BahiaSocial
- BeaBa
- BibliotecaLivre
- Blogs
- BrasilDigital
- BrasilELivre
- BSM
- Ccsa
- CESL
- CoberturaWiki
- Cooperativas
- Curriculo
- DarvinMarosin
- DiaD
- Dinamicoop
- Economia
- EconomiaSolidaria
- EducacaoLivre
- Ekaaty
- Emacsbr
- ENSL
- Fatos
- Festival3
- Festival4
- Flisol
- Fmpb
- Formatos
- Foswikibr
- FSM2005
- GNOMEBR
- GTTemario2004
- GTWeb
- Guialivre
- HDC
- Incubus
- InkscapeBrasil
- Jogos
- KdeBR
- KSP
- LGM
- LinuxStokDoc
- Livros
- Main
- Mentores
- MHHOB
- MinuanoDigital
- MoradiaECidadania
- OlhosDagua
- Olimpo
- OLPC
- OOPTQ
- Papers
- PCLivre
- PentahoBrasil
- Pessoas
- Portal
- Prefeituras
- PSLAL
- PSLBA
- PSLBancarios
- PSLBrasil
- PSLGO
- PSLMA
- PSLMG
- PSLMIP
- PSLMT
- PSLMulheres
- PSLPI
- PubFisl10
- PubFisl7
- PubFisl8
- PubFisl9
- QuilomboDoSopapo
- RadioSL
- RedeMesh
- RedePopular
- RobotWars
- Sandbox
- Saudelivre
- Scribus
- Sementes
- Shakya
- SLRJ
- SoftwareLivreIrece
- SoftwareLivreVS
- SoLiSC
- SuporteLivre
- System
- Telecentros
- TeseSA
- TextoLivre
- TV
- TWikiBar
- TWikiPtbr
- UNELivre
- UNIMIX
- VilaTorres
- WebNordeste
- WTRD2004
 |
|
Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding Wiki-SL? Send feedback