Help with JDBC

[Michael Melamu]

Hello

I downloaded a project from this site :http://www.cs.wcupa.edu/~rkline/Java/java-web-store.html
Called webstore.

I imported the project *.war file to eclipse,and added the necessary external jars,the problem is that i dont know how to configure the mysql database to start the project.

I mean that i dont understand the instructions on website about the server part.

if any one can help me and tell me the steps to configure the server and add the database.

I will mostly appreciate it.

Thank you very very much

Michael.

[Jeanne Boyarsky]

Michael,
Welcome to JavaRanch!

That's a long page. Which step specifically are you stuck on?

[Michael Melamu]

Hello

I am stuck here :

Database Setup
This project uses the webstore database with multiple tables. We will assume the guest user with no password has been created. Go into the WebStore folder and run these:

$ mysql -u root < database.sql
$ mysql -u guest webstore < tables.sql
$ mysql -u guest webstore < tables-images.sql

I Have mysql installed,but i dont how to configure it,and even more i dont know where to run these 3 commands.

Any help will be mostly appreciated .
Thanks
Michael

[Fatih Keles]

Hi Micheal,

As you say you have installed mysql you should have the special "root" account.

Follow these steps
1. Start mysql service (this may be helpful)
2. Add a user account named guest (this may be helpful)
3. Go to mysql installation directory/bin (you will have already discovered this after previous steps) and execute the database installation sql files for project in command prompt.

For further help please provide your environment details.

Regards,

Fatih.