序列：CREATE SEQUENCE U_001.RDLSEQ INCREMENT BY  START WITH  MINVALUE  CACHE 

触发器：create or replace trigger u_001.RDLCF //触发器：u_001为用户 . 你创建的触发器的名字

           before insert on u_001.R_DL   //在那个用户下面u_001的那个表上创建

        for each row

           begin

           select u_001.RDLSEQ.nextval into :new.id from dual;     //select  后面是 用户.刚刚创建的序列的 名字.nextval into :new . 这是你需要自增长的列名

        end RDLCF;

@Test

    public void addUserSeq() {

        try {

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

             String url = "jdbc:oracle:" +

                     "thin:@192.168.0.4:1521:orcl";

            // 127.0.0.1是本机地址，XE是精简版Oracle的默认数据库名

            String u = "system";// 用户名,系统默认的账户名

            String p = "***";// 你安装时选设置的密码

            System.out.println("显示url:" + url);

            Connection con = DriverManager.getConnection(url, u, p);// 获取连接

//            String sql="CREATE SEQUENCE U_001.RDLSEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 CACHE 50";    创建序列

//            System.out.println("执行的sql语句"+sql);

//            java.sql.PreparedStatement ps = con.prepareStatement(sql);

//            ps.executeUpdate();  执行创建序列

//

//            String sql2=" create or replace trigger u_001.RDLCF \r\n" +     创建触发器的sql代码

//                    "           before insert on u_001.R_DL\r\n" +

//                    "        for each row\r\n" +

//                    "           begin\r\n" +

//                    "           select u_001.RDLSEQ.nextval into :new.id from dual;\r\n" +

//                    "        end RDLCF;";

//            System.out.println("执行的sql语句"+sql2);

            Statement ps2 = con.createStatement();      //在这是不能用 prepareStatement的，会报啥 索引缺少in或out参数，可能是这个的保护措施啥的，用普通的statement就可以

            String ss="insert into U_001.R_DL(sjlx) values ('4')";

            ps2.execute(ss);

        }catch (Exception e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }