Databse Connection using JSP.

How can I connect to Database using JSP?
Where will I put the JSP files?How will I create Bean component to connect to database?
vxlbagAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shaveriCommented:
Database reference.......
 
                http://java.sun.com/products/jdk/1.1/docs/guide/jdbc/index.html 
                http://java.sun.com/products/jdbc/index.html 
                http://java.sun.com/docs/books/jdbc/intro.html 
                http://java.sun.com/products/jdbc/faq.html 

                Silicaon Valley Java SIG JDBC Talk Page
                http://www.hooked.net/~gturner/JDBCTalk.html 

                Java how-to DB section
                http://tactika.com/realhome/javaht/java-d1.html 

                articles from Oracle:
                http://technet.oracle.com/tech/java/sqlj_jdbc/index.htm 

                JDBC 2.0 New Features
                http://java.sun.com/products/jdk/1.3/docs/guide/jdbc/getstart/appendixA.html#1006294

                http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/index.html 


                MS bridge
                http://www.microsoft.com/Java/sdk/relnotes/JDBCrel.htm 

                Drivers:
                http://java.sun.com/products/jdbc/drivers.html 
                http://www.idssoftware.com/jdriver.htm 

                Books online
                http://www.itknowledge.com/reference/standard/1576100561/book-index.html 
                Java Database Programming with JDBC
                http://www.itknowledge.com/reference/standard/1576100561/book-index.html 
                Java 1.2 Unleashed : Connecting to Databases with the java.sql Package
                http://www.itknowledge.com/reference/standard/1575213893/ch44/ch44.htm 

                and some useful DB stuff:
                InstantDB
                http://208.234.21.207/ 

                WebLogic JDBC (30 day trial)
                http://www.beasys.com/download/weblogic.html 

                http://www.thoughtinc.com/cocofree/doc/index.html 

                http://www.agave.com/html/products/jdbc_dwnld.htm 

                --
                Multilingual Databases and Global Internet Integration
                http://www.chg.ru/inet97/A8/A8_2.HTM 

0
vxlbagAuthor Commented:
If I get the code on how to do it will be helpful
0
zhongbingCommented:
Don't be frightened of the long book list. to access database with JSP, you need to know 2 things:
1. who to write JSP, and how to use Java object(Bean) in jsp file.(i guess you already know that?)

2. in the java bean object, use JDBC to access a database. shaveri's first serveal bookmark are enough.

0
vladi21Commented:
JavaServer Pages at Sun Microsystems
http://java.sun.com/products/jsp/index.html

Introduction to JavaServer Pages
http://developer.netscape.com/viewsource/kuslich_jsp/kuslich_jsp.html

The Resource Directory
http://www.serverpages.com/Java_Server_Pages/

JSP FAQ by Richard Vowles
http://www.esperanto.org.nz/jsp/jspfaq.html

Examples from Java Servlet Programming
http://www.servlets.com/jsp/examples/index.html

Professional Java Server Programming: Code Examples
http://apache.wrox.co.uk/projsp/

server-side Java to existing Web servers, including Microsoft's IIS, Netscape's Enterprise Server, Apache, and more.
http://www.allaire.com/products/jrun/

Book
http://www.esperanto.org.nz/jspbook/

http://java.sun.com/docs/books/tutorial/javabeans/index.html
How Do I Create a JavaBean?
http://www.ddj.com/articles/1997/9709/9709m/9709m.htm
Writing JavaBean Property Editors
http://www.ddj.com/articles/1999/9902/9902d/9902d.htm
http://java.sun.com/beans/tools.html

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.