Menu
When I execute the code below, before every insert, automatically a row is getting filled with Null values and then the actual values are being inserted.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="style.css" type="text/css">
<title>Connecting to a Data base</title>
</head>
<body>
<%
String connectionURL="jdbc:mysql://localhost:3306/jsp_test";
Connection connection = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "exeterblr");
if(!connection.isClosed()) {
out.println("Successfully connected to " + "MySQL server using TCP/IP...");
}
else
{
out.println("Cannot connect to DB");
}
String name=request.getParameter("name");
String email=request.getParameter("email");
String phone=request.getParameter("phone");
PreparedStatement pstatement=null;
int updateTable=0;
String queryString = "INSERT INTO sample_info(name,email,phone) VALUES (?, ?, ?)";
pstatement=connection.prepareStatement(queryString);
pstatement.setString(1, name);
pstatement.setString(2, email);
pstatement.setString(3, phone);
updateTable=pstatement.executeUpdate();
%>
<form method="post" action="index.jsp">
<table>
<tr>
<td>Name</td><td><input type="text" name="name"></td>
</tr>
<tr>
<td>Email</td><td><input type="text" name="email"></td>
</tr>
<tr>
<td>Phone</td><td> <input type="text" name="phone"></td>
</tr>
</table>
<input type="submit" value="Submit">
</form>
</body>
When I insert a value, the database contains the following:
Name Email Phone <br />
NULL NULL NULL <br />
ActualValue ActualValue Actual Value
721
You insert (NULL,NULL,NULL) each time you visit your webpage and not only on submit.
91
answered Aug 22 '26 02:08
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
