MySQL中判斷表是否存在:
1. SHOW   TABLES   LIKE   '%tb_bp_d_case%';  

2. select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA`='dbname' and `TABLE_NAME`='tablename' ;

3. 如果表不存在就建立這個表，那么可以直接用 create table if not exists tablename 這樣的指令來建立，不需要先去查詢表是否存在。

4. 從模板表創建表：create table if not exists like old_table_name;

文章出處：DIY部落(http://www.diybl.com/course/7_databases/mysql/Mysqljs/20090313/161045.html)

[ 原創 ] JDBC 如何連接 SQL SERVER 2000 的默認實例和命名實例

?

引用請注明出處 :http//www.tkk7.com/SINOJAVA

?

( 一 ) 下載 Microsoft SQL Server 2000 Service Pack 3a 并安裝
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=zh-cn

?

( 二 ) 下載并安裝 SQL SERVER 2000 得 JDBC 驅動 ( SQL Server 2000 Driver for JDBC Service Pack 3 )

http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

?

( 三 ) 配置 JDBC 驅動 classpath 環境變量 :

方法 1:

?

填加 :

C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;

C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;

C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;

?

注 : C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\ 為我 JDBC 得安裝路徑

?

方法 2:

?

將 mssqlserver.jar; msutil.jar; msbase.jar 拷貝到 JDK 得 lib 目錄下 , 然后設置 classpath

?

D:\Java\jdk1.5.0_05\lib\sqlserver\msutil.jar;

D:\Java\jdk1.5.0_05\lib\sqlserver\msbase.jar;

D:\Java\jdk1.5.0_05\lib\sqlserver\mssqlserver.jar;

?

( 四 ) 創建連接數據庫默認實例得連接代碼 :

?

import java.sql.*;

public class ConSqlserver {

????

???? Connection con=null;

???? //Statement st=null;

???? //ResultSet re=null;

????

???? public ConSqlserver()

???? {

??????????? try

??????????? {

??????????? ??? String driver="com.microsoft.jdbc.sqlserver.SqlServerDriver";

??????????? ??? String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind";

??????????? ??? Class.forName(driver).newInstance();

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

??????????? ??? System.out.println(" 連接成功 !");

??????????? ??? con.close();

???????????

??????????? }

??????????? catch(Exception e)

??????????? {

?????????????????? e.printStackTrace();

??????????? }

???????????

???????????

???? }

?

?????? public static void main(String[] args)

???? {

??????????? // TODO 自動生成方法存根

??????????? ConSqlserver con=new ConSqlserver();

???????????

?

???? }

?

}

?

( 五 ) 創建連接數據庫命名實例的連接代碼 ( 實例名為 SINOIT\SINOSERVER) L

?

import java.sql.*;

public class ConSqlserverppp {

????

???? Connection con=null;

???? //Statement st=null;

???? //ResultSet re=null;

????

???? public ConSqlserverppp()

???? {

??????????? try

??????????? {

??????????? ??? //String driver="com.microsoft.jdbc.sqlserver.SqlServerDriver";

???? ?????? ??? String url="jdbc:microsoft:sqlserver://SINOIT\\SINOSERVER;DatabaseName=Northwind";

??????????? ???

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

??????????????????

??????????? ??? //Class.forName(driver);//.newInstance();

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

??????????? ??? //st=con.createStatement();

??????????? ??? System.out.println(" 連接成功 !");

??????????? ??? con.close();

???????????

??????????? }

??????????? catch(Exception e)

??????????? {

?????????????????? e.printStackTrace();

??????????? }

???????????

???????????

???? }

?

???? public static void main(String[] args)

???? {

???????????

??????????? ConSqlserverppp con=new ConSqlserverppp();

???? }

?

}

我的blog開業了,歡迎大家前來支持,謝謝!!