aspose file tools
The moose likes JDBC and the fly likes Get Data from SQL to my java program Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Get Data from SQL to my java program" Watch "Get Data from SQL to my java program" New topic
Author

Get Data from SQL to my java program

Andrew Cho
Ranch Hand

Joined: Jun 29, 2011
Posts: 50
Hey all,

How do I get data from SQL (a file or server, I don't really know) so that I can use it in my java program (which is a GUI)?
I have a url(***.****.net), a server (i think?), a username and a password.

thanks
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 16483
    
    2

"JDBC" is the keyword you're looking for.
Andrew Cho
Ranch Hand

Joined: Jun 29, 2011
Posts: 50
hye paul.
well I think I have JDBC installed, but I don't really know where to go from there. It seems to me that I need to install a driver that connects to my SQL such as SQL server, or jDTS and also select classpaths and other thing that I don't know. Does this sound right?
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 16483
    
    2

JDBC is part of Java. Yes, you need a JDBC driver. I suggest reading the JDBC tutorial.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 32651
    
    4
Paul Clapham wrote:. . . I suggest reading the JDBC tutorial.
Agree. It's really useful. Start here.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19216

Moving to our very own JDBC forum.


SCJP 1.4 - SCJP 6 - SCWCD 5
How To Ask Questions How To Answer Questions
John Jai
Bartender

Joined: May 31, 2011
Posts: 1776
Andrew Cho wrote:hye paul.
well I think I have JDBC installed,


bit curious - is JDBC a software or a platform. Is jar files enough to create java programs to communicate with DB?
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Get Data from SQL to my java program
 
Similar Threads
JDBC with MS SQL Server 2000
Date Type
connection to mssql server database
Java and MS SQL Server 2000
No suitable driver found for JDBC