• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

How to connect to SQL

 
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 219
Firefox Browser Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi thr

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




SCJP 5.0
Dhwani:>Swimmers never weep
 
Sheriff
Posts: 22510
122
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi


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



Dhwani:>Swimmers never weep.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic