Jdbc quick Start

Question

Level 1

53 points

Jdbc quick Start

Hi All,
first of all i'm sorry if this subject is placed in the wrong category, couldn't find the right one
i am expert in Graphic design and use usually Adobe software : Photoshop, Premiere, After Effect, InDesign ... and 3D Software and others....
i Teache also in my university Java language (for beginners) ...
i am now about learning how to build a Complete Database Application...
Many of my collegues here in the University Use Visual Basics and advise me to learn and use it.... But,
Since i Know Java Language and teache it (only General Java : the logic-loops-classes-object oriented- and so), and also LOVE it and find it nice and strong, i prefer to use it in this target ....
i am asking about the way to QUICK LEARN how to build a Complete Database Application using Jdbc-Sql ....
i am an expert in many kinds of softwares ... BUT in the level ZERO in the domain of Database-jdbc-connection ....

in fact, what i must to do to start and get a Jdbc driver and a software handeling a DataBase??
where i must write the code ??
How to compile it ??
i am Running MacOS 10.5 intel, what are the tools i must to have in order to Start Physically the work...

PLEASE HELP ME to quick learn and use Jdbc and its Family
Many Thanks

imac, Mac OS X (10.5.3)

Posted on Jan 27, 2009 12:20 PM

Reply

Answer 1

Ahmad Issawi Author

Level 1

53 points

Jan 28, 2009 10:56 AM in response to Ahmad Issawi

Hi all Dears...

What i neeeeeeeed is a Help in the following :
--> The Free Tool where i write the code and compile it
--> The Free Tool where i write the database and save and access it...
--> How to connect to this Database from the JavaTool ...
--> Where to set All the parts of the stuff (Control Panel?, Extension?,...)

All the following stuffs are clear for me and i DONT need any help...
--> Using the SQL statements
--> Writing Java Code
--> Making GUI using Swing or others
--> Access The Database (Select-Update-Delete-Insert.....)
Because i learned All these theorically ....

Simply, What i need is a help how to practice these theories ..
i need some one to write me a help like this :
1) Go to www.XXX and download XXX and write your code here.
2) Go to www.XXX and download XXX and Make your DataBase here.
3) Open XXX(controlPanel?? other?? i dont know what...) in your Mac, and in order to set the connection do the following : XXX, YYY, ZZZ ...
4) ...
5) ....
And so on ...

in fact All my freinds here are Ms Windows user... and i am the only MAC user ... they use VB.net with sqlserver with a lot of available tools for their OS ... so i need only a push-up in the Software levels ...
PLEASE HELP
Many Thanks

Reply

Answer 2

ericmeyers

Level 4

1,410 points

Jan 28, 2009 12:02 PM in response to Ahmad Issawi

Install XCode from http://developer.apple.com to get the Java compilers.

Install jTDS to get a free JDBC driver for Microsoft SQL Server (assuming that's the database type you are targeting). I'm assuming it is based on your VB comments.

http://jtds.sourceforge.net/

Eric

Reply

Answer 3

Ahmad Issawi Author

Level 1

53 points

Jan 30, 2009 5:06 AM in response to ericmeyers

Dear Eric,
First, Let me Thank you for your help...
Second, i don't have a quick connection enough to download XCode from http://developer.apple.com,
However, i found it on My Original OSX DVD coming with my iMac... is it true???is This what you mean??

Install jTDS to get a free JDBC driver for Microsoft SQL Server
(assuming that's the database type you are targeting).
I'm assuming it is based on your VB comments.

Please note that it is NOT necessary to use the same tools my freinds use on their OS windows...
i am NOT obligated to folow them... simply i ask about the Best Tools for My LOVELY MAC OSX...
is MySql the best tool to write the database?? other??
where i must to write my code??NetBeans?? Xcode??eclipse??JBuilder??
What do you advise me ??
and How exactelly to make the connection ?? is there a control panel on my mac that does the stuff?? other ??
Many Thanks

Reply

Answer 4

ericmeyers

Level 4

1,410 points

Jan 30, 2009 3:23 PM in response to Ahmad Issawi

Yes you can use the XCode on the install DVD.

There is a jdbc driver for MySQL ...

http://dev.mysql.com/downloads/connector/j/3.1.html

As for making connections, I suggest you read some tutorials on jdbc. Here's a start.

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

Eric

Reply

Answer 5

Ahmad Issawi Author

Level 1

53 points

Jan 31, 2009 1:41 PM in response to ericmeyers

Hi Mr. Eric and all other freinds...
In fact, i am now in the following step :
1) i Downloaded SQLEditor
( http://www.malcolmhardie.com/sqledit...itor-1-4-1.dmg)
and maked a small database (2 tables for trying)...
i tried to fill some records (Rows)... i can not find where to enter the Data ...
i think that i set only the DataBase there and then enter Records from the Java Program itself ...true??

2) i downloaded NetBeans and i try now to connect to the DataBase i made ...
This is My problem now :
a> WHERE to connect and HOW ???
b> When i write : Class.forName("What i must to put here????");
c> is there a driver i must to download???

All the tutorial i read, give helps for Ms.Windows user !!!! Please Mac experts help me Please ...

(in other hand, i tried to download Mysql for mac from :
http://dev.mysql.com/downloads/mysql/?rz=gdl#downloads
... the versions are for PowerPc and not for my Intel iMac... i downloaded the Powerpc 64bit version .... it can not be installed ...??)

Many Thanks for any clear Help

Reply

Answer 6

ericmeyers

Level 4

1,410 points

Jan 31, 2009 2:04 PM in response to Ahmad Issawi

Ahmad Issawi wrote:
Hi Mr. Eric and all other freinds...
c> is there a driver i must to download???

I think I answered that already.

http://www.mysql.com/products/connector/j/

There are a ton of examples (Google) on using jdbc with MySQL. Here's just one ...

http://www.kitebird.com/articles/jdbc.html

The Connector/J docs also have several.

(in other hand, i tried to download Mysql for mac from :
http://dev.mysql.com/downloads/mysql/?rz=gdl#downloads
... the versions are for PowerPc and not for my Intel iMac... i downloaded the Powerpc 64bit version .... it can not be installed ...??)

Heh? There is clearly several 10.5 x86 versions on the site.

!http://img101.imageshack.us/img101/2682/picture1kw4.png!

Ahmad, I think you may need to start a new thread as this discussion is beginning to warp into other issues. You'll get better responses if you do. Good luck.

Eric

Reply