1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
| String Request3="SELECT * FROM F_Glossaire ";
Statement stmt3 =null;
ResultSet rs3 = null;
try{
stmt3 = connection.createStatement();
rs3 = stmt3.executeQuery(Request3);
ResultSetMetaData metadata = rs3.getMetaData();
for(int i = 0; i< metadata.getColumnCount(); i++){
int index = i+1;
int typeSQL = metadata.getColumnType(index);
String nomTypeSQL = metadata.getColumnTypeName(index);
String typeJava = metadata.getColumnClassName(index);
System.out.println("INFORMATIONS SUR LA COLONNE D'INDEXE "+index);
System.out.println("Type SQL dans java.sql.Types : "+typeSQL);
System.out.println("Nom du type SQL : "+nomTypeSQL);
System.out.println("Classe java correspondante : "+typeJava);
}
if(rs3.next())
{
//ERREUR DE CONVERSION System.out.println("GL_Text:"+rs3.getString("GL_Text"));
//LA CA MARCHE MAIS JE SAIS PAS LE TRAITER POUR EN FAIRE UN STRING
test = convertStreamToString(rs3.getBinaryStream("GL_Text"));
}
}
catch(Exception d)
{
d.printStackTrace();
}
finally
{
if (stmt3 != null)
try {
rs3.close();
stmt3.close();
} catch (SQLException f) {
f.printStackTrace();
}
} |
