Retrieve data from databse using where in JSP

Hi, can somebody help me?

I have a jsp page. in that i want to get data from the database where username is matched. i tried it. but can't get the output. here is the code. please help me. ALL DATABASE CONNECTIONS ARE OK. THE ERROR IS SHOWN IN "WHERE". IT SAYS INCORRECT SQL SYNTAX

<html>
   .....
<body>
 <%
      //table name is "register" have Name and Username filed.
      String uname=request.getParameter("username");
      String sql;
      sql="SELECT * FROM register WHERE Username="+uname+"";
      ResultSet rs=stmt.executeQuery(sql);
      while(rs.next())
                    {
      %>          

   NAME: <%=rs.getString(1)%> 
   USERNAME: <%=rs.getString(2)%> 

       <%        
                }
         %> 

   </body>
</html>

View Answers

February 6, 2013 at 4:26 PM

hi friend,

I think in your sql query you missed the single quote ( ' ) after Username. This is required because you are searching for a text and text should be written within the single quote such as in your example your query should be written as follows :

SELECT * FROM register WHERE Username='"+uname+"'"

you may try the following code :

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*;" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Delete Data</title>
</head>
<body>
<form action="#">
<table>
<tr>
<td>Enter Username</td>
<td><input type="text" name="username"/></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Register"/></td>
</tr>
</table>
</form>
<%! String driverName = "com.mysql.jdbc.Driver";%>
<%! String url = "jdbc:mysql://localhost:3306/record";%>
<%! String user = "root";%>
<%! String psw = "root";%>
<%
String uname = request.getParameter("username");
if(uname != null)
{
Connection con = null;
PreparedStatement ps = null;    
try
{
    Class.forName(driverName);
    con = DriverManager.getConnection(url,user,psw);
    String sql = "SELECT * FROM register WHERE Username='"+uname+"'";
    ps = con.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();
    while(rs.next())
    {
        %>
        Name = <%=rs.getString("Name") %>
        <%

    }
}   
catch(SQLException sqe)
{   
    out.println(sqe);
}
}
%>
</body>
</html>

Advertisements

how to print data(From databse Oracle10g) in preformatted A4 and A3 paper using jsp
how to print data(From databse Oracle10g) in preformatted A4 and A3 paper using jsp how to print data(From databse Oracle10g) in preformatted A4 and A3 paper using jsp. I am inserting analysis report into a database using

how to retrieve data from multiple tables in jsp using javabeans
how to retrieve data from multiple tables in jsp using javabeans �...).second .java file for getting data from second table- package pack; public... for retrieving data fromm two tables : first table having fields: bookid,name

how to retrieve data from database using combobox value without using request.getParameter in jsp - JSP-Servlet
how to retrieve data from database using combobox value without using request.getParameter in jsp Answer pl

How to Retrieve Data from Facebook Using PHP
How to Retrieve Data from Facebook Using PHP is this link has right content regards that?? http://techpdf.co.cc/blog/how-to-retrieve-data-from-facebook-using-php

How to retrieve data from database by using combo box value in jsp? - JSP-Servlet
How to retrieve data from database by using combo box value in jsp? Hello friend i want use only one jsp page.. but u give 2 pages... I want to work in one page... Pl response.. I do not need getParameter... Pl respose me

retrieve data from database using jsf
retrieve data from database using jsf Hello I want an example of source code to retrieve data from database i have a database (oracle) name as db1...),, name ,and city I want after enter value in textbox according idauthor i retrieve

Retrieve data from xml using servlets
Retrieve data from xml using servlets Hi plz send me the code for retrieving the data from xml File using Servlets. Hi, Do you want... File using ServletADS_TO_REPLACE_2 Thanks Hi, Learn Get Data From

Read Excel data using JSP and update MySQL databse
Read Excel data using JSP and update MySQL databse HOw to read excel data using JSP and update MySQl database

<img src=""> using retrieve image from database using jsp
using retrieve image from database using jsp how to <img src="" > tag using retrieve image from database and display in jsp

Retrieve database from the table dynamically in jsp from oracle using servlet
Retrieve database from the table dynamically in jsp from oracle using servlet Sir, I have created a table in oracle using eclipse, and added few... using java servlet from the database in the jsp page

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? I am using a single jsp form.. i did not get from another form.. i do not use 2 jsp form.. all.... Note: I am using only this jsp form.. i do not use

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? For example, In Employee.jsp form, When i click employee id value in combo box...... i already stored combo box values from database. pl

How to retrieve data using combo box value in jsp? - JSP-Servlet
How to retrieve data using combo box value in jsp? Hi freind, I already post this question. I need urgent help from u. pl response me... the following link: http://www.roseindia.net/jsp/comboSelect.shtml Hope

How to retrieve image from database using jsp and servlet?
How to retrieve image from database using jsp and servlet? Hi, I am trying to find code for displaying the image from database in a JSP page. How to retrieve image from database using jsp and servlet

how to retrieve data from database
how to retrieve data from database unable to retrieve data from database using mySQL by using jsp sessions and beans for editing

