Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Problem in getting correct data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in getting correct data" Watch "Problem in getting correct data" New topic

Problem in getting correct data

duhit Choudhary
Ranch Hand

Joined: Apr 01, 2012
Posts: 64
Hi all,
I wrote a program to insert user details from a website into a database table. all the program is working fine except a thing, which is, the database is not taking the correct value although i am getting the correct value at the console..
here is my code and details:

and the line from where i am inserting the data into database is:

the above code is in separate class and there is another class where i defined setter getter methods:

dto is the object of the class in which i have defined setter getter methods.

now the output i m getting on console is:

Collinsville, IL
United States
Address : Collinsville, IL
United States

but on the database table it is entering oly first line of the output at Address column... like- Collinsville, IL
please help me out to get the correct and full data in the table..

Thanks in advance
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565


can you try to use PreparedStatement and parameters, in stead of collating a n sql string together?

How do you check what has been entered in the database? What tool are you using to look at the values?
What does your database table looklike?

Regards, Jan

OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: Problem in getting correct data
It's not a secret anymore!