Question

在JAVA中怎样查处数据库中的所有表

用API方法。。JDBC连数据库。。请写出代码。。会重重有赏的

Answer 1

我用的mysql数据库
代码如下
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/my";
String username = "root";
String password = "1";
Connection con = null;
Statement sm = null;
ResultSet rs = null;

Class.forName(driver);

con = DriverManager.getConnection(url, username, password);
sm = con.createStatement();
rs = sm.executeQuery("show tables; ");
while (rs.next()) {
System.out.println(rs.getString("Tables_in_my"));
}
rs.close();
sm.close();
con.close();
------------------------------------------------------
如果你用oracle的话，到PL/SQL里执行下show tables，看看列名是什么，把Tables_in_my替换掉就OK了

Answer 2

select * from sysobjects sql2000数据库中查询所有表的语句

Answer 3

这是一个实例，可以看一下，对数据库的操作是数据库的调用方法：
增加数据：
Connection con = null;

Statement stmt = null;

int row = 0;

//获取GUI信息

String stuID = stuIDTextField.getText();

String stuName = stuNameTextField.getText();

String stuDepart = (String) departComboBox.getSelectedItem();

String stuClass = (String) classComboBox.getSelectedItem();

//检测

if (stuID.equals("") || stuName.equals("")) {

JOptionPane.showMessageDialog(this, "请填写完整");

return;

} else {

try {

//注册直连驱动

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

//建立连接

String url="jdbc:microsoft:sqlserver://localhost:1433;databasename=JDBC_STU";

con = DriverManager.getConnection(url,"sa","sql2008");

//创建执行语句,拼接字符串

String insertsql = "insert into studentinfo values('" + stuID + "','" + stuName + "','" + stuDepart + "','" + stuClass + "')";

stmt = con.createStatement();

注意：驱动的加载和jar包的导入

//发送sql语句

row = stmt.executeUpdate(insertsql);

if (row != 0) {

JOptionPane.showMessageDialog(this, "添加成功");

stuIDTextField.setText("");

stuNameTextField.setText("");

} catch(SQLException ex){

JOptionPane.showMessageDialog(this, "添加失败");

stuIDTextField.setText("");

stuNameTextField.setText("");

} catch (Exception ex) {

ex.printStackTrace();

} finally {

try {

con.close();//关闭连接

} catch (Exception ex) {

ex.printStackTrace();

}

}

}