Codice: Seleziona tutto
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
import java.io.*;
public class Index extends HttpServlet {
public void doGet (HttpServletRequest req, HttpServletResponse res) throws IOException {
Connection con;
Statement st;
ResultSet rs1, rs2, rs3;
String queryAutor,queryReferencia,queryTitulo;
PrintWriter out;
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e) {
System.out.println("Error driver");
System.exit(0);
}
try {
con=DriverManager.getConnection("jdbc:mysql://localhost/mydb" , "root" ,"");
st=con.createStatement();
queryAutor= "SELECT apellido AS Autor FROM autores ORDER BY Autor";
rs1= st.executeQuery(queryAutor);
queryReferencia= "SELECT idLibro AS Referencia FROM libros ORDER BY idLibro ASC";
rs2= st.executeQuery(queryReferencia);
queryTitulo= "SELECT titulo FROM libros ORDER BY titulo";
rs3= st.executeQuery(queryTitulo);
out= res.getWriter();
res.setContentType("text/html");
//out.println("<HTML><BODY>HOOOOOLA</BODY></HTML>");
out.println("<HTML><BODY>Listado libros ordenados por:<BR><form><select>");
while(rs1.next()) {
out.println("<option value= \"autor\">" +rs1.getString("Autor")+ "</option>");
}
while(rs2.next()) {
out.println("<option value= \"referencia\">" +rs2.getString("Referencia")+ "</option>");
}
while(rs3.next()) {
out.println("<option value= \"titulo\">" +rs3.getString("Titulo")+ "</option></select><BR><BR>");
}
out.println("<input type=\"submit\"></form>");
rs1.close();
rs2.close();
rs3.close();
out.close();
st.close();
con.close();
}
catch(Exception e) {
System.out.println("Error");
System.exit(0);}
}
}
