Insert Data Into Table Through JSP

This is another very important application in the series of database applications using JSP. In this article, I am going to develop an application that shows how to insert data into a table through JSP. In this application we are filling the data through JSP coding.

Step 1: Create a new database

In the first step we click on the blank database option and click on the create.

make a new database.jpg

Step 2: Design the database

In this step we select a field name and data type for the those fields. In this application we select five fields (id, name).

Step 3: Make DSN

In this step we make a DSN using the following process.

First we select the control panel option from start.

Then click on the administrative tools

click on administration tools.jpg

Select Data Sources option

select data source option.jpg

Then select Microsoft Access Driver(*.mdb,*.accdb), and click on the finish button.

create new data source.jpg

Then select database from the computer and give it a specific name; now the DSN is created.

select database.jpg

Step 4: Create a New Project

In this step we select New Project option from the file menu.

create new project.jpg

Step 5: Choose Project

In this step we select web application from Java web option and then click on the next button.

select new web application.jpg

Step 6: Name and Location

In this step we given it a specific name and set a specific location and click on the next button.

Step 7: Server and Setting

We select a specific server for this application and click on the next button.

server and setting.jpg

Step 8: Select Framework

There is no need to select any framework for this application; just click on the finish button.

Step 9: Create jsp file

We create one jsp file for this application.

create new jsp file.jpg

Insert.jsp

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<HTML>
<HEAD>
<TITLE>Inserted data in a Table</TITLE>
</HEAD>
<BODY BGCOLOR="cyan">
<H1>Inserted data in a Table</H1>
<%
Connection connection =DriverManager.getConnection("jdbc:odbc:employee");
Statement statement = connection.createStatement();
String command = "INSERT INTO Employee(ID, Name) VALUES(1,'Vikas')";
statement.executeUpdate(command);
command = "INSERT INTO Employee(ID, Name) VALUES (2,'Akshay')";
statement.executeUpdate(command);
ResultSet resultset =
statement.executeQuery("select * from Employee");
while(resultset.next()){
%>
<TABLE BORDER="1">
<TR>
<TH>ID</TH>
<TH>Name</TH>
</TR>
<TR>
<TD> <%= resultset.getString(1) %> </TD>
<TD> <%= resultset.getString(2) %> </TD>
</TR>
</TABLE>
<%
}
%>
</BODY>
</HTML>

Step 10: Compile and Run the application

Now we compile the application and then run it on the server and find the following output.

Output

Insert.jsp

Resources related to these article: