primero nos conectamos:
-----------------------------------------------------------
<%@page import ="java.io.*"%>
<%@ page import="java.sql.*"%>
<%
Connection con=null;
String aUrl="jdbc:oracle:thin:@atlord08.geips.ge.com:1521:atlord08 ";
String uName = "nombre";
String pWd = "password";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(aUrl,uName,pWd);
if(con!=null)
{
}
else
{
out.println("Failure connecting to the database, please try again later");
}
}
catch(SQLException e)
{
out.println("The connection fail, please, try again later");
}
%>
----------------------------
ahora si, hacemos lo que quieres hacer:
<select name="sltname" size="10" id = "sltname" style= "WIDTH: 200px; HEIGHT: 150px">
<option selected>Select Name</option>
<%
Statement stmtname = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String sklname = "select apodo from nombre_de_tabla'";
ResultSet rsname = stmtname.executeQuery(sklname);
while (rsname.next())
{
DBname=rsname.getString("name");
out.println("<option>"+DBname+"</option>");
}
%>
</select>
------------------------------
suerte
=)
JJ