Mickeys
asked on
How would you write this database method for sending and [ ] [ ] back
public String[][] getTheHistory(String flightNo, String date)
{
// Columns = {"Bokningsnummer", "Flightnummer", "Date", "PersonId", "FirstName", "Lastname", "Type", "Help", "SeatNr", "Price"};
String [][] temp = new String[1][10];
temp[0][0] = "123";
temp[0][1] = "LK202";
temp[0][2] = "2010-01-01";
temp[0][3] = "1";
temp[0][4] = "Anders";
temp[0][5] = "Paulsson";
temp[0][6] = "M";
temp[0][7] = "Y";
temp[0][8] = "35";
temp[0][9] = "Black";
return temp;
}
I cant really spot how to write it.
{
// Columns = {"Bokningsnummer", "Flightnummer", "Date", "PersonId", "FirstName", "Lastname", "Type", "Help", "SeatNr", "Price"};
String [][] temp = new String[1][10];
temp[0][0] = "123";
temp[0][1] = "LK202";
temp[0][2] = "2010-01-01";
temp[0][3] = "1";
temp[0][4] = "Anders";
temp[0][5] = "Paulsson";
temp[0][6] = "M";
temp[0][7] = "Y";
temp[0][8] = "35";
temp[0][9] = "Black";
return temp;
}
I cant really spot how to write it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry for that - I din'mean to post it
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You need to go to the databse and say
desc table_name
then it will print you which tables are varchar, which are numbers
desc table_name
then it will print you which tables are varchar, which are numbers
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.