Oracle创建表命令 SQL 及 JDBC方式

最新推荐文章于 2022-10-24 16:25:28 发布

原创最新推荐文章于 2022-10-24 16:25:28 发布 · 557 阅读

0 ·

CC 4.0 BY-SA版权

Bee 同时被 3 个专栏收录

314 篇文章

订阅专栏

Java

175 篇文章

订阅专栏

138 篇文章

订阅专栏

本文介绍如何使用Oracle SQL命令创建一个包含多种数据类型的表，并通过Java JDBC实现表的创建。示例表包括主键、字符串类型、数值类型及日期类型等字段。

Oracle创建表命令，

定义主键 id number(12) primary key

亲测（oracle 11g），无语法问题，都能用。

CREATE TABLE orders (
	id number (12) PRIMARY KEY,
	userid varchar2 (20) NOT NULL,
	NAME varchar2 (100),
	total number (12, 2) NOT NULL,
	createtime varchar2 (100),
	remark varchar2 (255),
	sequence varchar2 (30),
	abc varchar2 (20),
	updatetime varchar2 (20)
)

java jdbc 方式：

package org.teasoft.exam.bee.otherdatabase;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import org.teasoft.honey.osql.core.SessionFactory;

public class CreateOracleTable
{
  public static void main(String[] args)
  {
    Connection connection = null;
    try
    {
    	
      connection=SessionFactory.getConnection();
      Statement statement = connection.createStatement();
      
      //String sql0="drop table orders" ; //删除表
      //statement.executeUpdate(sql0);
      
      String sql=""
      		+ " CREATE TABLE orders ("+
    	      " id number(12) primary key,"+  
    	      "  userid varchar2(20)  NOT NULL,"+
    	      "  name varchar2(100) ,"+
    	      "  total number(12,2) NOT NULL,"+
    	      "  createtime varchar2(100) ,"+
    	      "  remark varchar2(255) ,"+
    	      "  sequence varchar2(30)  ,"+
    	      "  abc varchar2(20) ,"+
    	      "  updatetime varchar2(20)"+
    	      ") ";
      
      
      System.out.println(sql);
      statement.executeUpdate(sql);
      
      System.out.println("Create Oracle tables finished.");
      
    }catch (SQLException e) {
		System.err.println(e.getMessage());
		} finally {
			try {
				if (connection != null) connection.close();
			} catch (SQLException e) {
				System.err.println(e.getMessage());
			}
		}
	}
}

maven:

       <dependency>
           <groupId>org.teasoft</groupId>
           <artifactId>bee</artifactId>
           <version>1.8.99</version>
       </dependency>

       <dependency>
           <groupId>org.teasoft</groupId>
           <artifactId>honey</artifactId>
           <version>1.8.99</version>
       </dependency>