Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

doubts on JDBC

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All

I have some doubts on JSP.I'm in the learning phase of JSP.

In firstpage.jsp with fields like First Name,Last Name,Phone Number.I have to store the field values in MySql.Iam using NetBeans IDE+TomCat Server.

I need to know exact Connection statements to store those field values.
Anyone please mention me some sample codes for it....


Next one is: In secondpage.jsp,I have UserName and Password.I have to show the field UserName(xyz) has been regitered in the next JSP page(say thirdpage.jsp).

Will href tag helps out in solving this issue?

Can anyone reply me for these 2 queries?

I have designed the page only database connection is leftover.

I have refered some Websites,but I didn't get clear idea.

Thank you!!!
[ March 25, 2005: Message edited by: Bear Bibeault ]
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your best bet is to look for a JDBC tutorial..
This one is good:
http://csajsp-chapters.corewebprogramming.com/CSAJSP-Chapter18.pdf

A Google search will give you plenty more.
 
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you want to connect to a MySQL database, you could make an abstract class which contains the exact connection statement, referring to the class driver you are using. If you are to change this driver, there's only one place where you have to change the source code.

Here's the abstract class.

 
Sheriff
Posts: 67403
173
Mac Mac OS X IntelliJ IDE jQuery Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to JDBC.
 
Won't you please? Please won't you be my neighbor? - Fred Rogers. Tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic