JDBC data retrieval with MySQL

[hadesflames]

Ok I have a server with 5+ columns and 5+ rows (the actual amount doesn't matter)

I have the data from column 2, row 4 stored in a variable, how do i then store the data in column 4 row 4 in another variable?

I don't know any MySQL syntax, nor how to use it in java much so if someone could show me a coded example i'd really appreciate it.

[mtyoung]

server with 5+ columns and 5+ rows

table or server?

I have the data from column 2, row 4 stored in a variable, how do i then store the data in column 4 row 4 in another variable?

is that means you want to get data at row4 column 4 from the databases table?

read MySQL :: MySQL 5.0 Reference Manual :: 12.2.8 SELECT Syntax
and Trail: JDBC(TM) Database Access (The Java™ Tutorials)

it is difficult to get data by rowX, columnX
you should use Select select_expr(may be entity name) from table_name where conditions
why you wants data at row4 column 4? it may be data in row4 column1, column 2 etc show that data you want in row4
use where where_condition to get row4

[neilcoffey]

In case it helps as well, a page of mine on reading data from a ResultSet.

The usual procedure is that you structure your query to retrieve more or less the subset of rows that you want, then if necessary, call ResultSet.next() to skip down to the one you want within that subset.

[hadesflames]

I am talking about a table that has a value in column 2 row 4 now i want to get a value from a different column, but of the SAME row as the first one (4) the actual numbers are examples and do not matter. I am doing a program where knowing a "username" I would be able to retrieve user data.

[neilcoffey]

In that case, I still don't understand why you care about the row numbers especially. You'd do a query, e.g.

SELECT Id, FirstName, Surname, ... FROM Users WHERE username = '....';

and then the single row returned by this query would be the one you want.

[mtyoung]

if you know the data type, use resultSet.getXXX(4)
XXX can String, Int etc
read ResultSet (Java Platform SE 6)