wood burning stoves 2.0*
The moose likes JDBC and the fly likes Connecting to database from JSP through JDC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to database from JSP through JDC" Watch "Connecting to database from JSP through JDC" New topic

Connecting to database from JSP through JDC

Mohan Ravi

Joined: Jun 07, 2006
Posts: 1
Hi All,

Can you please help me as I am new to this tomcat and jsp

For example if I have a database(datasource):StudentProfile
Columns: StudentNo, Student_FirstName, Student_LastName, Student_Grade

1. How do I connect to the DB from this student.jsp
2. Display all the records (Select * from Student)
3. how do I update the grade. (Update Student set Student_Grade = ? where studentNo = ?)

Please help me.

Christophe Verré

Joined: Nov 24, 2005
Posts: 14687

After reading the following, try yourself and post again when you have problems. Good luck.


[My Blog]
All roads lead to JavaRanch
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 60782

Moved to the JDBC forum.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
jQuery in Action, 2nd edition
subject: Connecting to database from JSP through JDC
Similar Threads
Problem in JSP with respect to combo box.
how can i fire update query in struts?
how can I update xml file in java?
it is for retriving data from database
can some one help me im just new in java.