Java: Empty ResultSet when retrieving record from MySQL

Question

I am using the netbeans and mysql. I have a table named employee with the following fields" emp_id, emp_name, intime, date. I try to retrieve a particular record using this query:

SELECT intime FROM employee WHERE emp_id='1' AND date='25/06/12'

I get an error saying empty resultset, but the table contains that particular record. Why did this error occurred?

error: dsdcom.mysql.jdbc.JDBC4ResultSet@d20b73

please provide some code on how do you connect to db, how you execute the command etc ... — MaVRoSCy
– MaVRoSCy, Commented Jun 26, 2012 at 6:13
run above query directly in mysql using HeidiSQL or something like that. And make sure that it returns the result you want. By using this method you can correct errors in your query. If query returns correct result, then provide your connection related code to check for errors — Fathah Rehman P
– Fathah Rehman P, Commented Jun 26, 2012 at 6:25
Class.forName("com.mysql.jdbc.Driver"); DriverManager.getConnection("jdbc:mysql://localhost:3306/attendance", "root", "karma"); — Jayashri
– Jayashri, Commented Jun 26, 2012 at 6:45

KV Prajapati · Accepted Answer · 2012-06-26 06:34:31Z

1

Try to write/execute query using PreparedStatement,

String sql="Select intime from employee where emp_id=? and date=?";
PreparedStatement statement=conn.prepareStatement(sql);
statement.setInt(1,1);
statement.setDate(2,java.sql.Date.valueOf("2012-06-25"));
ResultSet rs=statement.executeQuery();
if(rs.next())
 {
   //found
 }

answered Jun 26, 2012 at 6:34

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

YangHongChang · Accepted Answer · 2012-06-26 06:24:52Z

0

maby date field is keywords or database table data field some column is null,i suggest you double checked.

answered Jun 26, 2012 at 6:24

YangHongChang

768 bronze badges

Comments

Fathah Rehman P · Accepted Answer · 2012-06-26 06:26:30Z

0

run above query directly in mysql using HeidiSQL or something like that. And make sure that it returns the result you want. By using this method you can correct errors in your query.

answered Jun 26, 2012 at 6:26

Fathah Rehman P

8,8014 gold badges43 silver badges42 bronze badges

14 Comments

Jayashri Over a year ago

I run this query but it retuns 0 rows

Fathah Rehman P Over a year ago

you mean you run query directly in MySql right? Then there should be some problem in your query. Error may be in "date='25/06/12'" part of the query.

Fathah Rehman P Over a year ago

please execute "SELECT intime FROM employee WHERE emp_id='1'" and tell me result

Jayashri Over a year ago

I am taking the date value from the Textbox..and match that value to tables contents..and retrived the record from table.and datatype of date field in table is text..so what is problem..i cant guess

Jayashri Over a year ago

I tried this it giving error:MySQL returned an empty result set

|

Wouter Dorgelo · Accepted Answer · 2012-07-16 12:00:15Z

0

Try something like

SELECT intime FROM employee WHERE emp_id='1' AND date like '25/06/12'

edited Jul 16, 2012 at 12:00

Wouter Dorgelo

12.1k12 gold badges67 silver badges80 bronze badges

answered Jun 26, 2012 at 6:39

Zaz Gmy

4,3663 gold badges22 silver badges31 bronze badges

1 Comment

Jayashri Over a year ago

I have tried this but it gives error :MySQL returned an empty result set (i.e. zero rows).

Collectives™ on Stack Overflow

Java: Empty ResultSet when retrieving record from MySQL

4 Answers 4

Comments

Comments

14 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

14 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related