Help in Java database connectivity with JDBC where data input by user!!

bryan523 · #1 26-Oct-2005, 22:15

Hi all,

Can someone help me to solve this problem? As below coding, i manage to run the program and key in the date, but the selected date i just key in cannot detect by SQL? the program cannot show the data by date that just key in by user on running time??
i used firstDate to collect the date from user and at my SQL queries, i put ".....WHERE LOG_DATE = 'firstDate'......;", but the output show nothing, if i straight put ".....WHERE LOG_DATE = '2005-08-04'.....;", then no problem! This statement true or not?? what should i do?

JAVA Code:

String firstDate;
firstDate = JOptionPane.showInputDialog("Enter Date From(yy-mm-dd):");

try {
            con = DriverManager.getConnection(url, "root", "");
            data = new JDBCPieDataset(con);
            String sql = "SELECT DISTINCT PRIORITY, COUNT(*) FROM STANDARD WHERE LOG_DATE = 'firstDate' GROUP BY PRIORITY;";  //[b]PROBLEM[/b]
            data.executeQuery(sql);
            con.close();
        }

rgds,
Bryan

Paramesh · #2 26-Oct-2005, 22:44

Hi bryan,

When you enter variable name inside an string statement, it will not recognize the variable name. i.e:

JAVA Code:

            String sql = "SELECT DISTINCT PRIORITY, COUNT(*) FROM STANDARD WHERE LOG_DATE = 'firstDate' GROUP BY PRIORITY;";  //PROBLEM

The variable name firstDate is not recognized here.

So what can we do now?
Just enter the variable name by string concatenation.
i.e like this:

JAVA Code:

            String sql = "SELECT DISTINCT PRIORITY, COUNT(*) FROM STANDARD WHERE LOG_DATE = '" + firstDate + "' GROUP BY PRIORITY;";  // NO PROBLEM

This should work!

Regards,
Paramesh.

bryan523 · #3 27-Oct-2005, 00:41

Thanks Paramesh, without your help i think i need a lot of time to do it!

You are the greatest in the world!

Rgds,
Bryan

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Include] Doubly-linked List	dsmith	C Programming Language	6	14-Apr-2006 13:12
[GIM] gim.h	dsmith	C Programming Language	0	18-Jan-2005 08:48
[CONTEST?]Data Structure Test	dsmith	C Programming Language	2	06-Jun-2004 15:13
Script needed for letting user input a few days of data for tracking and analysis.	tradertt	MySQL / PHP Forum	3	06-Mar-2003 02:54

Help in Java database connectivity with JDBC where data input by user!!

Re: Help in Java database connectivity with JDBC where data input by user!!

Re: Help in Java database connectivity with JDBC where data input by user!!