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.
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
Select Data Sources option
Then select Microsoft Access Driver(*.mdb,*.accdb), and click on the finish
button.
Then select database from the computer and give it a specific name; now the DSN
is created.
Step 4: Create a New Project
In this step we select New Project option from the file menu.
Step 5: Choose Project
In this step we select web application from Java web option and then click on
the next button.
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.
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.
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: