₦airaland Forum

Hi. I am currently learning how to create database in java using SQL. I have successfully implemented commands like add new record, delete new record, update new record, next record, previous record, first record and last record. I am now looking forward to creating a search command in the database but i'm lost on how to go about it. The code is actually my concern. Please anyone with an idea should help me out.

www.java2s.com/Code/Java/Database-SQL-JDBC/JDBCselect.htm

For example if your are asked to find the male or female students use a query to search like

SELECT Male, female FROM Students

don't forget to know the format of your db and remember to use import SQL .

www.tutorialspoint.com/jdbc/jdbc-select-records.htm

Try searching for clues

proxy20:
www.java2s.com/Code/Java/Database-SQL-JDBC/JDBCselect.htm

For example if your are asked to find the male or female students use a query to search like

SELECT Male, female FROM Students

don't forget to know the format of your db and remember to use import SQL .

www.tutorialspoint.com/jdbc/jdbc-select-records.htm

Thanks. From my understanding of what you posted, it seems i am to create a class with the "select" method and the output of the operation is going to be more than one record. I would rather it's just a single output with a particular key query. How about that?

Exactly you need create a class for the method

SELECT * FROM Male



SELECT * FROM ID1.Name

SELECT * FROM Faith WHERE
AGE =19


will select one output from you database .
The ID number or SN is very important in database management .

I think you need to connect your database through local host since you can't put it in in the package explorer by creating a directory and import the db . I don't know if that is possible .


put the zip file of your codes for me to download here on nairaland

ok i'll do just that. Just give me a moment.

proxy20:
Exactly you need create a class for the method

SELECT * FROM Male



SELECT * FROM ID1.Name

SELECT * FROM Faith WHERE
AGE =19


will select one output from you database .
The ID number or SN is very important in database management .

I think you need to connect your database through local host since you can't put it in in the package explorer by creating a directory and import the db . I don't know if that is possible .


put the zip file of your codes for me to download here on nairaland

Here it is.

Thanks bro

epospiky:
Hi. I am currently learning how to create database in java using SQL. I have successfully implemented commands like add new record, delete new record, update new record, next record, previous record, first record and last record. I am now looking forward to creating a search command in the database but i'm lost on how to go about it. The code is actually my concern. Please anyone with an idea should help me out.

First, in the structure of your database while creating it, make an [b] id e.g. in the case of Facebook or username in the case of NL and most sites, you must have a parameter that has an index of PRIMARY which means the value of this input can only be taken on one table row and no other i.e. only one person can use such username or id.

You can query such column after selecting database and connecting to it with select queries like the below

"SELECT * FROM users WHERE id = ?", id

" SELECT * FROM users WHERE username = ?", username


NB: users was used as name of db
id and usernames after comma is how you'll retrieve your cars from db e.g. $_POST or $_REQUEST in PHP[/b]

I made some adjustments . I think you have to create a separate class like select.java .

laykhorn:
First, in the structure of your database while creating it, make an [b] id e.g. in the case of Facebook or username in the case of NL and most sites, you must have a parameter that has an index of PRIMARY which means the value of this input can only be taken on one table row and no other i.e. only one person can use such username or id.

You can query such column after selecting database and connecting to it with select queries like the below

"SELECT * FROM users WHERE id = ?", id

" SELECT * FROM users WHERE username = ?", username


NB: users was used as name of db
id and usernames after comma is how you'll retrieve your cars from db e.g. $_POST or $_REQUEST in PHP[/b]

I used the code in a button but it didn't work for me. It didn't even output anything. When i click on the search button it does nothing as if i never declared it.

proxy20:
I made some adjustments . I think you have to create a separate class like select.java .

Ok...waiting to see how it goes. Thanks dude.

Alright

epospiky:
I used the code in a button but it didn't work for me. It didn't even output anything. When i click on the search button it does nothing as if i never declared it.

Can I have a look at your code? You might have a bug somewhere.



Paste on pastebin.co,m its better there.

laykhorn:
Can I have a look at your code? You might have a bug somewhere.



Paste on pastebin.co,m its better there.

it's done. take a look at it [url="pastebin.com/rNrBD64K"]here[/url]

epospiky:
it's done. take a look at it [url="pastebin.com/rNrBD64K"]here[/url]

busy right now. I'll do in a few hours... If I dont by 6 today, remind me. My Laptop and Tab arent available here

laykhorn:
busy right now. I'll do in a few hours... If I dont by 6 today, remind me. My Laptop and Tab arent available here

Just want to remind you...kind of.

epospiky:
Just want to remind you...kind of.

Just Checked. Sorry, I don't do Java that much. JDBC isn't it for me

laykhorn:
Just Checked. Sorry, I don't do Java that much. JDBC isn't it for me

owkay. No qualms