Retrieve image from database using servlet and display in JSP
Retrieve image from database using servlet and display in JSP Hi, I am total new to JSP although I am learning it for the last few days. Now I want to use MySQL Database from JSP page. How to retrieve image from database using

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? Hi Friends... related value.... I am using only this page.. not get value from another page... in combo box from database.. by using select*from studentinformation; But when i

how to insert data from netbeans into databse
how to insert data from netbeans into databse how to insert data from netbeans into databse Please visit the following link: http://www.roseindia.net/webservices/web-services-database.shtml

Exporting data from mysql into csv using jsp
Exporting data from mysql into csv using jsp Hi friends.... I want to export the data from mysql to csv file using... i am having 30 columns in my database.. Eg- text1,text2,text3,....,upto text30... i want to export this data

retrive data from database using jsp in struts?
retrive data from database using jsp in struts? *search.jsp* <... searchProduct(SearchDTO sdto) { String query="select * from product"; if(sdto.getPid()==null || !sdto.getPid().equals("")) { query=query+" "+"where pid

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

Retrive data from databse to a text field - Java Server Faces Questions
Retrive data from databse to a text field Hi, Can you give me a source code to rertrve data from Mysql databse to a text field using JSF.....by selecting option from a dropdown option

how to load a table of data from oracle, to a jsp page using hashmap.
how to load a table of data from oracle, to a jsp page using hashmap. I have a jsp page which ask for project ID,team name,member name according to this data i have to retrieve their details from the database(oracle). I have

Retrieve data from database by using sql tag of JSTL SQL library
Retrieve data from database by using sql tag of JSTL SQL library... we will see how retrieve data from database using sql query given by user. To execute query first create a data source and then execute sql query

How to get data from Oracle database using JSP
the answer to retrieve data from the database by using servlet or jsp program...How to get data from Oracle database using JSP hello i have a simple problem in jsp in the sense to get data from the database like oracle . I have

how to create a bar chart in jsp by fetching value from oracle databse?
how to create a bar chart in jsp by fetching value from oracle databse? i want to show the population of various states in a bar chart in my jsp page by fetching the data from my oracle table. i am using my eclipse as my IDE

Retrieve The Data From MySql Datbase
Retrieve The Data From MySql Datbase How to Retrieve The Data From MYSQL database TO Use Select the Emp_id Option.And Also Search Option

How to retrieve image from mysql database in JSP?
How to retrieve image from mysql database in JSP? Hi, I need JSP... to retrieve image from mysql database in JSP? Thanks Hi, You can write SQL query to find the data from database and get the image from resultset using

retrieve data from mysql database
retrieve data from mysql database hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data from mysql... * from testtable where Fname like '%$term%'"); while ($row = mysql<em>

How to get the data from the database using Servlet or JSP program
How to get the data from the database using Servlet or JSP program �... the problem Get data from database using servlet Retrieve data from database using JSP Get data from database using JSP

How to export data from jsp to excel sheet by using java
How to export data from jsp to excel sheet by using java How to export data from jsp to excel sheet by using java

Retrieving data from data base using jsp combo box
Retrieving data from data base using jsp combo box Hi guys please help me , i have on GUI page int that Server type(like apache,jboss,weblogic) one... of the server it has to display the process name from database into the process name

ID using get the databse latest value and displayed in jsp
", "root"); //String query = "select * from Data where id='"+no+"'"; Statement st...ID using get the databse latest value and displayed in jsp function...; <% } } catch(Exception e){} %> I have done jsp page like this .... I

How to Retrieve data from database in jsp
How to Retrieve data from database in jsp In this section we will discuss... are going to discus about retrieve data from database in jsp.First of all we have... Here is the video tutorial of "How to retrieve data from database

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp The user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url

insert data into mysql databse using swing
insert data into mysql databse using swing Blockquote hi, here is my code, i want code for store data into mysql database when click on submit button from access data from this form, please provide code, import java.awt.

Retrieve values from database using views
Retrieve values from database using views hi......... I have a huge... the columns which are required. As my front end is java swings i want to retrieve data... giving me error . So can u plz help??????? Can u tell me how to retrieve data

Data retrieve from mysql database
Data retrieve from mysql database Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list... from the dropdown, related data will get displayed on the textboxes. Here we have

retrieve data from database with hyperlink
retrieve data from database with hyperlink sir....i have one table called 'name' having two values i have to retrieve those data with a hyperlink... have values C C++ i have to retrieve and if i click C its sub categories should

Data needs to be gathered in XML file from the database (MySql) using JSP
Data needs to be gathered in XML file from the database (MySql) using JSP�... data regarding particular id from the database table. Data needs to be gathered in XML file from the database (MySql) using appropriate JSP/Java Bean functions

How to display data in jsp from dao using java beans?
How to display data in jsp from dao using java beans? Hi I need to display data in jsp pulling from dao using java beans, Please can anyone give me the sample application with above topics. Any help would be highly appreciated

Ads