下面是我做的返回所有数据库信息的代码,希望对你有帮助/*
前期工作:用odbc建一个SQL连接,我这里连接名为:MyDataTest
*/
import java.sql.*;
public class Lookup {
public static void main(String[] args) {
try {
Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(
"jdbc:odbc:MyDataTest","sa","");
Statement s = c.createStatement();
ResultSet r =
s.executeQuery("sp_helpdb");
while(r.next()) {
System.out.println(
r.getString("name") + ", "
+ r.getString("db_size")
+ ": " + r.getString("owner")
+ ": " + r.getString("dbid")
+ ": " + r.getString("created")
+ ": " + r.getString("status")
+ ": " + r.getString("compatibility_level"));
}
s.close();
} catch(Exception e) {
e.printStackTrace();
}
}
}
前期工作:用odbc建一个SQL连接,我这里连接名为:MyDataTest
*/
import java.sql.*;
public class Lookup {
public static void main(String[] args) {
try {
Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(
"jdbc:odbc:MyDataTest","sa","");
Statement s = c.createStatement();
ResultSet r =
s.executeQuery("sp_helpdb");
while(r.next()) {
System.out.println(
r.getString("name") + ", "
+ r.getString("db_size")
+ ": " + r.getString("owner")
+ ": " + r.getString("dbid")
+ ": " + r.getString("created")
+ ": " + r.getString("status")
+ ": " + r.getString("compatibility_level"));
}
s.close();
} catch(Exception e) {
e.printStackTrace();
}
}
}
ResultSet r =
s.executeQuery("sp_helpdb");你用execute()当然不对了·!!
cstmt.setString(1,operid);
cstmt.execute();
?代表你存储过程的参数。