aspose file tools*
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
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: 119
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: 61413
    
  67

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: 61413
    
  67

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: 537

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..
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: 61413
    
  67

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: 509
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: 119
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