Hi, I am writing a database program, and I decided I should try and use MySQL since many people have told me it is the best way to make a database. Does the java version that Sun provide come with the api to create mysql databases?
Also, I would like to know of a good tutorial that teaches MySQL with java.
> Hi, I am writing a database program, and I decided I
> should try and use MySQL since many people have told
> me it is the best way to make a database.
That all depends on what you mean by "best". What do you need to do with it?
> Does the
> java version that Sun provide come with the api to
> create mysql databases?
No, you need to download the mysql JDBC drivers and add them to your classpath.
> Also, I would like to know of a good tutorial that
> teaches MySQL with java.
[url=http://www.developer.com/java/data/article.php/3417381]Everything you could have wanted to know[/url].
> Hi, I am writing a database program, and I decided I
> should try and use MySQL since many people have told
> me it is the best way to make a database. Does the
> java version that Sun provide come with the api to
> create mysql databases?
>
You are more than a bit confused so please stop here until you understand the following.
JDBC is the API for communicating with relational databases in Java. It is not a database in and of itself but it can communicate with any database that provides JDBC API access in the form of a JDBC driver.
> Also, I would like to know of a good tutorial that
> teaches MySQL with java.
The Sun tutorial on JDBC may be found here http://java.sun.com/docs/books/tutorial/jdbc/index.html
Your using (or not) MySQL is not relevent on this forum and any questions you have regarding MySQL (with the exception of one) are beyond the scope of this forum.
The exception is "Is there a JDBC driver for MySQL and how do I use it". The answer to that question is yes and see this http://www.mysql.com/products/connector/j/
This database is to handle a group of volunteers, ( their personal information in one section, daily attendance, duties of each volunteer...)....
Also, their needs to be restrictions on which users are allowd to perform which actions. So... for example, only a "level 2" user can add a volunteer to a duty list, but only a "level 4" person can access a volunteers personal information if needed.
