Java

Voici une classe contient des methodes pour se Conecter a une base de donné SQL Server VIA JAVA,et pour plus d'informations , just repond moi au forum

class Database
{

Connection con;

ResultSet results;

ResultSetMetaData rsmd;

DatabaseMetaData dm;

String catalog;

String types[];

//----------------------------
public Database(String Driver)
{

types = new String[1];

types[0] = "TABLES";

try {
Class.forName(driver);

}
catch(Exception e){
System.out.println("Erreur lors du chargement du driver:"+ e.getMessage());

}
}

//------------------------------------------------------
public void Open(String url,String login,String password)
{

try{
con = DriverManager.getConnection(url,login,password);

dma = con.getMetaData();

results = new resultSet(dma.getCatalogs());

String s[];

while(results.hasMoreElements()) {
s = results.NextElement();

}
}
catch(Exception e){
System.out.println("echec d'ouverture:"+e.getMessage());

}
}

//-----------------
public void Close()
{

try{
con.close();

}
catch(Exception e){
System.out.println("echec lors de la fermeture:"+e.getMessage());

}
}

//-----------------------------
public String[] getTableNames()
{

String[] tbnames = null;

Vector tname = new Vector();

try{
results = new resultSet(dma.getTables(catalog,null,"%",types));

while (results.hasMoreElements())
tname.addElement(results.getColumnValue("TABLE_NAME"));
}
catch(Exception e){
System.out.println(e.getMessage());

}
tbnames = new String[tname.size()];

tbnames = tname.toArray();
return tbnames;

}

//--------------------------------
public String[] getTableMetaData()
{

results = null;

try{
results = new resultSet(dma.getTables(catalog,null,"%",types));

}
catch(Exception e){
System.out.println(e.getMessage());

}
return results.getMetaData();

}

//------------------------------------------------
public String[] getColumnMetaData(String tablename)
{

results = null;

try{
results = new resultSet(dma.getTables(catalog,null,tablename,null));

}
catch(Exception e){
System.out.println(e.getMessage());

}
return results.getMetaData();

}

//------------------------------------------------
public String[] getColumnNames(String table)
{

String[] tbnames = null;

Vector tname = new Vector();

try{
results = new resultSet(dma.getTables(catalog,null,table,null));

while (results.hasMoreElements())
tname.addElement(results.getColumnValue("COLUMN_NAME"));
}
catch(Exception e){
System.out.println(e.getMessage());

}
tbnames = new String[tname.size()];

for(int i=0;i<tname.size();i++)
tbnames[i] = (String)tname.elementAt(i);

return tbnames;

}

//------------------------------------------------
public void getColumnValue(String table, String columnName)
{

try{
if (table.length()>0)
results = Execute("Select "+columnName+" from "+table+" order by "+columnName);

}
catch(Exception e){
System.out.println("Erreur sur la valeur de la colonne "
+columnName+e.getMessage());

}
}

//------------------------------------------------
public String getNextValue(String columnName)
{

String res = "";

try{
if (results.hasMoreElements())
res = results.getColumnvalue(columnName);

}
catch(Exception e){
System.out.println("Erreur sur la valeur suivante "+columnName+e.getMessage());

}
return res;

}

//------------------------------------------------
public resultSet Execute(String sql)
{

results = null;

try{
Statement stmt = con.createStatement();

results = new resultSet(stmt.executeQuery(sql));

}
catch(Exception e){
System.out.println(e.getMessage());

}
return results;

}

}