JDBC compare the content of two tables

[George2]

Hello everyone,

I am using JDBC to compare the content of two database tables -- writing a general function and two tables are input. The two tables have various types of columns, like VARCHAR, BLOB, INT, FLOAT, etc.

I want to save my time to write various statements to get values by different types and compare them, for example, for VARCHAR, I need to use getString and compare the content by String compare function, and for INT column, I need to use getInt and compare with Integer compare function.

I am wondering whether there are any smart way to implement in an uniformed way so that I do not need to write various switches according to column type.

thanks in advance,
George

[jwenting]

Yes and no...
Several things come to mind.

An enum with a lookup method by column type that returns a handler for that column type is the most obvious.
Use a Map of column type names to enum instances for that.

[George2]

Thanks jwenting,

I am not going to compare the column types, but content of table -- rows.

Yes and no...
Several things come to mind.

An enum with a lookup method by column type that returns a handler for that column type is the most obvious.
Use a Map of column type names to enum instances for that.

The two tables are of the same schema -- same column names and column type.

I am interested in your above method. But I still need to program differently for different column types to write equals (or compareTo) method, right?

Are there any ways to implement in an unified coding way independent of column types?

regards,
George

[masijade]

Edit: Nevermind, silly me, thinking of something completely different.

[jwenting]

I am interested in your above method. But I still need to program differently for different column types to write equals (or compareTo) method, right?

Of course. How else are you going to get the data out of the resultset?

[George2]

Hi masijade, any ideas?

Edit: Nevermind, silly me, thinking of something completely different.

regards,
George

[George2]

Hi jwenting,

Of course. How else are you going to get the data out of the resultset?

I want to get the data from each column in a unified way and compare in a unified way. Any ideas?

regards,
George

[jwenting]

the JDBC API has several options that may work.
getBytes(int) and getObject(int) on ResultSet come to mind.

[George2]

Thanks jwenting,

the JDBC API has several options that may work.
getBytes(int) and getObject(int) on ResultSet come to mind.

I want to use getObject method to get the value of each column,
then use equals method of java.lang.Object to compare two columns' values. Is that method workable?

I have a quick question, I think if I use getObject to get a column value
from a table, for example, an Integer column, then when using equals method to compare, I think I am using equals method from java.lang.Integer, other than java.lang.Object, right?

Object int_column_value1 = getObject (...);
Object int_column_value2 = getObject (...);
// to check
int_column_value1.equals (int_column_value2);

regards,
George