Project Advice

BizzyC

Ok,

I have to build a website for pics so that people can create accounts to display and edit their photos.

Problem is I have to use MySQL for the database, not used to it, I have to use JSP which I've never seen before and create a Java Applet which is new to me.

Anyone suggest the best way to go about this?

I know Java, and Oracle just never used MySQL or JSP.

clearz

rofl.

Seth Brundle

You are taking the piss!
You know Oracle but can't get your head around MySQL?
You know java but can't get your head around JSP?
Is this for a college project?

Seth Brundle

re-read - you know java but can't make an applet????????????????????????????????????
FFS!

madramor

Step 1:
learn the technologies you have to use.
1:1
JSP use the tutorial http://java.sun.com/developer/onlineTraining/JSPIntro/
you will need the latest version of tomcat 5.5.4 to run the JSPs
1:2
MySql you dont really need to know much about this, if you know oracle, just
use the tools to craete accounts and tables.see mysql docs
1:3
JDBC you need this to connect the JSPs to the database.
http://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/
1:4
Applets are basically just java code inside an apples class
http://java.sun.com/docs/books/tutorial/applet/index.html

Step 2
design your project, have the view section,the edit section, the comms section, the database access section,etc..

extras
1 You can use database connection pooling to manage DB connections
2 You can use JSTL to help you write code
3 You can use the MVC pattern

also
I know Java
what java do you know

BizzyC

I never said I couldn't get my head around them, just that I've never seen them before.
I wasn't looking for code or a detailed explanation.

It is for college, but has do be done independantly, ie they haven't tought us MySQL or JSP, I've been doing Java for 3 years, dont know how to make applets as I've never done it before, it's the first web-based project I've ever done.

Thanks Madramor, that's the kind of help I was looking for.

Stark

You probably won't even need applets, it's more likely servlets that you're looking for.

BizzyC

I have to use an applet so photos can be edited with the Java Advanced Imaging API.