import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
* Semplice query con modulo DBMS e utilizzo dei bean
*
* @author Mirko Manea & Roberto Posenato
*/
public class QueryDBMS extends HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
PrintWriter out = response.getWriter();
String nome, citta;
//DA COMPLETARE!
nome = ???
citta = ???
response.setContentType("text/html; charset=ISO-8859-1");
out.println("");
out.println("");
out.println("");
out.println("Museo (COPIATA!)");
out.println("");
out.println("");
out.println("Museo
");
try {
DBMS dbms = new DBMS();
MuseoBean museo = new MuseoBean();
//DA COMPLETARE!!!
museo = dbms.getMuseo(nome, citta);
out.println("");
out.println("Nome: "+museo.getNome());
out.println("
");
out.println("Citta: "+museo.getCitta());
out.println("
");
//DA COMPLETARE
out.println("
");
out.println("
");
} catch (UnknownKeyDBMSException ukde) {
log("Nome "+nome+" non trovato!: "+ukde.getMessage());
} catch (DBMSException dbmse) {
log("Errore verso il database: "+dbmse.getMessage());
}
out.println("");
out.println("");
}
}