aspose file tools*
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
Author

Connecting to database from JSP through JDC

Mohan Ravi
Greenhorn

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
Table:Student
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.

Thanks
MR
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

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

http://faq.javaranch.com/view?GeneralJdbcQuestions


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

Joined: Jan 10, 2002
Posts: 61661
    
  67

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to database from JSP through JDC