Select query in JSP

This example describe we have discuss select query in JSP from database table.

Select query in JSP

We are going to describe select query in JSP. In this example we have created table in database and we create some fields(id, name, address, destination, salary, dateOfJoin).After that you will insert dummy data. After that we create JSP page than we have make database connection. After that we use SELECT query. SELECT query is a retrieve the data from database than execute this query using executeQuery(sql) method of Statement interface and store the result into ResultSet. After that getString()method of ResultSet interface.

Syntax of select query:-

  • SELECT * FROM TableName;

Now we have created database, You can copy this code.

CREATE TABLE `employeedetails` (           
                   `id` int(10) NOT NULL,                   
                   `name` varchar(20) DEFAULT NULL,         
                   `address` varchar(20) DEFAULT NULL,      
                   `destination` varchar(20) DEFAULT NULL,  
                   `salary` varchar(20) DEFAULT NULL,       
                   `dateOfJoin` date DEFAULT NULL,          
                   PRIMARY KEY (`id`)                       
                 ) ENGINE=InnoDB DEFAULT CHARSET=latin1


<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>

String driverName = "com.mysql.jdbc.Driver";
String connectionUrl = "jdbc:mysql://localhost:3306/";
String dbName = "naulej";
String userId = "root";
String password = "root";

try {
} catch (ClassNotFoundException e) {

Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
<h2 align="center"><font color="#FF00FF"><strong>Select query in JSP</strong></font></h2>
<table align="center" cellpadding="4" cellspacing="4">

<tr bgcolor="#008000">
<td><b>Destination </b></td>
try {
connection = DriverManager.getConnection(
connectionUrl + dbName, userId, password);
statement = connection.createStatement();
String sql = "SELECT * FROM employeedetails";

resultSet = statement.executeQuery(sql);
while ( {
<tr bgcolor="#8FBC8F">




} catch (Exception e) {


Download Source Code



We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.

Share on Google+Share on Google+

Select query in JSP

Posted on: August 8, 2013 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: Select query in JSP  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image