JavaDB-检查数据库是否存在 [英] JavaDB - Checking if a database exists

问题描述

我们创建了一个Java应用程序，该应用程序使用Netbeans IDE中的JavaDB数据库.我们希望程序在每次启动时检查是否已创建数据库表，否则请创建它们. 我们该怎么做? 谢谢

We created a java application which uses the JavaDB database in Netbeans IDE. We want the program to check every time it starts if the database's tables have already been created, and otherwise create them. How do we do that? thanx

推荐答案

我使用了:

DatabaseMetaData metas;
ResultSet tables;
Statement stat;

m_connexion = DriverManager.getConnection("jdbc:derby:mybase;create=true");
metas = m_connexion.getMetaData();
stat = m_connexion.createStatement();
tables = metas.getTables(m_connexion.getCatalog(), null, "MYTABLE", null);
if (!tables.next())
  stat.execute(
    "CREATE TABLE APP.MYTABLE (" // etc.

...这对我有用.

... and it's work for me.

这篇关于JavaDB-检查数据库是否存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！