I have to write a servlet that delete a coffee from a database for a
work for the certificate
degree in the Computer Science of Genoa. Instead of print a form with a
select option and four text fields the servlet prints a form with three
text fields.
I send the code.
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
public class codici extends HttpServlet
{Connection con;
Statement select;
public void init() throws ServletException
{ String url="jdbc:odbc:dbtry";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {con=DriverManager.getConnection(url,"","");
select=con.createStatement();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res) throws
ServletException,java.io.IOException
{String query="SELECT * from Caff�";
res.setContentType("text/html");
PrintWriter out=res.getWriter();
int codice=0;
String nome="";
String descr="";
int price=0;
int sales=0;
Vector cods=new Vector();
Vector nomi=new Vector();
Vector descrs=new Vector();
Vector prezzi=new Vector();
Vector vendite=new Vector();
try {ResultSet rs = select.executeQuery(query);
while (rs.next())
{codice=rs.getInt(1);
cods.add(new Integer(codice).toString());
nome=rs.getString(2);
nomi.add(nome);
descr=rs.getString(3);
descrs.add(descr);
price=rs.getInt(4);
prezzi.add(new Integer(price).toString());
sales=rs.getInt(5);
vendite.add(new Integer(sales).toString());
}
int dim=cods.size();
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>");
out.println("stampa codici");
out.println("</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<H1>");
out.println("Menu a tendina");
out.println("</H1>");
out.println("<FORM name=\"deldb\">");
out.println("<TABLE>");
out.println("<TR>");
out.println("<td>");
out.println("<strong>");
out.println("COD");
out.println("</strong>");
out.println("</td>");
out.println("<TD>");
out.println("<SELECT size=1 cols=dim name=\"codici\" onchange=\"dim = "
+dim+ ";for (var i=0;i<dim;i++) if (this.options[i].selected)
document.deldb.NOME.value=\"prova\"; \">");
for (int i=0;i<dim;i++)
{out.println("<OPTION SELECTED VALUE=nessuna selected=true>");
String info=cods.get(i).toString();
out.println("<OPTION value="+info+" >");
out.println(info);
out.println("</OPTION>");
}
out.println("</SELECT>");
out.println("</TD>");
out.println("</TR>");
out.println("<TR>");
out.println("</TR>");
out.println("<TR>");
out.println("<td>");
out.println("<strong>");
out.println("NOME");
out.println("</strong>");
out.println("</td>");
out.println("<td>");
out.println("<INPUT TYPE=\"TEXT\" NAME=\"NOME\" size=\"32\">");
out.println(" </td>");
out.println("</tr>");
out.println("<TR>");
out.println("<TD>");
out.println("<strong>");
out.println("DESCRIZIONE");
out.println("</strong>");
out.println("</td>");
out.println("<td>");
out.println("<INPUT TYPE=\"TEXT\" NAME=\"DESCRIZIONE\" size=\"32\">");
out.println(" </td>");
out.println("</tr>");
out.println("<TR>");
out.println("<TD>");
out.println("<strong>");
out.println("PREZZO");
out.println("</strong>");
out.println("</td>");
out.println("<td>");
out.println("<INPUT TYPE=\"TEXT\" NAME=\"PREZZO\" size=\"32\">");
out.println(" </td>");
out.println("</tr>");
out.println("<TR>");
out.println("<TD>");
out.println("<strong>");
out.println("TOTALE VENDITE");
out.println("</strong>");
out.println("</td>");
out.println("<td>");
out.println("<INPUT TYPE=\"TEXT\" NAME=\"TOTALE VENDITE\"
size=\"32\">");
out.println(" </td>");
out.println("</tr>");
//out.println("<TR>");
//out.println("<TD>");
out.println("</TABLE>");
out.println("</FORM>");
out.println("</BODY>");
out.println("</HTML>");
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>");
out.println("PROBLEMA");
out.println("</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("Base di dati inesitente");
out.println("</BODY>");
out.println("</HTML>");
}
}
public void destroy()
{ try
{
con.close();
select.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
