database connection in struts program

Question

1.00/5 (1 vote)

See more:

hi,
i wanted to know how many class files I hava to make for a database program in struts frame work.i want to know the step by step process for creating a database connection with MYSQL and also that piece of code...

I m making a log-in page in struts application ..so I couldn't understand how can i fetch out an entire data base of a single person by giving user-id detail in log-in page by a database connection on program..

* i don't want any link for this answer,must be a satisfying theoretical answr

thanx ,
trupti

Posted 25-Apr-13 22:42pm

Trupti001

Updated 25-Apr-13 23:07pm

Richard MacCutchan

v4

Add a Solution

Comments

Shubhashish_Mandal 26-Apr-13 4:46am

To create database connection is very easy and for mysql you need only one jar file. But you have to tell me which version of struts you using and do you want to create simple connection or want to create datasource?

Trupti001 26-Apr-13 5:31am

struts 2.1 and simple connection......

thanx.

Trupti001 26-Apr-13 5:00am

through "add project capabilities" when i m adding struts 2.1 (in myeclipse) also i m not getting that tld file in my project

Shubhashish_Mandal 26-Apr-13 5:06am

Is your previous issue resolved? If yes then start a new thread to ask your next question.

Richard MacCutchan 26-Apr-13 5:08am

Please don't make demands in your questions. You are not paying for answers so you will have to be satisfied with what you get.

Trupti001 26-Apr-13 5:19am

ok......

thanx

Trupti001 26-Apr-13 5:19am

I m using struts 2.1 simple connection

Shubhashish_Mandal 26-Apr-13 9:20am

In that case , as I told you before that only one jar file you need for JDBC with mysql . Download mysql connector jar file. Create a connection class which will return the connection .
And use this connection to retrieve info from database.
N.B. : I suggest you to use Connection Pool to create connection.

Trupti001 27-Apr-13 10:27am

hii,
I hv that mysql connection jar files bt don't know how to creat a connection pool

Shubhashish_Mandal 28-Apr-13 1:16am

pool is nothing but a well managed connection queue.So google it, you will get lots of example .

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)