Originally posted by stan tsun:
Hi, I was wondering if someone could give me any sort of help with a class project I am working on. Me and a group of my friends just started learning java and as part of a project we are working on we have to develop a simulation of a banking system that assigns lockers to customers, my part of deals with saving the locker operations that are recorded into memory to a persistant storage (SQL server). I also have to make error messages for if there are no changes made and success messages but im mainly concerned with saving from internal memory to the server. How do I do that? If someone could help a beginner out, I would greatly appreciate it... Thanks to all
How much Java do you know? We can't give you a hint in the right direction if we don't know where you are at. Here is a start...
1. Java access Databases via the use of the JDBC API. This may be the first place to start -- unless you have a different API to use instead.
2. SQL Server is not a DB that many containers support by default -- so you'll need to go to the Microsoft MSDN website to download the latest JDBC driver for SQL Server. BTW, all versions of the driver should be available for free. And I believe the driver for the SQL Server 2005 version just went out of beta.
3. And of course, you'll also need to know SQL -- which hopefully, you already know.