This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Project Advice

 
Teri Fisher
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Java Experts!
I am planning to start a project for a friend who has a painting business, I plan to create something where she can add and/or edit clients in her database, create an invoice for clients with several options with the type of work done at the site and so on. I originally started writing this in VB.net but now I have not used it for quite some time and was wondering if anyone thought it would be best to create this using java instead or something else. I wrote a short requirements doc that I can work from. My next class is C/C++ this summer but I would still like to continue working on my java. Thanks in advance for any input!!
 
Amit Ghorpade
Bartender
Posts: 2854
10
Fedora Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I think you should opt for Java if you really need a full fledged web application. The reason behind this is you will have some really powerful frameworks at hand while doing this and you'll also get to learn a lot and not to mention the benefits of choosing Java!!



Hope this helps
 
Campbell Ritchie
Sheriff
Posts: 51448
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome back, Teri, but to the wrong place. I am moving you.
 
Campbell Ritchie
Sheriff
Posts: 51448
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"A little learning is a dangerous thing."
Careful what you do, and make sure you don't go into unfamiliar territory.

The reason I moved you is that I think it is the database bit which will be harder to program, and you need to get that bit correct. If you have that correct, then connecting from Java is relatively simple.

Have you done any database programming or SQL? That is what you need. You also need a "real" database program; you will probably find something like MySQL suitable. MySQL is open-source so you don't have to pay for it.

If you want a book about it, there are lots on the market. A good choice might be R Sheldon G Moes, Beginning MySQL, Wiley (Wrox "Programmer to Programmer" series) 2005.
The good news is: I got a copy of it myself last Summer for about �12 (US$23). The bad news is: I can't remember who sold it and I can't find it for that price.
Not only does it describe MySQL, it also has a nice little SQL tutorial in, and tells you how to set up database tables, and how to normalise them, and how to get rid of crow's feet. You won't understand this until you read the book, but remember, a line joining two tables must never have crow's feet at both ends. Or, if you use 0..1 terminology, you must never have 0..n at both ends. Some people use 0..* instead of 0..n, and 1..n is just as bad.

Once you are up to speed, it will take some time to set up your friend's database. Several hours, at least.

When you have got your database and SQL working, come back to beginner's with Java-related questions.
 
Campbell Ritchie
Sheriff
Posts: 51448
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sheldon and Moes don't cover stored procedures, transactions, views, triggers and events, because all these features were added to MySQL after their book was printed. You will probably need several of them; look through the tutorial on the MySQL website, or find a general SQL tutorial; there are several tutorials available free for googling.
 
Teri Fisher
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have taken a few SQL classes and have SQL 2005 Express on my computer, how is this different than MySQL? So you think I should build my database first?
 
Campbell Ritchie
Sheriff
Posts: 51448
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can probably do the same with SQL express, though I am not familiar with it. Go through the SQL express website and it should give all the details, tutorial, etc.

Yes, I think you should build the database first, and get it working from the command line, then set up a JDBC connection and get that working from the command line or a main method, then add a Swing GUI.
 
Campbell Ritchie
Sheriff
Posts: 51448
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I see SQL Express is a version of SQL Server. It is bound to have the same functionality, but it does have some peculiarities of its own.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic