Problème d'insertion de données dans la base
J'utilise une interface html connecter à une base de donnée mysql via une servlet api voici mon code java de l'insertion de donnée de la page html vers la base j'obtiens un message qui dit que les données sont déjà ajouter mais ma base de donné est encore vide aucune donnée est ajouté.
Voici mon code java:
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
55
56
57
58
59
60
61
62
| import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.sql.*;
public class InsertData extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public InsertData() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/newData";// newData is the database
Connection connection;
try{
String Username = request.getParameter("usertext");
String Phone = request.getParameter("phone");
String Email = request.getParameter("email");
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "root");
PreparedStatement pst = connection.prepareStatement("insert into try2(Username,Phone,Email) values(?,?,?) ");//try2 is the name of the table
pst.setString(1,Username);
pst.setString(2,Phone);
pst.setString(3,Email);
int i = pst.executeUpdate();
if(i!=0){
pw.println("<br>Record has been inserted");
}
else{
pw.println("failed to insert the data");
}
}
catch (Exception e){
pw.println(e);
}
}
} |
