Only for one data in the text box

Jul 08, 2011 18:41:33

Good Night

I have a problem with this jsp with mysql

The idea is when I put a number in the text box the console have to show all the data of that number "ID".

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>BOOKS</title>
</head>
<body>
<h1>I FOUND THIS</h1>
<%
String codigo=new String("");
try {
/* Here machine name id localhost and
database name. */
String connectionURL = "jdbc:mysql://localhost:3306/publish";
// conexion
Connection connection = null;
/* Statement*/
Statement statement = null;
// resultset
ResultSet rs = null;
// Driver
Class.forName("com.mysql.jdbc.Driver").newInstance();
/* Create a connection by using getConnection() method that takes parameters
of string type connection url, user name and password to connect to database.*/
connection = DriverManager.getConnection(connectionURL, "root", "ZEN");
/* createStatement() is used for create statement object that is used for
sending sql statements to the specified database. */
statement = connection.createStatement();
String QueryString = "SELECT * FROM book WHERE id="'+id'";
rs = statement.executeQuery(QueryString);
%>
<table cellpadding="15" border="1">
<%
while (rs.next()) {
%>
<tr>
<td><%=codigo=rs.getString("id")%></td>
</tr>
<% } %>
<%
// cierre de conexiones.
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
%>
</font>
<font size="+3" color="red"></b>
<%
if(codigo.equals(request.getParameter("id"))){
}else{
out.println("ERROR. ID NOT FOUND .");
}
}
%>
</table><table>
<tr>
<td><form action="books.jsp" method="get" >
<button type="submit"><-- RETURN</button></td>
</tr>
</table>
</font>
</body>
</html>

All data I need is the only one that I put in the text box not all the ids of the table.

My thoughts tell me here is the error , well I hope

People I need your help.

thanks.

Jul 08, 2011 19:20:24

Step 1 is to refactor and to move all that Java code out of the JSp and into a servlet and other Java classes where it belongs. Java code in JSP pages has been discredited for almost ten years now. Time to modernize your JSP knowledge.

Acetylsalicylic acid is aspirin. This could be handy too:

a bit of art, as a gift, that will fit in a stocking

https://gardener-gift.com