How to retrieve single row from MSSQL

Question

0.00/5 (No votes)

See more:

Hello sir,

Sir i had created the table in MSSQL,the fields with patient name,pid,Dname(doctor name),technician name.Here it contains say four names in the table.I had created the patient name and doc name and search button in GUI window.What i want is after giving the name of both patient & doctor,after clicking the search button.It has to display patient details accordingly,that what is present in his row.I mean only his row has to be displayed in the next Jpanel within same window.I created table in MSSQL,GUI in eclipse.How to achieve it..

Help me in this regard..

Thanks & Regards
Pradeep

Posted 10-Jan-12 19:42pm

Pradeep CBZ

Add a Solution

1 solution

Add a Solution

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)

TorstenH. · Answer 1 · 2012-01-10T20:52:00

No need to post the same question again - you could simply answer in the original question:

Retrieving the single row from MSSQL into the GUI window[^]

I have posted 2 links. Read what is written there. You need to connect your program to the database - you can use JDBC for that (weblink 2). After you have established the connection you will need to ask the database for the desired data. How to create that query is described in weblink 1.

I also recommend to buy a book about general java programming. It's got the advantage that you do not need to know where to search. Most Java books cover the connection to a database via JDBC.