From next week,i will be embacking on a second project that involves java codes to operate within the intranet. I already have it on a standalone system, so do i need to use servlet, jsp? or i can work on the standalone to achieve this? Note that it is a database connectivity storage project.
Its a bit vague what you are after. When you say "operate within the intranet" do you mean you need a technology which can open connections to other nodes in a network? If so look at the java.net package.
You would only normally use Servlets/JSP if you intended to write a web based applicaton for multiple users. Is that a requirement?
You mention a database, so I'll also direct you to JDBC.