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 myfirst" + "(id int,name char(10))";

string sql="insert into myfirst values(1,liming)";

string sql1="insert into myfirst values(2,mm)";

string sql2="delete myfirst where id=2";

try

{

class.forname("oracle.jdbc.driver.oracledriver");

connection conn = drivermanager.getconnection(url, "test", "test");

statement stmt = conn.createstatement();

stmt.executeupdate(query);

stmt.executeupdate(sql);

stmt.executeupdate(sql1);

stmt.executeupdate(sql2);

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");

}

}

}