olá amigos,
estou com um probleminha na minha consulta no banco mysql…
ele nao da erro mas nao mostra os dados pesquisado…
o que sera q pode ser?
<html>
<head>
<title></title>
<link rel=STYLESHEET href="estilo.css" type="text/css">
</head>
<body>
<form method="POST" action="relatorio.jsp" name="consulta">
<table border="0" align="">
<tr>
<td class="update">Codigo</td>
<td><input type="text" name="relatorio" class="char"></td>
<td><input type="submit" name="buscar" value="Pesquisar" class="botao"></td>
</tr>
</table>
<table align="center" border="0" class="">
<tr class="header">
<td><b>Nome</b></td><td><b>Sobrenome</b></td><td><b>Telefone</b></td>
</tr>
<tr>
<%@page import="java.sql.*"%>
<%
String url = "jdbc:mysql://localhost/reg";
Connection con = null;
Statement stm = null;
ResultSet res = null;
String query = "";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection(url, "root", "");
stm = con.createStatement();
res = stm.executeQuery("SELECT * FROM registro" +
" WHERE xnome LIKE '%"+ request.getParameter("xnome") +"%'" +
"ORDER BY xnome");
while(res.next())
{
out.println("<td>"+res.getString("xnome")+"</td>");
out.println("<td>"+res.getString("xsobrenome")+"</td>");
out.println("<td>"+res.getString("tel")+"</td>");
}
res.close();
%>
</tr>
</table>
</form>
</body>
</html>