₦airaland Forum

Wicked...shey na money? We go make am.

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.

sauceTDA:
Wots touching about this?

I guess you have similar heart with this fellow then

JeffreyJamez:
.......maybe my heart is made of Stone after all

frakdon:
bros, I know who that your friend is...

Who is it then?

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]

and then...these

and some more

some more shots

iceberylin:
It's not new.....

ok...but it is to me, actually

more screenshots

I came across this on Facebook. A friend of mine posted it and it really touched me after i read it. I feel more for the guy who is left with so much hurt and broken-heart. I thought i would be nice to share it with you guys here. View the pictures of the chat below.

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.

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:
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.

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

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?

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.

confirm!

shey the phone dey see future?

Specialbaby:
The blame goes to those girls who despite knowing how naughty he is gave in to his advances.



He is such a disgrace!

You sound as though he refused to succumb to your advances, rather...tho!

epospiky@gmail.com

Ride on dude. I'm fully following.

danvery2k6:
So Java does this thing called implicit type casting. When you try to perform arithmetic between another type and an Integer, the other type gets converted to an integer. its better you would have multiplied by doubles, say 2.0, 3.0, etc.

uhmmm...i don't think there will be a problem if multiply them by integers(say 2,3 e.t.c). All datas entered are in integer data type except the result which of course i expect to be in double data type.

danvery2k6:
In addition to what the poster above me said, why are multiplying with integers?

yeah, i am multiplying the integers by those numbers in order to have specific values which i didn't declare at the beginning. Each data when entered is multiplied by the value of the textfield kinda.

omohayek:
Your error is in using '/' to divide by 19, as in Java this will give a rounded result. Change 19 to 19.0 to force it to be a double.

Thanks bro. It really worked. But there is another problem. It is giving me too many long numbers after the decimal point. I want it to round off the number to exactly two decimal places. How can i achieve that?

sunnico:
i think the issue is with ur data1,data2..., did u define them as an integer type,
if yes u can either change thier data type to double or use a cast operator i.e
double setResult = double((data1*2)+(data2*3)+(data3*3)+(dat4*2)+(data5*2))/19;


*note public is used to reference variables outside the class not inside it, from the little i know

yeah i defined them as integers kind of. I couldn't get string value directly from the textfield so i converted them from string to integer using Integer.parseInteger().
This is how i actually declared the result to be
public double setResult {
(return
(data1*2)+(data2*3)+(data3*3)+(dat4*2)+(data5**3))/19}

sunnico:
Can u post your code also

I am not with my pc right now. I will post the full code later in the evening if need be. Here is how i declared the method to be kind of.

poblic double setResult = ((data1*2)+(data2*3)+(data3*3)+(dat4*2)+(data5*2)/19

I tried writing a simple program which can calculate a couple of numbers entered. The result works fine only that that data type (double) which i declared the result to be in gives me a .00 value instead of maybe a .45 value or .86 value. It automatically rounds off the value which is kinda annoying. Anyone in the house who has an idea on this should help me out please.

wait...that's all.