• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to connect to SQL

 
dhwani mathur
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 219
Firefox Browser Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
dhwani mathur
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi thr

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




SCJP 5.0
Dhwani:>Swimmers never weep
 
Rob Spoor
Sheriff
Pie
Posts: 20512
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
dhwani mathur
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi


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



Dhwani:>Swimmers never weep.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic