Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Jsp Simple-jsp-example Select query in JSP

Related Tutorials


Share on Google+Share on Google+

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


If you enjoyed this post then why not add us on Google+? Add us to your Circles

Liked it!  Share this Tutorial

Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: August 8, 2013

Related Tutorials

Discuss: Select query in JSP  

Post your Comment

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