Help with JDBC and MySQL

[IvanJ2EE]

Hello partners.

I have an issue using jdbc and a DB in MySQL.
The problem is that I want to make a seach using the Last Name of a person stored in a MySQL DB, from a JSP
The problem is that I cannot determine which sentence to use for this purpose, that can help me to display the information of the person who match with the search criteria.

This is my actual Servlet.

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.net.*;
 
public class Changer extends HttpServlet {
 
    public Changer() {
        super();
    }
 
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
 
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
 
        String name=request.getParameter("name");
        String last=request.getParameter("last");
        String country=request.getParameter("country");
        String profile=request.getParameter("profile");
        String company=request.getParameter("company");
        String platform=request.getParameter("platform");
        String URL="jdbc:mysql://localhost:3806/Base01";
 
        try
                {
                    Class.forName("com.mysql.jdbc.Driver");
                }catch(Exception ex)
                {
                    out.println("error!");
                }
 
                try
                {
                    Connection con=DriverManager.getConnection(URL,"superou","kliojk126");
                    Statement stmt=con.createStatement();
                    ResultSet rst=null;
 
 
                    try{
                    String SQL= "SELECT * FROM 01thllo1 WHERE lastN =
                    System.out.print(SQL);
                    rst=stmt.executeQuery(SQL);    
 
                    out.println("<TABLE BORDER CELLSPACING=3 CELLPADDING=3>");
 
                    while(rst.next()){
                    out.println("<tr>");
                    out.println("<td>"+rst.getString("name"));
                    out.println("<td>"+rst.getString("last"));
                    out.println("<td>"+rst.getString("country"));
                    out.println("<td>"+rst.getString("profile"));
                    out.println("<td>"+rst.getString("company"));
                    out.println("<td>"+rst.getString("platform"));
                                        }//while
 
                    }catch(SQLException seq)
 
                    {
                        System.err.println("SQLException " + seq.getMessage());
                    }
 
 
        }catch(SQLException se){
        System.err.println("SQLException: " + se.getMessage());
                    }
        out.println("</TABLE>");
    }
 
}
 
 

So I will appreciate a lot if you can help me to make a correcr SELECT statement, because I`ve tried a lot of them and no one gives me the result that I want.

Thank you very much for your attention and help.

[madhoriya22]

What do you mean by sentence here - "The problem is that I cannot determine which sentence to use for this purpose, that can help me to display the information of the person who match with the search criteria."

[mwasif]

If you are looking for how to search in mysql then use this query

SELECT * FROM table_name WHERE name='name to search'

Or you can use FULLTEXT search

SELECT * FROM table_name WHERE MATCH(name_column) AGAINST('name to search')

.

But I still not clear what do you want!

[IvanJ2EE]

Ok let me explain myself better.

In a JSP called Changes.jsp, I show a page where the user should introduce the last name of the person to search in the database the full information of that person (name, country, etc.)

When the user click Search button, the Servlet should look in the database and get the full info of the person, and display in in the page.

So the problem is that I cannot find a SQL expression that help me to find the information of the Person based in the Parameter that the user puts on the Search TextField.

I hope this explains my problem better...
Thank you all for your help.

[mwasif]

In my previous reply, I have mentioned the query to search the respective result.

[ak1dnar]

Hi are you looking for something like this?

String SQL= "SELECT * FROM 01thllo1 WHERE column_name like '%"+pass_search_string_variable_here+"%'";
 

Edit: Make sure to print it as a single line...

[IvanJ2EE]

Ouch...I just found the mistake..
The problem is that I was calling the wrong parameter, so when I called it from the Jsp the servlet never found the parameter...
Thank you all for your replies and your time...

God Bless u.