What do I use for a J2ee website?

Not sure if I asked this correctly. I am trying to see what I need to create an website that uses MVC and that connects to legacy multiple databases, brining back those database info into one page. I wanted the site to be MVC but am not sure where to begin. Do I use Spring? What do I use for an server? Jboss and apache? Hibernate?

I'm just kind of lost on how to proceed. It's not a straight forward a asp.net mvc or a php framwork.

A major concern is the collection of data from multiple legacy databases 开发者_如何学编程and bringing that data back into one page.

Thanks.

All that you really for MVC in Java is basic servlets and some JSPs.

The servlets are the controllers, which get some model data and stuff it into the request object, then forward execution on the the view.

A quick google to refresh myself of how this works brings this up:

String nextJSP = "/searchResults.jsp";
RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(nextJSP);
dispatcher.forward(request,response);

Once you start working with basic servlets and JSPs, you'll start to see why you might want a framework to start handling some patterns for you. At that point, I'd just look at a few try them out, and pick one.

As this is also my first time through using MVC in Java I'm still using barebones servlets and JSPs and am actually fine with it right now.

Mark

You can use Spring MVC on the server side with Hibernate Connection Pooling as you want your app to connect to multiple existing databases.

Hibernate has a component called dialect which takes care of the configurations of underlying databases. Hibernate Dialect tells your application which SQL language should be used to talk with your database.

DB2

org.hibernate.dialect.DB2Dialect

DB2 AS/400

org.hibernate.dialect.DB2400Dialect

DB2 OS390

org.hibernate.dialect.DB2390Dialect

PostgreSQL

org.hibernate.dialect.PostgreSQLDialect

MySQL

org.hibernate.dialect.MySQLDialect

MySQL with InnoDB

org.hibernate.dialect.MySQLInnoDBDialect

MySQL with MyISAM

org.hibernate.dialect.MySQLMyISAMDialect

Oracle 8

org.hibernate.dialect.OracleDialect

Oracle 9i/10g

org.hibernate.dialect.Oracle9Dialect

Sybase

org.hibernate.dialect.SybaseDialect

Sybase Anywhere

org.hibernate.dialect.SybaseAnywhereDialect

Microsoft SQL Server

org.hibernate.dialect.SQLServerDialect

SAP DB

org.hibernate.dialect.SAPDBDialect

Informix

org.hibernate.dialect.InformixDialect

HypersonicSQL

org.hibernate.dialect.HSQLDialect

Ingres

org.hibernate.dialect.IngresDialect

Progress

org.hibernate.dialect.ProgressDialect

Mckoi SQL

org.hibernate.dialect.MckoiDialect

Interbase

org.hibernate.dialect.InterbaseDialect

Pointbase

org.hibernate.dialect.PointbaseDialect

FrontBase

org.hibernate.dialect.FrontbaseDialect

Firebird

org.hibernate.dialect.FirebirdDialect

As far as server is concerned you can use any server you want.