my dog learned polymorphism*
The moose likes JDBC and the fly likes how to connect sql server2008 with jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to connect sql server2008 with jsp" Watch "how to connect sql server2008 with jsp" New topic
Author

how to connect sql server2008 with jsp

P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 118
Hi

Iam new to development field, i connect my jsp page with mysql server but now i wants to connect my sql server with my jsp page please guide me.


Please if any steps is there guide me.

Thanks in advance.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60046
    
  65

Database access should not be done in a JSP. Rather, you should be using proper MVC architecture where DB access happens in the model.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Vicky Vijay
Ranch Hand

Joined: Apr 23, 2008
Posts: 125
Arun,

refer the below link,

JSP + JDBC
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60046
    
  65

roseindia is well-know to be the worst place to rely upon for examples. Bad code and bad practices abound. I would not follow the practices shown at that link.
Prasad Krishnegowda
Ranch Hand

Joined: Apr 25, 2010
Posts: 507

Agree.. If you see the same link, they write Java code(connecting to database) inside JSP, which no good programmer in this era, would ever do..


Regards, Prasad
SCJP 5 (93%)
Vicky Vijay
Ranch Hand

Joined: Apr 23, 2008
Posts: 125
Bear Bibeault,


Can you suggest few Java reference websites (examples holding good practices), so that it would be helpful to refer it.

Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60046
    
  65

Any that follow proper web application architecture that conform to Separation of Concerns, and that do not use Java scriptlets as if it were still 2001.
Saurabh Pillai
Ranch Hand

Joined: Sep 12, 2008
Posts: 498
Guru, what could be better place than Oracle Java website.
Mary Chellapa
Ranch Hand

Joined: Jul 26, 2011
Posts: 93
Plus see reources sections in http://www.coderanch.com/how-to/java/JspFaq


Mary
P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 118
Hi


I need any tutorials or links to develop my project with SQL server. please guide me.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect sql server2008 with jsp
 
Similar Threads
How JSP Connect MS SQL server 2005
How To Connect JSP with MySQL
EJB with MS SQL Database
jsp connection with sql server
jsp connection with sql sever