Moteur de recherche avec jsp et mysql
Bonjour à tous ,
Jai un probleme avec mon moteur de recherche en jsp et mysql qui me renvoit toujour une erreur en disant qu'on doit saisir un mot alors que j'ai saisi le mot voici mon code:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
| try
{
//create driver - ALTER TO SUIT YOUR DRIVER/ DBMS
Class.forName("com.mysql.jdbc.Driver").newInstance();
//database connection code - ENTER YOUR DETAILS
String username = "root";
String password = "admin";
String mot=request.getParameter("mot");
//URL - ALTER TO CONNECT TO YOUR DATABASE
String dbURL = "jdbc:mysql://localhost/sms?user="
+ username + "&password=" + password;
//create the connection - ALTER FOR YOUR DBMS
java.sql.Connection myConnection =
DriverManager.getConnection(dbURL);
//create statement handle for executing queries
Statement stat = myConnection.createStatement();
if(request.getParameter("mot") !=""){
out.println("Veuillez enter un mot clé s'il vous plait");
}
else {
String selectQuery = "SELECT distinct pseudo,num_tel,sexe,age,date_entree,pays FROM chat_users WHERE pseudo LIKE " +request.getParameter("mot")+" ORDER by pseudo ASC";
//get the results
ResultSet results = stat.executeQuery(selectQuery);
//output the results
out.println("<TABLE align='center'>");
out.println("<TR style='background-color:#6666CC;'>");
out.println("<TH><b><u>Pseudo</u></b></TH>");
out.println("<TH><b><u>Num tel</u></b></TH>");
out.println("<TH><b><u>Age</u></b></TH>");
out.println("<TH><b><u>Date entree</u></b></TH>");
out.println("<TH><b><u>Pays</u></b></TH></TR>");
while (results.next())
{
//example - column is called 'firstname'
System.out.println("-----------");
out.println("<tr style='background-color:#DADEFF;'>");
out.println("<td>"+ results.getString("pseudo")+ "</td>" );
out.println("<td>"+ results.getString("num_tel")+ "</td>");
out.println("<td>"+results.getString("age")+"</td>");
out.println("<td>"+results.getString("date")+"</td>");
out.println("<td>"+results.getString("pays")+"</td>");
}
}
}
catch (Exception e)
{
// ... on traite l'exception si besoin ...
out.println("echec pilote:" +e);
}
%> |
Merci de bien vouloir m'aider
