jsp database connection

[aman hindustani]

Hello all...

why don't we prefer to create a connection to database in jsp .

[Pratibha Malhotra]

Hi Hindustani

You can no doubt do it. Its doeable also. Infact this is what use to happen in Model 1.

But the question is to provide the best/optimized/scalable....... solution for a problem.

MVC Model 2 gives one such solution, where in
Jsp -> Servlet -> Facade -> DAO -> Database

why don't we prefer to create a connection to database in jsp .

In case you have more doubts, feel free to ask

[saikrishna cinux]

so what is your answer?
am i reducing the performance of application
or am i increasing the complexity of the application by following the mvc1 architecture

am i going for illegal architecture

[Richard Green]

JSPs are meant for display logic. You shouldn't put any business logic / database code in it. Seperating Model, View and Controller makes your application more maintainable.

[abhishek gowlikar]

It is not true that we cannot connect Db from jsp,But it is not a preferable approach:

jsp--->Db like tier 1 model
jsp--->servlets---->dataobjects--->Database MVC Model

Model:Data Objects
View: always The presentation layer have light component(this is the reason we make a Db connection at the Backend may be in DAO or Servlets)
Controller:Here Controller is a Servlets Actions

[Adeel Ansari]

Let me make it clear.

Model 1 is not MVC
Model 2 is also known as MVC

Think about few of these factors you will get your answer.
- code complexity
- maintenance nightmares (includes adding new features, fixing or modifying previous code)
- reusability