ciao a tutti,
ho un problema molto strano,
ho realizzato una pagina jsp con un form in html che si collega ad una servlet java, questa servlet accede a un database per interrogarlo e ricava i dati, quando provo la pagina non mi visualizza i dati nella servlet.
ecco il codice intero:
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 javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author andrea.zappa
* @version
*/
public class Registrazione extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
static final String JDBC_DRIVER="sun.jdbc.odbc.Jdbc0dbcDriver";
static final String DATABASE_URL="jdbcdbc:giardinaggio.mdb";
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
Connection connection=null;
Statement statement=null;
String login=request.getParameter("username1");
String password=request.getParameter("password1");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet Paginabenvenuto</title>");
out.println("</head>");
out.println("<body>");
try
{
Class.forName(JDBC_DRIVER);
connection=DriverManager.getConnection(DATABASE_UR L);
statement=connection.createStatement();
String richiesta="SELECT Login, Password, Nome, Cognome FROM Utente";
ResultSet resultSet1=statement.executeQuery(richiesta);
while(resultSet1.next())
{
out.println(resultSet1.getString(1));
if (login.equals(resultSet1.getString(1)))
{
if (password.equals(resultSet1.getString(2)))
{
out.println("Benvenuto"+resultSet1.getString(3)+" "+resultSet1.getString(4));
}
}
}
}
catch (SQLException e)
{
e.printStackTrace();
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
finally {
try{
statement.close();
connection.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
out.println("</body>");
out.println("</html>");
out.close();
}
Rispondi quotando
