errore servlet

[saeba79]

Salve, sono nei guai, ho riscontrato un prolema e sono 2 giorni che non riesco a risolvere.

In pratica ho fatto una cartella clinica con jsp e quindi interfaccia html e devo memorizzare dei dati inviati ba combobox ceckbox e text in un database.
Ho fatto tutte le query in una servlet e continua a darmi errore:

"The specified HTTP method is not allowed for the requested resource (HTTP method GET is not supported by this URL)."

vi posto il programma:
codice:

import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpServlet;

public class connessione1 extends HttpServlet { 
 private PrintWriter out;
    
    //private String title, s;
    private Statement s;
    private ResultSet lr;
    private Connection dbconn;
    private String query;
    private  Integer i, idpatologia,idanamnesi;
    private String idp;
    private   ResultSet r;
      public connessione1 (){
          
            String query;
            s = null; 
            lr = null;
            s= null;
            dbconn=null;
        } 
          
           public void service (HttpServletRequest request, HttpServletResponse response, String fnv) throws ServletException, IOException, SQLException {
               

                out = response.getWriter();
                 
                response.setContentType("text/html");
                response.setHeader("Pragma", "no-cache"); 

                          
                
        
    
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
            dbconn = DriverManager.getConnection("jdbc:odbc:audiometria");
        }
        catch(Exception e){
        out.println("errore di connessione al database... Contattare l'amministratore di sistema!");
        }
       try {
            s = dbconn.createStatement();
        } catch (SQLException ex) {
            out.println(" non trovato:" + ex.getErrorCode());
        }
                
        out.println(" ");
        out.println("Mi sono connesso");
        
 
        Date oggi = new Date();     
        
        SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
        /*
        query="Insert into Anamnesi(id_paziente,data_anamnesi) values("+request.getParameter("idp")+",#"+formatter.format(oggi)+"#)";
        s.executeUpdate(query);
        out.println(query); 
       */
        query="Select max(id_anamnesi) as max_id from Anamnesi";
        r=s.executeQuery(query);
        r.next();
        idanamnesi=Integer.valueOf(r.getObject("max_id").toString());
        r.close();
        System.out.println(idanamnesi);
          try {
           // out.println(query);
            lr = s.executeQuery(query);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
        
        if(request.getParameter("parto")!=""){
            query="Insert into Patologia(id_anamnesi,nome) values("+idanamnesi+",'Parto "+request.getParameter("parto")+"')";
            s.executeUpdate(query);          
        }
    
        try {
           // out.println(query);
            lr = s.executeQuery(query);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       if(request.getParameter("infettive")!=""){
            query="Insert into Patologia(id_anamnesi,nome) values("+idanamnesi+",'Malattie   infettive: "+request.getParameter("infettive")+"')";
            s.executeUpdate(query);
            query="Select max(id_patologia) as max_id from Patologia";
            r=s.executeQuery(query);
            r.next();
            idpatologia=Integer.valueOf(r.getString("max_id"));
            r.close();
        }
            if(request.getParameter("eta")!=""){
                query="Insert into Sottopatologia(id_patologia, nome) values("+idpatologia+",'età: "+request.getParameter("eta")+"')";
                s.executeUpdate(query);
            }
                 
          if(request.getParameter("cons")!="false"){
            query="Insert into Patologia(id_anamnesi,nome) values("+idanamnesi+",'Consanguineità presente')";
            s.executeUpdate(query);
          }
        

         if(request.getParameter("lue")!="false"){
            query="Insert into Patologia(id_anamnesi,nome) values("+idanamnesi+",'LUE presente')";
            s.executeUpdate(query);
          }
                       
    try {
             
                
            dbconn.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       
        out.close();
           
           }
}

Conto sul vostro aiuto...
Grazie anticipatamente...

[Andrea1979]

non mancano i vari doGet/doPost ?

[alka]

Continua questa discussione.