jdbc中使用序列

SequenceDemo.java :

public class SequenceDemo {public static void main(String[] args) {insert();}public static void insert(){Connection conn=null;PreparedStatement pstmt=null;String sql="insert into mystu(id,name,age,gender) values(myseq.nextval,?,?,?)";try {Class.forName("oracle.jdbc.driver.OracleDriver");conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");pstmt=conn.prepareStatement(sql);pstmt.setString(1,"tom");pstmt.setInt(2,25);pstmt.setString(3,"M");pstmt.execute();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}finally{//關閉資源}}}