How to recover part of compound data with JDBC?

Question

How to recover part of compound data with JDBC?

Navigation

#1 by (0 votes)

0

I have a small application that connects with postgresql , it stores 2 objects,

Equipment that has three values: store type String , range type String and finally price type int .

To store them, I occupy a type composed of the three values that I have called datosPC .

Componentes that I save it with a array of 3 data type string in the database.

My question: When doing the resultSet, how can I retrieve one of the Team values? And to recover a value of Components?

Thanks for your time!

java postgresql jdbc

asked by Jota 28.10.2016 в 13:29

source

1 answer

Error Can not read property 'then' of undefined in md-autocomplete of Angular-material Use a Storyboard for various controls

score 0 · Answer 1

Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM mytable WHERE columnfoo = 
500");
while (rs.next())
{
System.out.print("Column 1 returned ");
System.out.println(rs.getString(1));
}
rs.close();
st.close();