plz help, how to get the correct ID from DB ?
hi guys, maybe you can help me a little, i need to get the correct
"ID" from my database in this place:
"<a href=get.jsp?id=" + ???????"ID"???????? + ">""
but i don't know how to retrieve from db in the correct way, this "ID"
must be unite with "iten.next()". Because every "iten.next()" item
will be the link using the correct "ID" frob database, thanks in
advanced
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.util.Arrays;
import java.util.*;
public class array extends HttpServlet
{
public void doGet (HttpServletRequest request, HttpServletResponse
response) throws IOException, ServletException
{
String loginUser = "user";
String loginPasswd = "password";
String loginUrl = "jdbc:mysql://localhost:3306/db";
response.setContentType("text/html");
StringBuffer htmlResult = new StringBuffer();
PrintWriter out = response.getWriter();
out.println("<table border=0 >" );
try{
Class.forName("com.mysql.jdbc.Driver");
Connection dbcon = DriverManager.getConnection(loginUrl, loginUser,
loginPasswd);
Statement statement = dbcon.createStatement();
String query = "SELECT * FROM table";
ResultSet rs = statement.executeQuery(query);
ArrayList id = new ArrayList();
ArrayList en = new ArrayList();
ArrayList ge = new ArrayList();
while( rs.next() )
{
id.add( rs.getString("id"));
en.add( rs.getString("en"));
ge.add( rs.getString("ge"));
}
Collections.sort(id);
Iterator itid = id.iterator();
Collections.sort(en);
Iterator iten = en.iterator();
Collections.sort(ge);
Iterator itge = ge.iterator();
while(itid.hasNext()) {
out.println("<tr><td><a href=get.jsp?id=" + ????????"ID"??????? + ">"
+ iten.next()+ "</td>" +
" <td><a href=get.jsp?id=" + ????????"ID"??????? + ">"
+ itge.next()+ "</td>" );}
}
catch(Exception ex){}
}
}