package data;
import java.sql.*;
import java.util.*;


public class DB
{

public DB()
{
}

public boolean esegui(String command) throws Exception
{

// Questo metodo serve per le operazioni INSERT / UPDATE / DELETE
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbcdbc:betting";

Connection connection=DriverManager.getConnection(url,"root", "xxxxx");

Statement statement = connection.createStatement();

int n = statement.executeUpdate(command);

statement.close();
return true;

}
catch(SQLException sqlEx)
{
System.out.println(sqlEx);

}
catch (ClassNotFoundException cnfEx)
{
System.out.println(cnfEx);

}


}

public String query(String command)throws Exception
{

try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbcdbc:Personale";

Connection connection=DriverManager.getConnection(url,"root", "xxxxx");


Statement statement = connection.createStatement();

ResultSet r = statement.executeQuery(command);
if (r==null)
{

}
StringBuffer s = new StringBuffer(); // a partire dal ResultSet
ResultSetMetaData rmeta = r.getMetaData(); // costruisco il MetaData
int numColumns=rmeta.getColumnCount();


// Questo ciclo serve a stampare i nomi delle colonne

for(int i=1;i<=numColumns;++i)
{
if(i<numColumns)
s.append(rmeta.getColumnName(i)+" | ");
else
s.append(rmeta.getColumnName(i));
}
s.append("\n");


// Questo ciclo per ogni riga stampa tutti i campi

while(r.next())
{
for(int i=1;i<=numColumns;++i)
{
if(i<numColumns)
s.append(r.getString(i)+" | ");
else
s.append(r.getString(i).trim());
}
s.append("\n");
}

}
catch(SQLException sqlEx)
{
System.out.println(sqlEx);

}
catch (ClassNotFoundException cnfEx)
{
System.out.println(cnfEx);

}
return s;

}
}





C:\data\DB.java:108: cannot resolve symbol
symbol : variable s
location: class data.DB
return s;
^
1 error

Procedura completata con codice di uscita 1


Perchè mi dà quest'errore????


Grazie 1000