JSP:Passing query as parameter

Home Answers Viewqa Java-Beginners JSP:Passing query as parameter

Vinay

JSP:Passing query as parameter
1 Answer(s) 3 years ago
Posted in : Java Beginners

Hi Friends,

I have a real tough time in finding the solution of a problem. I am here to find a real solution of my problem. Please help me solve this problem.
My Problem is:

I have 3 query..
String qry1="select id from table1";
String qry2="select name from table2";
String qry3="select age from table13";

string q=Insert into emp values(?,?,?);
int update=prep.executeUpdate(q);
prep.setString(1,qry1);
prep.setString(2,qry2);
prep.setString(3,qry3);
prep.executeUpdate();

In this, i am not able to pass the value of qry1,qry2,qry3...

Please help me to find the solution.

Its really urgent.......Please

View Answers

November 20, 2010 at 7:39 PM

Hey dude , the approach you have taken to fetch the data is not correct. Your qry1,qry2 and qry3 will not execute in this way. You need to execute those query.

Passing Parameter Values to another jsp in Query Strings
Passing Parameter Values to another jsp in Query Strings HI ALL, I m trying to pass a variable value to another JSP using query string... response.sendRedirect("http://localhost:8080/SWIFT/index.jsp?loginid='"+loginid

How to pass query as parameter? - JSP-Servlet
How to pass query as parameter? Hi Friends, I have a real tough time in finding the solution of a problem. I am here to find a real solution of my problem. Please help me solve this problem. My Problem is: I have 3 query

JSP:Passing query as parameter - Java Beginners
JSP:Passing query as parameter Hi Friends, I have a real tough time in finding the solution of a problem. I am here to find a real solution of my problem. Please help me solve this problem. My Problem is: I have 3 query

JPA setParameter (Named Parameter)
JPA setParameter (Named Parameter) In this section, you will learn the JPA Query API's method setParameter as a named parameter. JPA Query API's supports two

JSP get Parameter
JSP get Parameter JSP get Parameter is used to return the value of a request parameter passed as query string and posted data which is encoded

JPA Positional Parameter
the value in parameter. So, We don't have use the same query for different values...JPA Positional Parameter In this section, you will learn about the JPA Positional Parameter

JPA Named Parameter List
JPA Named Parameter List ... application using JPA Named Parameter List. This is similar as named parameter but here we use the an array list as named parameter. Named Parameter List

JPA setParameter (Numbered Parameter)
JPA setParameter (Numbered Parameter) ... the setParameter. Here, we will see setParameter to set a numbered parameter. We are going to develop an example code to use the numbered parameter

JPA Named Parameter
JPA Named Parameter In this section, you will learn how to use JPA Named Parameter in your jpa application. In JPA named parameter is used where you assign names

What is the Sub-Query?And what is the properties of Sub-Query?
What is the Sub-Query?And what is the properties of Sub-Query? What is the Sub-Query?And what is the properties of Sub-Query? Hi, Sub... to be executed arbitrarily within the body of another SQL statement. A sub-query

Parameter passing from jsp page to jsp page - JSP-Servlet
Parameter passing from jsp page to jsp page Hi I intends to pass the parameters that I received from previous page through query String. I get all parameter in respective string variables. I have to passed the parameters

Init Parameter
Init Parameter How set Init Parameter in servlet

Wrong parameter values while exporting data from jsp to excel
Wrong parameter values while exporting data from jsp to excel This is a jsp report. When i export the report data to an excel, the parameter..., specifically, if the parameter value is ALL, it gets translated to NO in excel

Query

query

Query

query

Query

query

Query

query

Java parameter passing
Java parameter passing What type of parameter passing does Java support

validate parameter before using it
validate parameter before using it How to validate the parameter before using it in JSP

Need Help-How to store input parameter in DB through Java Bean - JSP-Servlet
Need Help-How to store input parameter in DB through Java Bean Hello Sir, I have a simple Issue but It is not resolve by me i.e input parameter are not store in Ms-Access. I store the input parameter through Standard Action

pass parameter names and values
pass parameter names and values What is the <jsp:param> standard action? The <jsp:param> standard action is used with <jsp:include> or <jsp:forward> to pass parameter names and values

Hibernate Named Query
Hibernate Named Query Named Query is very useful concept in hibernate. It lets... file(.hbm files). The query is given unique name for the entire application

optional parameter of Test annotattion
optional parameter of Test annotattion What are two optional parameters of @Test annotation ? The Test annotation supports two optional... parameter, timeout, causes a test to fail if it takes longer than a specified amount

optional parameter of Test annotattion
optional parameter of Test annotattion The Test annotation supports two optional parameters. The first, expected, declares that a test method should throw an exception. If it doesn't throw an exception or if it throws

Passing Parameter - JSP-Servlet
Passing Parameter I would like to ask how to pass a parameter from javascript section into the jsp section.It will be something like...; answer<%; <---I'm stuck here passing the var

SQL Out Parameter
SQL Out Parameter SQL Out Parameter allows the stored procedure to the pass data value ... from SQL Out Parameter .In this Example we create a procedure 'abc

parameter meta data - JDBC
parameter meta data i wnts to know about the finition of parameter in jdbc as well as the diffrent methods used in parameter meta data Hi friend, public interface ResultSetMetaData An object that can be used

Parameter Tag:
Parameter Tag: bean:parameter...) of the specified request parameter. This tag retrieve the value of the specified request parameter and define the attribute of type String or String[] in page scope

Passing Parameter - JSP-Servlet
Passing Parameter Hi, it'me again. Below is the set of code that I get from your solution entitled droplist that read from database. It do read from..., there's var answer. I need to pass this parameter back into the jsp part, how should i do

Passing a parameter using URL string
Passing a parameter using URL string How to pass a parameter using the URL string in a JSF application

Applet code parameter - Applet

PHP add parameter to url - PHP
PHP add parameter to url need an example of parse_url in PHP. Thanks in advance

Static Parameter
Static Parameter In this section, we will develop a simple application to access the static parameters. We will use a JavaBean to set and get the static parameters. Each static parameter has a value

passing parameter from html to applet
passing parameter from html to applet how to pass the following from HTML to applet in Java code - font size,font style,font size?give me suitable code

Parameterized PreparedStatement Example
with parameter. It does not compile the query every time, The query once...); // setting parameter to the query statement.setInt(1, 2... statement with no parameter. Creating a java.sql.PreparedStamenet

how to pass the parameter in callable statement
how to pass the parameter in callable statement calstat=conn.prepareCall("{call studentrc(?,?,?,?,?)}"); // it show error parameter value is null...=smark1,mark2=smark2,total=stotal where Regno=Regno; end;// how can i pass the parameter

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics