ta aih um exemplo, usando access.
se encontrar algo com my sql ou oracle me passa ?
valeu !
At 15:58 03/03/00 -0300, you wrote:
>Ola
>
>aproveitando a onda do email anterior, alguem tem um exemplo de acesso a BD
>atraves de servlets?? Se o BD for o Mysql ou Msql seria melhor ainda... :)
>
>abraco
>
>Luis
>
>=================
>Luis Henrique Bogo
>FURB - BCC
>Turma 96/01
>=================
>"Eh muito melhor ter ousadia para feitos poderosos, conquistar triunfos
>gloriosos, mesmo arriscando-se a fracassar, do que cerrar fileiras ao
>lado de espihritos pobres que nao gozam nem sofrem, porque vivem em um
>eterno crepuhsculo, sem conhecer a vitohria ou a derrota." - Roosevelt
>
>
>
>
>
> --------------------------- LISTA SOUJAVA ---------------------------
> http://www.soujava.org.br - Sociedade de Usu�rios Java da Sucesu-SP
> [d�vidas mais comuns: http://www.soujava.org.br/faq.htm]
> [para sair da lista: http://www.soujava.org.br/forum/cadastrados.htm]
> ---------------------------------------------------------------------
>
>
<%@ page import="java.sql.*,java.util.*" session="false"%>
<%
// register JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:agendak","","");
Statement stmt;
stmt=con.createStatement();
ResultSet rs;
%>
<html>
<head>
<link rel="stylesheet" href="../css/cfmIntranet.css" type="text/css">
<title>Resultado de pesquisa para alteracao na Agenda</title>
</head>
<body bgcolor="#FF9B6A" style="font-family: Arial; font-size: 10pt">
<div align="center"><center>
<table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF">
<tr>
<td width="100%"><div align="center"><center><table border="0" cellpadding="5"
cellspacing="0" width="100%">
<tr>
<td width="78%" valign="top"><table border="0" cellpadding="5" cellspacing="0"
width="100%">
<tr>
<td width="100%" bgcolor="#BB0000"><font size="2"
color="#FFFFFF"><strong>Resultado da
Altera��o</strong></font></td>
</tr>
</table>
<table border="1" cellpadding="5" cellspacing="0" width="100%">
<tr>
<td width="100%"><%
int codigo= Integer.parseInt(request.getParameter("codigo"));
String param_nome = request.getParameter("param_nome");
String param_fone1 = request.getParameter("param_fone1");
String param_fone2 = request.getParameter("param_fone2");
String param_fone3 = request.getParameter("param_fone3");
String update = new String();
update = "UPDATE agenda "+
"SET NOME = '" + param_nome + "' "+
", FONE1 = '" + param_fone1 + "' "+
", FONE2 = '" + param_fone2 + "' "+
", FONE3 = '" + param_fone3 + "' "+
"where codigo = " + codigo;
stmt.executeUpdate(update);
%>
<p>Dados Atualizados com sucesso. </p>
<table border="0" width="100%" cellpadding="0" cellspacing="0"
bgcolor="#FFFFD9">
<tr>
<td width="100%">Nome: <font
color="#FF0000"><%=param_nome%></font><table border="1" width="100%">
<tr>
<td width="33%"><%=param_fone1%>
</td>
<td width="33%"><%=param_fone2%>
</td>
<td width="34%"><%=param_fone3%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="22%" valign="top" bgcolor="#FFFFFF"><a
href="centralAgenda.jsp"><font
face="Verdana" size="2">Central</font></a></td>
</tr>
</table>
</center></div></td>
</tr>
</table>
</center></div>
</body>
</html>
<%@ page import="java.sql.*,java.util.*" session="false"%>
<html>
<head>
<link rel="stylesheet" href="../css/cfmIntranet.css" type="text/css">
<title>Agenda Tamerico - central</title>
</head>
<body bgcolor="#FF9B6A" style="font-family: Arial; font-size: 10pt">
<p align="center"><font face="Verdana"><span
style="background-color: rgb(255,255,255); color: rgb(0,128,0)">AGENDA TAMER<br>
CENTRAL </span></font></p>
<div align="center"><center>
<table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF">
<tr>
<td width="100%"> <div align="center"><center><table border="0"
cellpadding="5"
cellspacing="0" width="100%">
<tr>
<td width="50%" valign="top"> <table border="0" cellpadding="5"
cellspacing="0"
width="100%">
<tr>
<td width="100%" bgcolor="#BB0000"><font size="2"
color="#FFFFFF"><strong>Inclus�o</strong></font></td>
</tr>
</table>
<table border="1" cellpadding="5" cellspacing="0" width="100%">
<tr>
<td width="100%"><form method="POST" action="inclusaoAgenda.jsp">
<div align="center"><center><table border="1" cellpadding="0"
cellspacing="0" width="100%">
<tr>
<td width="100%"><font face="Arial" size="2">Nome<br>
</font><input type="text" name="param_nome" size="31"><p><font
face="Arial" size="2">Telefone
1<br>
</font><input type="text" name="param_fone1" size="20"></p>
<p><font face="Arial" size="2">Telefone 2<br>
</font><input type="text" name="param_fone2" size="20"></p>
<p><font face="Arial" size="2">Telefone 3<br>
</font><input type="text" name="param_fone3" size="20"></td>
</tr>
</table>
</center></div><div align="center"><center><p><input type="submit"
value="Incluir"
name="B1"></p>
</center></div>
</form>
</td>
</tr>
</table>
</td>
<td width="25%" valign="top" bgcolor="#FFFFFF"><form method="POST"
action="pesquisaAgenda.jsp">
<p><strong>Pesquisa</strong></p>
<div align="center"><center><p><input type="text" name="par_busca"
size="20"><input
type="submit" value="Pesquisar" name="B2"></p>
</center></div>
</form>
<p> </p>
<form method="POST" action="pesquisaAlteraAgenda.jsp">
<p><strong>Alterar (Entre com nome)</strong></p>
<div align="center"><center><p><input type="text" name="par_busca"
size="20"><br>
<input type="submit" value="Alterar" name="B3"></p>
</center></div>
</form>
</td>
<td width="25%" valign="top" bgcolor="#FFFFFF"><font face="Comic Sans MS"
size="4"
color="#FF0000"><%for (int i=0 ; i<10 ; i++)
{
%> <strong>AGENDA<br>
</strong><%
}
%> </font></td>
</tr>
</table>
</center></div></td>
</tr>
</table>
</center></div>
</body>
</html>
<%@ page import="java.sql.*,java.util.*" session="false"%>
<%
// register JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:agendak","","");
Statement stmt;
stmt=con.createStatement();
ResultSet rs;
%>
<html>
<head>
<link rel="stylesheet" href="../css/cfmIntranet.css" type="text/css">
<title>Agenda Inclusao</title>
</head>
<body bgcolor="#FF9B6A" style="font-family: Arial; font-size: 10pt">
<div align="center"><center>
<table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF">
<tr>
<td width="100%"><div align="center"><center><table border="0" cellpadding="5"
cellspacing="0" width="100%">
<tr>
<td width="78%" valign="top"><table border="0" cellpadding="5" cellspacing="0"
width="100%">
<tr>
<td width="100%" bgcolor="#BB0000"><font size="2"
color="#FFFFFF"><strong>Resultado da
tentativa de Inclus�o</strong></font></td>
</tr>
</table>
<table border="1" cellpadding="5" cellspacing="0" width="100%">
<tr>
<td width="100%"><%
String param_nome = request.getParameter("param_nome");
String param_fone1 = request.getParameter("param_fone1");
String param_fone2 = request.getParameter("param_fone2");
String param_fone3 = request.getParameter("param_fone3");
String query;
query = "insert into agenda(nome,fone1,fone2,fone3)"+
" values ('"+
param_nome+
"','"+
param_fone1+
"','"+
param_fone2+
"','"+
param_fone3+
"')";
stmt.executeUpdate(query);
%>
<p><strong>Dados cadastrados com sucesso!</strong></p>
<p>Nome : <%=param_nome%></p>
<p>Telefone 1:<%=param_fone1%></p>
<p>Telefone 2:<%=param_fone2%></p>
<p>Telefone 3:<%=param_fone3%></p>
<p> </td>
</tr>
</table>
</td>
<td width="22%" valign="top" bgcolor="#FFFFFF"><a
href="centralAgenda.jsp"><font
face="Verdana" size="2">Central</font></a></td>
</tr>
</table>
</center></div></td>
</tr>
</table>
</center></div>
</body>
</html>
<%@ page import="java.sql.*,java.util.*" session="false"%>
<%
// register JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:agendak","","");
Statement stmt;
stmt=con.createStatement();
ResultSet rs;
%>
<html>
<head>
<link rel="stylesheet" href="../css/cfmIntranet.css" type="text/css">
<title>Agenda Inclusao</title>
</head>
<body bgcolor="#FF9B6A" style="font-family: Arial; font-size: 10pt">
<div align="center"><center>
<table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF">
<tr>
<td width="100%"><div align="center"><center><table border="0" cellpadding="5"
cellspacing="0" width="100%">
<tr>
<td width="78%" valign="top"><table border="0" cellpadding="5" cellspacing="0"
width="100%">
<tr>
<td width="100%" bgcolor="#BB0000"><font size="2"
color="#FFFFFF"><strong>Resultado da
pesquisa</strong></font></td>
</tr>
</table>
<table border="1" cellpadding="5" cellspacing="0" width="100%">
<tr>
<td width="100%"><%
String busca = request.getParameter("par_busca");
String query = new String();
query = "select NOME,FONE1,FONE2,FONE3 from agenda where NOME like
'%"+busca+"%'";
//query = "SELECT * FROM AGENDA";
rs=stmt.executeQuery(query);
boolean more = rs.next ();
if (!more)
{
%>
<p>Nao foi encontrado : <%=busca%></p>
<form method="POST" name="pesquisaAgenda.jsp">
<p><input type="text" name="par_busca" size="25" value="entre com nome">
<input
type="submit" value="Pesquisar" name="B1"></p>
</form>
<%
}
else
{
int cont=0;
while(more)
{
cont++;
%>
<table border="0" width="100%" cellpadding="0" cellspacing="0" <% if
((cont%2)==0)
{%>
bgcolor="#FFFFD9" <%
} else { %> bgcolor="#FFFFFF" <%}%>>
<tr>
<td width="100%">Nome: <%=rs.getString("NOME")%><table border="1"
width="100%">
<tr>
<td width="33%"><%=rs.getString("FONE1")%>
</td>
<td width="33%"><%=rs.getString("FONE2")%>
</td>
<td width="34%"><%=rs.getString("FONE3")%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p> <%
// Vai para o pr�ximo registro
more = rs.next ();
}
rs.close();
}%> </td>
</tr>
</table>
</td>
<td width="22%" valign="top" bgcolor="#FFFFFF"><a
href="centralAgenda.jsp"><font
face="Verdana" size="2">Central</font></a></td>
</tr>
</table>
</center></div></td>
</tr>
</table>
</center></div>
</body>
</html>
<%@ page import="java.sql.*,java.util.*" session="false"%>
<%
// register JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:agendak","","");
Statement stmt;
stmt=con.createStatement();
ResultSet rs;
%>
<html>
<head>
<link rel="stylesheet" href="../css/cfmIntranet.css" type="text/css">
<title>Resultado de pesquisa para alteracao na Agenda</title>
</head>
<body bgcolor="#FF9B6A" style="font-family: Arial; font-size: 10pt">
<div align="center"><center>
<table border="1" cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF">
<tr>
<td width="100%"><div align="center"><center><table border="0" cellpadding="5"
cellspacing="0" width="100%">
<tr>
<td width="78%" valign="top"><table border="0" cellpadding="5" cellspacing="0"
width="100%">
<tr>
<td width="100%" bgcolor="#BB0000"><font size="2"
color="#FFFFFF"><strong>Resultado de
pesquisa para Altera��o</strong></font></td>
</tr>
</table>
<table border="1" cellpadding="5" cellspacing="0" width="100%">
<tr>
<td width="100%"><form method="POST" name="pesquisaAlteraAgenda.jsp">
<p><input type="text" name="par_busca" size="25" value="entre com nome">
<input
type="submit" value="Pesquisar" name="B1"></p>
</form>
<% String busca = request.getParameter("par_busca");
boolean more;
String nao = new String();
String query;
nao = "Busca sem sucesso. Procure novamente.";
query= "Select codigo,NOME,FONE1,FONE2,FONE3 from AGENDA where
NOME like '%"+ busca+"%'";
rs = stmt.executeQuery(query);
more = rs.next();
%>
<% if(!more) {
%>
<p><font size="1"><strong><%=nao
%></strong></font><% }
else
{
int cont=0;
while(more)
{
cont++;
%></p>
<form method="POST" action="atualizaAgenda.jsp">
<input type="hidden" name="codigo"
value="<%=rs.getString("codigo")%>"><table border="0"
width="100%" cellpadding="0" cellspacing="0" <% if ((cont%2)==0)
{%> bgcolor="#FFFFD9"
<%
} else { %> bgcolor="#FFFFFF" <%}%>>
<tr>
<td width="100%">Nome: <input type="text" name="param_nome" size="33"
value="<%=rs.getString("NOME")%>">
-------------------------------<input type="submit"
value="Alterar" name="B1"><table border="1" width="100%">
<tr>
<td width="33%"><input type="text" name="param_fone1" size="14"
value="<%=rs.getString("FONE1")%>"></td>
<td width="33%"><input type="text" name="param_fone2" size="14"
value="<%=rs.getString("FONE2")%>"></td>
<td width="34%"><input type="text" name="param_fone3" size="14"
value="<%=rs.getString("FONE3")%>"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<% more=rs.next();
}
}
//}
%>
</td>
</tr>
</table>
</td>
<td width="22%" valign="top" bgcolor="#FFFFFF"><a
href="centralAgenda.jsp"><font
face="Verdana" size="2">Central</font></a></td>
</tr>
</table>
</center></div></td>
</tr>
</table>
</center></div>
</body>
</html>
________________________________________________________________________
Tamer Americo- Conselho Federal de Medicina - CFM=20
http://come.to/tamerico - [EMAIL PROTECTED] - ICQ:3221276
------------------------------------------------------------------------
