Ciao raga...
Ho un problemino...Che vi spiego subito...
Ho creato una Java Application che mi estrae le info da un DB. Le info estratte le metto in un vettore e viene fuori
la seguente cosa:
[18412 --- Description@ --- value1@, 18412 --- Comment@ --- value2@]
cioe'
[id istanza --- Nome Attributo ---ValoreAttributo]
E fin qui tutto ok....
Adesso il main (che stampava nella consolle di eclipse il vettore) diventa una classe normale, mentre il nuovo main deve crearmi una cosa del genere a partire dal vettore:
<?xml version="1.0" ?>
-
<?xml: stylesheet type="text/xsl" href="usage.xsl"?>
- <Table>
- <INSTANCE Id="18412">
<ATTRIBUTE name="Description@">value1@</ATTRIBUTE>
<ATTRIBUTE name="Comment@">value2@</ATTRIBUTE>
</INSTANCE>
</Table>
Qualcuno mi sa aiutare???
Vi posto il main che stampa a video il vettore di risultati:
ViewTestData.java
package it.dpp.test;
import it.dpp.attribute.Attribute;
import it.dpp.exception.MyException;
import it.dpp.query.ExtractionQuery;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
public class ViewDataTest {
public static void main(String[] args) throws SQLException, MyException {
ExtractionQuery eq = new ExtractionQuery();
ExtractionQuery eq2 = new ExtractionQuery();
ExtractionQuery eq3 = new ExtractionQuery();
ExtractionQuery eq4 = new ExtractionQuery();
ExtractionQuery eq5 = new ExtractionQuery();
ExtractionQuery eq6 = new ExtractionQuery();
ExtractionQuery eq7 = new ExtractionQuery();
ExtractionQuery eq8 = new ExtractionQuery();
ExtractionQuery eq9 = new ExtractionQuery();
String tmpNameAttr = null;
Vector<Attribute> attrPairList = new Vector<Attribute>();
Integer nClassId = null;
Integer nAttributeId = null;
Integer nInstanceId = null;
Integer nType = null;
try
{
ResultSet rs = eq.query("id", "class", "name", "Performer@");
while (rs.next())
{
nClassId = new Integer (rs.getInt("id"));
ResultSet rs2 = eq2.query("id", "instance", "class", nClassId.toString());
while (rs2.next())
{
ResultSet rs3 = eq3.query("id, name, type", "attribute", "owner", nClassId.toString());
nInstanceId = new Integer (rs2.getInt("id"));
while (rs3.next())
{
Attribute attr = new Attribute();
nAttributeId = new Integer (rs3.getInt("id"));
tmpNameAttr = new String (rs3.getString("name"));
attr.setId_instance(nInstanceId.intValue());
try
{
nType = new Integer(rs3.getInt("type"));
attr.setName(tmpNameAttr);
switch (nType.intValue()) {
case 0:
{
ResultSet rs4 = eq4.query2("value", "instattr_integer", "instance", "attribute", nInstanceId.toString(), nAttributeId.toString());
while (rs4.next())
{
attr.setValue(rs4.getString("value"));
}
rs4.close();
}
break;
case 1:
{
ResultSet rs5 = eq5.query2("value", "instattr_double", "instance", "attribute", nInstanceId.toString(), nAttributeId.toString());
while (rs5.next())
{
attr.setValue(rs5.getString("value"));
}
rs5.close();
}
break;
case 7:
{
ResultSet rs6 = eq6.query2("value", "instattr_long", "instance", "attribute", nInstanceId.toString(), nAttributeId.toString());
while (rs6.next())
{
attr.setValue(rs6.getString("value"));
}
rs6.close();
}
break;
case 9:
{
ResultSet rs7 = eq7.query2("toiname", "interref", "instance", "attribute", nInstanceId.toString(), nAttributeId.toString());
while (rs7.next())
{
attr.setValue(rs7.getString("toiname"));
}
rs7.close();
}
break;
case 12:
{
ResultSet rs8 = eq8.query2("topname", "instattr_reporef", "instance", "attribute", nInstanceId.toString(), nAttributeId.toString());
while (rs8.next())
{
attr.setValue(rs8.getString("topname"));
}
rs8.close();
}
break;
case 2:
case 4:
case 5:
case 6:
case 8:
case 10:
{
ResultSet rs9 = eq9.query2("value", "instattr_string", "instance", "attribute", nInstanceId.toString(), nAttributeId.toString());
while (rs9.next())
{
attr.setValue(rs9.getString("value"));
}
rs9.next();
}
break;
default:
{
//System.out.println("Error Switch");
}
}
}
catch (SQLException e) {
e.printStackTrace();
}
attrPairList.addElement(attr);
}
rs3.close();
}
rs2.close();
}
rs.close();
System.out.println(attrPairList);
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
Grazie...Aspetto lumi...
Thanks e ciao....

Rispondi quotando