query problem

Ads

Share on Google+

pushpa

query problem
1 Answer(s) 5 years and a month ago
Posted in : JSP-Servlet

how write query in jsp based on mysql table field?

i have employee table it contain designation field, how write query in jsp like

   select Ename from employee where Designation="Marketing Manager";

how to write this query in jsp please anybody help me, and send me that code urgently if it possible to write in jsp?

thanks

Ads

View Answers

September 6, 2012 at 4:11 PM

Here is a jsp code that displays the employee names from the database table who are Marketing Managers.

<%@page language="java"%>
<%@page import="java.sql.*"%>

<table border="1">

<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
String query = "select Ename from employee where Designation='Marketing Manager'";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
%>
<tr>
<td><input type="text" name="name" value="<%=rs.getString("name")%>"></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table>

Ads

Advertisements

Problem in executing query....
Problem in executing query.... Suppose there is a textbox or a text... this data with request.getParameter() but when I execute the query to store in oracle it is showing error because of the '.I understand where the problem is.If

Problem in updating query in Hibernate - Hibernate
Problem in updating query in Hibernate Hi, I have used a query to update the existing columns of one table. The query updates the records in the main table but it does not update the tables that are mapped from the main table

problem in insert query - JSP-Servlet
problem in insert query Hi! I am using this statement for data... Hi friend, We check your Query it is correct .If you have problem plz give full details with source code and visit to : http

select Query result display problem
select Query result display problem Hi, String SQL_QUERY ="from Cc"; Query query = session.createQuery(SQL_QUERY); for(Iterator it=query.iterate...]); } when I am executing the above query the following error will happend

MS-ACCESS Query Problem - SQL
MS-ACCESS Query Problem hi sir i have table which is initially... tables Course and Class wise Ex..Query like: if we execute this Query... records so these all records i want to insert into Deleted Table plz can u give Query

i have problem with this query... please tell me the resolution if this .........
i have problem with this query... please tell me the resolution if this ......... select length(ename)||' charecters exist in '||initcap(ename)||'s name' as "names and length" from emp

i have problem with this query... please tell me the resolution if this .........
i have problem with this query... please tell me the resolution if this ......... select initcap(ename),job from emp where substr(job,4,length(job,4,3)))='age

query in JDBC
query in JDBC What are the steps required to execute a query in JDBC

Query conversion
Query conversion can please convert the following mysql query to hibernate query select * from table1 where field1 not in (select field_1 from table3

query optimization
query optimization hai ! i need a code in java for database query optimization.plz help

query string
query string Need some examples of query strings.send me as soon as possible. Regards, R.Santhosh

Query Question
Query Question How would I write a query to display the name, department of the employee that earns the highest salary in the Employees table

problem on php
problem on php l have five tables and build them as forms and link between them php and database and i want to build query between them plz help me soon PHP MySQL Tutorials

HQL Query
HQL Query Hibernate query language: How to use a left join in Hibernate query language. Can somebody help with an example. I am getting a unexpected token error in HQL Query tool If I use joins

Sql Query
Sql Query Is this query work in Db2 or not ? Select * from FORUM LIMIT 2

jdbc query
jdbc query write a query of how to print the values of any column present in database in reverse order

database Query
database Query i have to find common columns from two tables fron 2 differnt schemas what query to use? i used intersect but i am not getting how it is comapring two tables from different schema because in query we have

database Query
database Query i have to find common columns from two tables from 2 different schemas what query to use? i used intersect but i am not getting how it is comparing two tables from different schema because in query we have

sql query
sql query two tables are emp,loc write a query to display all the emp information whose locname not equal to bangalore

session into a query
session into a query Hi all this am Sreedhar from Hyderabad i am calling one session variable in mysql query but its not working can any one help me please... here is the query.. $query = 'SELECT * FROM post WHERE post_date <

HQL query
HQL query how to select only password based on username using HQL query from login table where uname and paswrd are two column names

SQL Query
SQL Query Selecting the third highest salary of Employee without using any subquery? Here is a query: SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1

query string
query string on my servlet page i take the values of the field in a variable and that variable is a primary key so on the basis of that i am sorting... servlet page to different servlet jsp page and that i want to do with query string so

need query
need query hi sir , i am beginner to sql.i need a query so that it can be helpful to my project. i have four tables each containing different fruits with different amounts. i need a query in such a way that when i say some

sql query
query plz help to me

Sql Query
Sql Query Hi M Navjeet Ghai I want to know How to Show A name(Like Navjeet Ghai And Manpreet Singh Sodhi) of employees from a employee table as N.Ghai & M.S.Sodhi by using sql query

Ads

Advertisement null

Ads