to store form vaues in database

View Answers

October 17, 2008 at 4:16 PM

Hi friend,

Code to insert the data into database :

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>�

<HTML>
<HEAD>
<TITLE>Navigating in a Database Table </TITLE>
</HEAD>

<BODY bgcolor="#ffffcc">
<font size="+3" color="green"><br>Welcome in www.roseindia.net !</font>
<FORM action="" method="post">
<TABLE style="background-color: #ECE5B6;" WIDTH="30%" >

<TR>
<TH width="50%">Name</TH>
<TD width="50%"><INPUT TYPE="text" NAME="name"></TD>
</tr>
<TR>
<TH width="50%">Father Name</TH>
<TD width="50%"><INPUT TYPE="text" NAME="father_Name"></TD>
</tr>

<TR>
<TH></TH>
<TD width="50%"><INPUT TYPE="submit" VALUE="submit"></TD>
</tr>
</TABLE>
<%
String name = request.getParameter("name");
String father_Name = request.getParameter("father_Name");

/* Create string of connection url within specified format with machine name,
port number and database name. Here machine name id localhost and database name is student. */
String connectionURL = "jdbc:mysql://localhost:3306/student";;

// declare a connection by using Connection interface
Connection connection = null;

// declare object of Statement interface that uses for executing sql statements.
PreparedStatement pstatement = null;

// Load JBBC driver "com.mysql.jdbc.Driver"

int updateQuery = 0;

// check if the text box is empty
if(name!=null && father_Name!=null ){

// check if the text box having only blank spaces
if(name!="" && father_Name!="") {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

/* Create a connection by using getConnection() method that takes
parameters of string type connection url, user name and password to connect
to database. */
connection = DriverManager.getConnection(connectionURL, "root", "root");

// sql query to insert values in the secified table.
String queryString = "INSERT INTO stu_info(Name,Father_Name) VALUES (?, ?)";

System.out.println("queryString : " + queryString);
/* createStatement() is used for create statement object that is used for
sending sql statements to the specified database. */
pstatement = connection.prepareStatement(queryString);
pstatement.setString(1, name);
pstatement.setString(2, father_Name);
updateQuery = pstatement.executeUpdate();

if (updateQuery != 0) { %>
<br>
<TABLE style="background-color: #E3E4FA;" WIDTH="30%" border="1">
<tr><th>Data is inserted successfully in database.</th></tr>
</table>
<%
}
}
catch (Exception ex) {
out.println(ex.getMessage());

}
finally {
// close all the connections.
pstatement.close();
connection.close();
}
}
}
%>
</FORM>
</body>
</html>

For more information visit to :

http://www.roseindia.net/

Thanks