JDBC连接OracleXE实例

步骤：
1. 创建OracleXE用户
2. 给予用户必要的权限
3. SQL建表并插入数据
4. 写Java连接数据的源代码

1. 创建OracleXE用户
   命令：

create user michael identified by michael;
alter user michael default tablespace sysaux quota 10M on sysaux;

2. 给予用户必要的权限
   命令：

grant create session to michael;
grant create table to michael;


3. SQL建表并插入数据
   命令：

create table student (
    id number
);
insert into student values(2005);
insert into student values(2008);

4. 写Java连接数据的源代码
   源程序：

package com.dlut.zxf;

import java.sql.*;

public class Conn {
    public static void main(String[] args) {        
        String classDriver = "oracle.jdbc.driver.OracleDriver";
        String dbURL = "jdbc:oracle:thin:@localhost:1521:xe";
        String user = "michael";
        String password = "michael";
        
        String sql = "select id from student";    
        Connection conn = null;
        Statement state = null;
        ResultSet res = null;
        
        try
        {
            Class.forName(classDriver);
        }
        catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        }
        try
        {
            conn = DriverManager.getConnection(dbURL, user, password);
            state = conn.createStatement();
            res = state.executeQuery(sql);
            while (res.next())
            {
                System.out.println(res.getString("id"));
            }
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }        
        
    }
}