Jdbc Jdbc Steps

This Site is worth a look through a very gainful and useful experience

Thank you

Posted by Minhaj on Saturday, 06.30.07 @ 17:29pm | #20440

Hi,

Since the field in the table are of string type:

`employee_name` varchar(50) NOT NULL,

So, the code is correct.

Thanks

Posted by Deepak Kumar on Thursday, 05.17.07 @ 19:19pm | #16275

The JDBC with MySQL is too good.
one small change in the following Url:
http://www.roseindia.net/jdbc/jdbc-steps.shtml:
-----------------------------------------------
Getting Results
In this step we receives the result of execute statement. In this case we will fetch the employees records from the recordset object and show on the console. Here is the code:
while (res.next()) {
String employeeName = res.getInt( " employee_name " );
System.out.println( employeeName );
}
-------------------------------------------------
here the Employee name is String not Integer.
it must be res.getString(employee_name");

thanks

Nag

Posted by Nag on Wednesday, 05.16.07 @ 22:10pm | #16166