aspose file tools*
The moose likes JDBC and the fly likes How to connect to SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to connect to SQL" Watch "How to connect to SQL" New topic
Author

How to connect to SQL

dhwani mathur
Ranch Hand

Joined: May 08, 2007
Posts: 621
Hi all!!!

i have just started my study with JDBC
Please if anyone can help me on below....

i want to know basics of
1)How to create a database in java?(not only thoertical but)
2)how to connect it with my SQL(i want to learn coding)
3)which are types of drivers?
4)Which are the SQL quieries we require
to access are data from tables in database.........

It will be realy realy great if i get some
help on these doubts............

Thanks in advance..........


Dhwani:>Its always to soon to quit.
Hendy Setyo Mulyo
Ranch Hand

Joined: Dec 01, 2004
Posts: 219

You can read these articles http://java.sun.com/docs/books/tutorial/jdbc/overview/index.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html


Hendy Setyo Mulyo
SCJP 1.4 (95%), SCWCD 1.4 (94%)
dhwani mathur
Ranch Hand

Joined: May 08, 2007
Posts: 621
hi thr

Thanks a lot
for such wonderful links
it realy helps........




SCJP 5.0
Dhwani:>Swimmers never weep
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19543
    
  16

1)How to create a database in java?(not only thoertical but)

Using the CREATE DATABASE sql statement. How it works completely depends on the database type; MS SQL Server might require other special options than Oracle or MySQL does.

2)how to connect it with my SQL(i want to learn coding)

Check the links Hendy gave you. Keep in mind that the driver class name and the connection string are different for each database type; check out the website for the driver on the exact details.

4)Which are the SQL quieries we require to access are data from tables in database

Check out http://www.w3schools.com/sql/default.asp for a short tutorial on SQL in general.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
dhwani mathur
Ranch Hand

Joined: May 08, 2007
Posts: 621
Hi


Thanks Rob Prime for
such a wonderful explanation..!!!



Dhwani:>Swimmers never weep.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to connect to SQL
 
Similar Threads
JDBC Type 4 Drivers
how to push data to database through wcf?
connectivity with my sql without connecting to existing database
Tomcat and jdbc/odbc
SQL Server express 2008 jdbc connection problem