Query does not return output

Question

I'm writing a program where when user selects a certain choice using radio buttons, then parameters and sql statements get assigned:

if(r1.isSelected())//SNo
    {
        cmd="SELECT * FROM CALLDETAILS WHERE SNo=?";
        parameter=tf1.getText();

    }
    else if(r2.isSelected())//Month-wise
    {
        cmd="SELECT SNO, DATE, COMPANY,STATUS FROM CALLDETAILS WHERE MONTH(DATE)=?";
        parameter=tf1.getText();
    }
    else if(r2.isSelected())//Username
    {
        cmd="SELECT * FROM CALLDETAILS WHERE ATTENDED_BY=?";
        parameter=tf1.getText();
    }
    else if(r3.isSelected())//Company
    {
       cmd="SELECT * FROM CALLDETAILS WHERE COMPANY=?";
        parameter=tf1.getText();
    }
    else//Status
    {
        cmd="SELECT * FROM CALLDETAILS WHERE Status=?";//Resolved. in process, pending
        parameter=tf1.getText();            
    }

When I run this:

try
    {

        Connection con=DriverManager.getConnection("jdbc:mysql://localhost/tenderdetails?user=root&password=");
        PreparedStatement ps;
        ps=con.prepareCall(cmd);
        ps.setString(1,parameter);

        ResultSet rs=ps.executeQuery();       

        while(rs.next())
        {
            int sno=rs.getInt(1);
            Timestamp dt=rs.getTimestamp(2);           
            System.out.println(sno+ "  "+dt);//HERE!
        }

        con.close();
        System.out.println("here too");
    }

    catch(SQLException se)
    {
        JOptionPane.showMessageDialog(this, "Error: "+se.getMessage());
    }

There is no output of the statement marked HERE. Why is that?

It seems your query not returning any thing (while loop not executing at all). — kosa
– kosa, Commented Jul 30, 2013 at 16:15
But my database is returning values otherwise... in the mysql server. — user2602294
– user2602294, Commented Jul 30, 2013 at 16:17

Joachim Isaksson · Accepted Answer · 2013-07-30 16:17:22Z

3

It would seem that your statements aren't necessarily set to what you think;

else if(r2.isSelected())//Month-wise   // <-- r2
{
    cmd="SELECT SNO, DATE, COMPANY,STATUS FROM CALLDETAILS WHERE MONTH(DATE)=?";
    parameter=tf1.getText();
}
else if(r2.isSelected())//Username     // <-- r2 again...? Won't ever be hit.

Also, although most likely not your problem, getInt(1) and getTimestamp(2) seem a bit dangerous with SELECT *.

answered Jul 30, 2013 at 16:17

Joachim Isaksson

182k28 gold badges297 silver badges307 bronze badges

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

1 Comment

user2602294 Over a year ago

I intend to change the SELECT *. That was just to get the code running.

JDuarteDJ · Accepted Answer · 2013-07-30 16:30:50Z

0

check the getConnection() string and your Query/Prepared statement.

Since it doesn't return any results the problem is likely here.

answered Jul 30, 2013 at 16:30

JDuarteDJ

1,10612 silver badges25 bronze badges

Collectives™ on Stack Overflow

Query does not return output

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related