展开全部
详细参32313133353236313431303231363533e4b893e5b19e31333337376263考文章:http://www.yuanxingyuan.com/?id=18
可以的,使用Statement 的 executeQuery,示例代码:public static List getDBMasterStatus() {
List status = new ArrayList();
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/sshdb";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, "root", "123456");
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("show master status");
while(rs.next()) {
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
}
rs.close();
stm.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
return status;
}