Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect sql server2008 with jsp

 
P Arunkumar
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65115
89
IntelliJ IDE Java jQuery Mac Mac OS X
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Database access should not be done in a JSP. Rather, you should be using proper MVC architecture where DB access happens in the model.
 
Vicky Vijay
Ranch Hand
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arun,

refer the below link,

JSP + JDBC
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65115
89
IntelliJ IDE Java jQuery Mac Mac OS X
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 670
4
Eclipse IDE Java Spring
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 125
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65115
89
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 524
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guru, what could be better place than Oracle Java website.
 
Mary Chellapa
Ranch Hand
Posts: 93
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Plus see reources sections in http://www.coderanch.com/how-to/java/JspFaq
 
P Arunkumar
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi


I need any tutorials or links to develop my project with SQL server. please guide me.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic