How do I execute an SQL SELECT query in JSP?

Question

I want to execute an SQL query in JSP. The display must be in JSP code, not in java.

I cannot introduce JSP code in a java page.

package tn.com.tradenet.utilisateur;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


public class Modification extends HttpServlet
{
public void doPost()
{
try
{

String id ="1"; //request.getParameter("userName");
String nom ="mecchlaoui"; //request.getParameter("userName");
String prenom ="fawzia"; //request.getParameter("userName");
String email ="hotmail"; //request.getParameter("password");
String profil ="fawzia"; //request.getParameter("password");
String login ="fawzia"; //request.getParameter("password");
String pass ="1258"; //request.getParameter("password");

ConnectionBD mod = new ConnectionBD();
//String sql="SELECT id FROM utilisateur";
//ResultSet res=mod.execMonSQl(sql);


//while (res.next())
//{
//id = res.getString(1);

//}

mod.execMonUpdate("UPDATE utilisateur SET nom='"+nom+"',prenom='"+prenom+"', email='"+email+"', profil='"+profil+"',login='"+login+"',pass='"+pass+"' WHERE 'id'='"+id+"'");
System.out.println("element ajoutté");}

catch(SQLException s)
{
System.out.println("erreur" +s);
}
}

public static void main(String[] args) {

Modification mdf =new Modification();

mdf.doPost();


}


}

18 questions with 0 accepted answers is... well, unacceptable. — StriplingWarrior
– StriplingWarrior, Commented Mar 16, 2011 at 18:37

Community · Accepted Answer · 2017-05-23 12:11:52Z

4

You need to override the real HttpServlet#doPost() method, not to add another one which won't be invoked by the servletcontainer.

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    // Do your job here.
}

And you need to map this servlet in web.xml on a known URL pattern.

<servlet>
    <servlet-name>modification</servlet-name>
    <servlet-class>com.example.Modification</servlet-class>
</servlet>
<servlet-mapping>
    <servlet-name>modification</servlet-name>
    <url-pattern>/modification</url-pattern>
</servlet-mapping>

With the above <url-pattern> the servlet will listen on URL http://example.com/context/modification.

Finally change the HTML form action URL in your JSP so that it matches the servlet URL.

<form action="modification" method="post">

1 Comment

StriplingWarrior Over a year ago

+1. Excellent answer on a difficult question. You might also point him to a parameterized query reference, so he's not open to SQL injection.

Collectives™ on Stack Overflow

How do I execute an SQL SELECT query in JSP?

1 Answer 1

See also:

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

See also:

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related