Ecco il codice per fare lo SHOW STATUS di MySQL in Java. Per fare questo programma ho impiegato 15 minuti. E' veramente semplice. Seguite i commenti.
// showstatus.java
import java.sql.*;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
class showstatus
{
private static Connection conDb;
// check the correct values of followings variables
private static String JDBC_DRIVER = "com.mysql.jdbc.Driver";
private static String JDBC_URL = "jdbc:mysql://127.0.0.1:3306/";
private static String JDBC_NAME = "root";
private static String JDBC_PASSWORD = "password";
public static void main(String[] args)
{
System.out.println( "Start" );
// driver
try
{
Class.forName( JDBC_DRIVER );
}
catch (Exception ex)
{
System.out.println( "Error Class.forName "+ex );
ex.printStackTrace();
System.exit(0);
}
// connection
try
{
conDb = DriverManager.getConnection(JDBC_URL, JDBC_NAME, JDBC_PASSWORD);
}
catch (Exception ex)
{
System.out.println( "Error getConnection "+ex );
ex.printStackTrace();
System.exit(0);
}
// Show Status
String query = "SHOW STATUS";
PreparedStatement ps;
ResultSet rs;
try
{
ps = conDb.prepareStatement(query);
try
{
rs = ps.executeQuery( query );
int cnt = 0;
try
{
while (rs.next()) // are there more 'Variable_name'?
{
String variableName = rs.getString("Variable_name");
String value = rs.getString("Value");
System.out.println( "variableName: "+variableName+" - Value: "+value );
// NOTE: value is String ...
// Is possible to convert it with the fllowing istruction:
// Integer.parseInt( value )); // only if numeric!!!
//System.out.println( "Integer.parseInt( value ) "+Integer.parseInt( value ));
}
}
catch (Exception ex)
{
System.out.println( "Error executeQuery "+ex );
ex.printStackTrace();
System.exit(0);
}
}
catch (Exception ex)
{
System.out.println( "Error executeQuery "+ex );
ex.printStackTrace();
System.exit(0);
}
}
catch (Exception ex)
{
System.out.println( "Error prepareStatement "+ex );
ex.printStackTrace();
System.exit(0);
}
System.out.println( "End" );
}
}
