java oracle数据库表,Java创建Oracle数据库表

package utility.mysql;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.HashMap;

import java.util.Map;

import java.util.Properties;

public class DbUtility {

public static void main(String[] args) throws IOException {

String db_url = DbUtility.getDbInfo().get("db_url");

String db_user = DbUtility.getDbInfo().get("db_user");

String db_pwd = DbUtility.getDbInfo().get("db_pwd");

Connection conn = DbUtility.getConn(db_url, db_user, db_pwd);

String cmd = "create table test (id number(5), name varchar(10))";

DbUtility.updateCMD(conn, cmd);

}

public static void updateCMD(Connection conn, String cmd) {

try {

Statement stmt = conn.createStatement();

stmt.executeUpdate(cmd);

} catch (SQLException e) {

e.printStackTrace();

}

}

public static Connection getConn(String url, String user, String pwd) {

Connection conn = null;

try {

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

conn = DriverManager.getConnection(url, user, pwd);

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public static Map getDbInfo() throws IOException {

Map map = new HashMap();

Properties p = new Properties();

InputStream in = Object.class.getResourceAsStream("/config.properties");

try {

p.load(in);

} catch (IOException e) {

e.printStackTrace();

}

map.put("db_user", p.getProperty("db_user"));

map.put("db_pwd", p.getProperty("db_pwd"));

map.put("db_url", p.getProperty("db_url"));

return map;

}

}