jdbc 插入数据(包含自增长的序列字段)

ResultSet rsset = null;
PreparedStatement pstmt = null; 
Connection conn = null; 
  try { 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
  conn = DriverManager.getConnection("jdbc:oracle:thin:@10.1.7.79:1521:tjkf", "yhm", "mm");
//书写sql语句，其中第一个字段是插入序列，从序列中查找值
          String sql = "insert into yp_lsgzry   (ID,LSGZRYXM,LSGZRYSFZH,DRR,KSGZSJ,JSGZSJ) values    (seq_yp_lsgzry.nextval,?,?,?,?,?)";
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, name);
   pstmt.setString(2, sf);
   pstmt.setString(3, drr);
   pstmt.setString(4, kssj);
   pstmt.setString(5, jssj);
   rsset=pstmt.executeQuery();
  } catch (ClassNotFoundException e) { 
   e.printStackTrace(); 
  } catch (SQLException e) { 
   e.printStackTrace(); 
  } finally { 
   try {
if(rsset != null) { 
     rsset.close(); 
rsset = null; 
}
    if(pstmt != null) { 
     pstmt.close(); 
     pstmt = null; 
    } 
    if(conn != null) { 
     conn.close(); 
     conn = null; 
    } 
   } catch (SQLException e) { 
    e.printStackTrace(); 
   } 
  } 
}