• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySql

 
Swapna latha
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all ! i know how to do programs and connect to jdbc for oracle.

But i am getting confused with MySql. What is this connector j ? Can anybody help me out in creating tables,jdbc connections in MySql ? Any links, pdfs, materials, books, sites please help me ?

Thanks & Regards
Kori Swapna Latha
 
Shankh Pani Parimal
Greenhorn
Posts: 8
Eclipse IDE Java jQuery
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Swapna, It will help you:-



It will return the connection with MySqlDataBase with url "jdbc:mysql://bsl-ritu/pearlstine" , User "root", Password "123456".
 
Rob Spoor
Sheriff
Pie
Posts: 20610
63
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Connector/J is just MySQL's JDBC driver implementation. Similarly there are Connector/Net for connecting to MySQL databases from .NET and Connector/ODBC for connecting using ODBC.

Some useful links:
JDBC
MySQL
 
Swapna latha
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks phani and Rob.

Still i have confusion regarding connector j. without connector j phani has given code and whats the use of connectorj then ?
 
Rob Spoor
Sheriff
Pie
Posts: 20610
63
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Connector/J include the com.mysql.jdbc.Driver class that's loaded in that little piece of code. Without the Connector/J JAR file that line would throw a ClassNotFoundException.
 
Shankh Pani Parimal
Greenhorn
Posts: 8
Eclipse IDE Java jQuery
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't confuse yourself with connector j, it internaly work with in driver package ("com.mysql.jdbc.Driver "). Driver automaticaly create connection using Connector/j.

Shankh
 
Raj Bansilal Champaneriya
Ranch Hand
Posts: 36
Java Linux MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Most of our applications require database for storing data. Programs written in many languages and they might use different databases to store data.

For communicating with database programming languages need some mechanism to convert their database call into Database specific code for executing SQL commands. Here the mechanism is written in driver specific to databases. Sun has given a specification in which all interfaces were given to all database vendors for creating driver that support JDBC.

So we can say JDBC work as middle ware between application and database driver.

See this link you'll be very clear about JDBC Driver.

http://www.tutorialspoint.com/jdbc/jdbc-driver-types.htm
 
Swapna latha
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Raj Bansilal. You have shown me a good website to learn. If you know any good websites like this please share it to me so that i can update myself. Please update me by sending the list to my private message box
 
Rob Spoor
Sheriff
Pie
Posts: 20610
63
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Swapna latha wrote:Please update me by sending the list to my private message box

Please don't. UseTheForumNotEmail (or private messages).
 
Shankh Pani Parimal
Greenhorn
Posts: 8
Eclipse IDE Java jQuery
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Shankh Pani Parimal wrote:Hi Swapna, It will help you:-



It will return the connection with MySqlDataBase with url "jdbc:mysql://bsl-ritu/pearlstine" , User "root", Password "123456".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic