繁体中文
设为首页
加入收藏
当前位置:JSP技术首页 >> 资料/其它 >> java在Oracle中建表

java在Oracle中建表

2005-04-15 08:00:00  作者:  来源:互联网  浏览次数:0  文字大小:【】【】【
简介:import java.net.URL; import java.sql.*; public class Create { public Create() { } public static void main(String[] args){ String url = "jdbc:oracle:thin:@10.0.1.3:1521:SDCDB"; String query = "CREA...
关键字:中建 Oracle java

import java.net.URL;

import java.sql.*;

public class Create {

public Create() {

}

public static void main(String[] args){

String url = "jdbc:oracle:thin:@10.0.1.3:1521:SDCDB";

String query = "CREATE TABLE testTable" + "(id INT,name CHAR(10))";

try

{

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn = DriverManager.getConnection(url, "test", "test");

Statement stmt = conn.createStatement();

stmt.executeUpdate(query);

System.out.println("Create Success!");

stmt.close();

conn.close();

}

catch(java.lang.ClassNotFoundException e){

System.err.print(e.getMessage());}

catch(SQLException ex){

System.out.println("\n***SQLException caught ***\n");

}

}

}

责任编辑:admin
相关文章