Resultset Issue in SQL
when i call rs.next() in my code it is returning false, though im having valid query to execute and fetch a row from database.how can i resolve this issue.
My code is:
SELECT JOBDESCRIPTION,CATEGORY,OVERVIEW,COUNTRY,STATE,CITY FROM JOB WHERE JOBNAME=?
ps.setString(1,jobName);
View Answers
February 8, 2011 at 11:59 AM
SQL Select statement with PreparedStatement
import java.sql.*;
public class JdbcPreparedstatementExample {
public static void main(String args[]) {
String name="roseindia";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
String sql ="select * from data where name=?";
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1, name);
ResultSet rs = pst.executeQuery();
while (rs.next()) {
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
}
} catch (Exception e) {
System.out.println(e);
}
}
}
For more more information, visit the following link:
Select statement with PreparedStatement
February 8, 2011 at 3:54 PM
here i have given my code clearly.
In this control didnt go to while loop.so that i couldn set my bean values from resultset.
plz anyone give solution for this.
public retrieveJob(String jobName)
{
logger.info("jobname: "+jobName);
Connection connection=null;
PreparedStatement ps = null;
ResultSet r=null;
try{
DaoConnection helper = new DaoConnection();
connection=helper.getConnection();
ps = connection.prepareStatement("SELECT JOBDESCRIPTION,CATEGORY,OVERVIEW,COUNTRY,STATE,CITY FROM JOB WHERE JOBNAME=?");
ps.setString(1,jobName);
r = ps.executeQuery();
logger.info("QUERY EXECUTE :::"+r.next());
while(r.next()){
logger.info("inside while loop....");
logger.info("jobCategory inside HELPER"+r.getString(2));
}}
catch(Exception e){
logger.error("Exception thrown...");
e.printStackTrace();
} finally {
try {
ps.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}}
}
Ads
Related Tutorials/Questions & Answers:
Resultset Issue in SQL
Resultset Issue in SQL when i call rs.next() in my code it is returning false, though im having valid query to execute and fetch a row from database.how can i resolve this
issue.
My code is:
SELECT JOBDESCRIPTION,CATEGORY
SQL exception, Exhausted ResultSet
SQL exception, Exhausted ResultSet javax.servlet.ServletException: java.sql.SQLException: Exhausted
Resultset
iam getting this error messege whenever i run my code. what would be the possible reasons
Advertisements
ResultSet
ResultSet I want to retrieve data of unknown datatype from database.how to do it using
resultset or Resultsetmetadata.Can you please tell me what... = con.createStatement();
ResultSet rs = st.executeQuery
MY Sql Query Error - Not able to Understand the issue
MY
Sql Query Error - Not able to Understand the issue I am new at MYSQL,I wrote simple query as follow:
CREATE Table tblFeedBack ( FeedBackID INT... in your
SQL syntax; check the manual that corresponds to your MySQL server
Get Column Count using ResultSet in SQL
Get Column Count using
ResultSet in
SQL
 ... of columns in a
ResultSet.
The ResultSetMetaData object can be obtained by invoking getMetaData() method on
ResultSet object.
In this program you will see how JDBC
resultset metadta
resultset metadta import java.sql.Connection;
import... Employee Details Using
resultset metadata: ");
Connection con = null...();
ResultSet rs = st.executeQuery("SELECT * FROM employee
JTable populate with resultset.
();
ResultSet resultSet = statement.executeQuery(
sql...JTable populate with
resultset. How to diplay data of
resultset...)
JTable(Vector data, Vector columneNames)
Here is a JTable populate with
resultset
ResultSet In Java
executing the
SQL queries.
Object of
ResultSet also maintains the current position...= null;
PreparedStatement ps = null;
ResultSet rs = null;
String
sql...
ResultSet In Java
In this section we will learn about the
ResultSet in Java
Resultset - JSP-Servlet
Resultset I am writing while(rs.next){}
but if
resultset is null then it cannot enter in while block.
I want,if
resultset is null then it will enter into the while block. Hi friend,
A
ResultSet object
sql
difference between
sql and oracle what is the difference between
sql and oracle
sql
sql how to get first row in
sql with using where condition in
sql?
how to get last row in
sql with using where condition in
sql
issue on jcombobox
issue on jcombobox i have JTextfield and JComboBox. there are several values in combobox.when i select a value from combobox how to make textfiled as a combobox.only few values in the combobox need this functionality. need
jdialogbox issue.
jdialogbox
issue. i have one button.when clicked on it has to show a dialog box.but even click on it several times it has to open dialog box only once. if it is already not opened atleast once,then only it has to open dialog
sql
sql I want interview
sql questions
Please visit the following link:
SQL Tutorials
Sql
Sql how to find maximum of a101,a102,a103 from a table in
sql
Resultset with one to many relationship
Resultset with one to many relationship Suppose there are 5 tables in database named A,B,C,D and E. A has one to many relationship with B,C,D and D... populate my bean classes from
resultset without using hibernate, so
JTABLE Issue
to go back for another search.
Now
issue is -- when I put some input data
sql
sql returning value from a store procedure in
sql with example
Please visit the following links:
http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml
http://www.roseindia.net/
sql/create
Spring JdbcTemplate and ResultSet is too slow..
Spring JdbcTemplate and
ResultSet is too slow.. Hi..
I am using spring jdbctemplate to fetch the records from oracle database.
But it is taking... am using java jdbcTemplate.query(
sql, params, RowMapper object) and each record
Issue with Javascript
Issue with Javascript Hi I created arrays in javascript in following way
var myimages= new Array();
myimages[0]="iphone_pushups.png";
myimages[1]= "cricket.png";
myimages[2]= "july.png";
myimages[3]= "matrix.png
SQL
SQL In my computer i have microsoft
sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password
SQl
SQl . Given two tables:
table1(player, groundname, numcenturies);
table2(ground_name, country);
Write and
SQL query for the following:
" Select all the players from table1 who has
SQL
SQL 1)How to Store 1000 records in Oracle object.
2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble.
3)What is Sequence.
4)How to use rowid in
Sql.
5)What is Views.
6)How
JDBC ResultSet first() Example
JDBC
ResultSet first() Example:
The
ResultSet first() are use to moves the cursor to the first row in the
ResultSet object. It return true if the cursor pointed first row in the
ResultSet and return false if the
ResultSet object does
JDBC ResultSet last() Example
JDBC
ResultSet last() Example:
The
ResultSet last() are use to moves the cursor to the last row in the
ResultSet object. It return true if the cursor pointed last row in the
ResultSet
and return false if the
ResultSet object does
SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using
SQL
Use the following queries to get the data from database in the given format.
For (15 march 2011) format:
SELECT DATE_FORMAT(dob, '%d %M %Y') FROM
SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using
SQL
Use the following queries to get the data from database in the given format.
For (15 march 2011) format:
SELECT DATE_FORMAT(dob, '%d %M %Y') FROM