java oracle创建表,java在Oracle中建表-JSP教程,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");

}

}

}