《Java操作Oracle数据库(建表插数据删除)》由会员分享,可在线阅读,更多相关《Java操作Oracle数据库(建表插数据删除)(2页珍藏版)》请在金锄头文库上搜索。
1、文档供参考,可复制、编制,期待您的好评与关注! import .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=inse
2、rt into MYFIRST values(2,mm);String sql2=delete MYFIRST where id=2;tryClass.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); /